We are looking for a system in MS Access / VBA with the following functionality.
A screen where a user can press a button to print a report with 7 QR codes on it.
These QR codes will be generated randomly (VBA code for this is written already)
Each time the button is pressed, 7 new QR codes will be generated and the report will be printed.
Another screen will be used for testing the QR codes. A couple of times a day, the employee will randomly test some QRcodes to see if they exist in the database. The content of the QR code will be read using a 2D barcode scanne (behavior scanner is like an ordinairy keyboard and after the scan an Enter is given)
A function should be written that will upload all the records in the table that haven’t been uploaded before to a FTP site, as a CSV file. For example at the end of the day we will call this function to upload the production of this day to an external FTP site. There the CSV file will be imported in a web based database and the QR codes are ready for use. This external part, the web database and the website are outside the scope of this project.
If there is need for third party software for the generation of the QR codes, please state this price separately in your bid. The software will run on a single machine.