Clients and Projects

Lansbury International contacted me to ask if I could create an application that would provide pre configured details to be printed onto multi-part stationary.

The client needed to be able to modify what information is available to staff using the system while maintaining a level of control over what appeared on the invoices.

This was achieved using Access to hold tables of information used to populate text boxes and drop down combo boxes which appear on the invoice printing form.

The invoice printing form provides tick boxes for the user to select which parts of the information shall appear on the printed invoice, it also allows the entry of some costs, while other costs come directly from the back-end data tables.

The application calculates costs on the invoice by multiplying each line item cost by quantity supplied, and then calculates totals taking the selected rate of VAT into account.

The invoice report was provided to the client in such a way that permitted them to make minor adjustments to the positioning of all the printed elements, thereby ensuring pixel perfect alignment using the clients own printer.





See examples of some of my Microsoft Access Development and VBA Programming Projects here...