Hi guys,
I have a program in Access 2016 for barcode scanning and matching.
We receive files with orders (barcode, product, quantity, shipdate) and make an orders-table of it. Then I have a form/scantable for scanning the barcode and fill some columns with the information of the orders-table. There is VBA code after scanning each barcode to do some checks and to get data from the orders-table. With this form/scantable we can make query’s and reports.
Now sometimes we don’t receive all orders-files but we receive the physical products with the order information printed on it. At this moment we scan these barcodes Excel and put the products in the right location. After we receive the file(s), we are watching the barcodes in Excel.
I want to be able to do this in Access. So I think I have to create a separate form/table for scanning these barcodes without the order information. After receiving the order-file I want to process the barcodes of this table to the form/scantable with the VBA code run for each barcode.
I’m a newbe in VBA. Can someone put me in the right direction?
Maybe I can just scan them as if there would be data, and afterwards run the VBA-code for this barcodes again someway for these scans.