I have an MS Access 2000 database that I enter supplier invoices into. I would like to be able to enter a new record then put the original copy of the invoice in my twain compatable scanner click on a button on the form in Access and have it scan the document and save it with a file name consisting of the supplier name, invoice number and invoice date. eg Smith&Co_256_30-06-03.jpg. I would like the code to be written in VBA whithin Access but if not possible maybe it could call a .exe written in Visual Basic 5 or 6. Please see a sample database with an appropriate form attached.
1) Complete and fully-functional working program(s) in executable form as well as complete source code of all work done. 2) Installation package that will install the software (in ready-to-run condition) on the platform(s) specified in this bid request. 3) Complete ownership and distribution copyrights to all work purchased.
VBA, MS Access, Windows 9x, 2000, XP