troubleshooting
Migrating Existing Access Applications to Access 2007
This post is one of the more esoteric ones where I delve into the geeky details of some of my programming work. I know – it’s really sexy, isn’t it? I have mentioned the bridge application I developed that helps make payrolls run faster, helping client employees get paid faster, and so forth, using Microsoft [...]
The output is only as good as the input
Part of what I do in my current work is produce ad hoc reports. I often am asked about the information in them because it doesn’t appear to match what decision makers had assumed. The information on the reports is only as good as the raw data that exists in the system, I tell them. [...]
Handling errors in the payroll bridge application
Clients email the company their payroll files, and the columns on the payroll indicate Regular Hours, Overtime, Vacation, and so forth. To make the bridge application work, I and the other developer map the program that assigns payroll items based on this layout. It only works, however, when the layout is consistent. Whenever a client [...]
Rapid response to payroll layout change
One hour ago I got an e-mail from a payroll specialist, telling me that a client with 107 active employees had added a column to their payroll file and asking if I could fix their bridge application to allow for the new payroll item. I opened the code, and after I made the changes needed [...]
Fixing the client’s 401(k) reporting application to make it run better
The company didn’t have a process in place to make sure that this one client receives their 401(k) information on a regular basis. I had developed an application last fall for this specific client to produce the information, but there was no one set up specifically to run the application on a regular basis. I [...]
New bridge applications for trucking companies to significantly reduce payroll processing time
Whew! It’s been a busy day. I spent some of my morning interviewing payroll specialists about potential client candidates for a bridge application. Over the next month or so, we’ll be adding several new clients, so anything the IT group can do to better facilitate payroll entry has been greatly appreciated. Some clients use the [...]
Troubleshooting warnings to make bridge application run smoother
Little things. We ran the new bridge application I mentioned earlier this week for the client’s payroll. When our integration manager program got a hold of the results, it returned warnings that were not at first easy to understand. When I talked about it with the payroll specialist, she mentioned that two people were set [...]

