I mentioned in an earlier post that I developed a bridge application to help facilitate payroll entry. I've actually developed several of these applications for different clients, based on the unique layouts of the individual payroll files.
We typically evaluate a candidate for such an application based on the following criteria:
- The client is not using our web-based method of submitting payroll
- The client has 40 or more active employees
- The client submits their payroll as an attachment via electronic mail
To accomplish this, I created a "wrapper" application, a "master" application, in Microsoft Access, with a form containing a list of all the clients who have one of these applications. The payroll specialist double-clicks the client's name, and that simultaneously launches the individual bridge application and closes the master/wrapper application. Each payroll specialist has a shortcut to this application on their desktop.
As I develop new bridge applications, I simply add a record with the required information to the table in the the wrapper application.