HI, Access VBA expert here. What I can offer you :
1. All the required data tables with very interactive user forms to perform data operations like insert, update, delete on them, for the ease of data operations the user forms will have auto filling fields, pop up calenders for easy date entry, dropdown menus and list boxes for easy data selection.
[login to view URL] invoicing I shall use access reports which will be dynamic in nature, i.e. the controls (textboxes ,Labels,formatting lines,tables) will not be fixed but they and their count will change from invoice to invoice, reason being that one invoice may have two items invoiced, another may have four, five or [login to view URL] note that the access reports will be used to produce/print the final invoice and not for entering the invoice information in the datatable for this purpose we will use forms.
3. To enter the invoice info, on the forms we shall use a combination of dropdown controls and list boxes, i.e select an item in the dropdown and add to list box, repeat this process till its done.
4. every item to be invoiced will have associated data like cost, now how to store this information in data table i.e. how to correlate the info stored in various columns of the data table ?? I have the logic to achieve this functionality.
I want to send you a DEMO application to give you an idea of the functionality I can offer, this demo will have invoice with LOGO and functionality to print invoice, if you reply to this mesg I will be able to mail you