Access and QR Codes

Question

I was wondering if it was possible to use QR codes to fill out access forms. What I am thinking is having an access form and when a QR code is scanned it will fill out the part number field in the form. Is this possible?

Answer 1

Hi Kasey, I'm an independent advisor and can help.

The answer is a qualified yes. Any barcodes can be used to input into Access. The way barcodes work is the scanner represents an alternate input device. It substitutes for a keyboard. Software that comes with scanner wand will read the code and place the actual values into a text receptacle in your Access form or anywhere that has focus on the PC.

You then have to determine what the form will do with the data.

Answer 2

Sorry Kasey, I just saw this reply. This depends on the scanner used. Scanning a barcode is just the same as entering data through a keyboard. You scan the barcode and the data appears in the control on your form. How the scanner interfaces depends on your scanner. Once scanned into the control you can analyze by parsing it in Access and populate the data accordingly.

Answer 3

How would I determine what Access does with the data? I have a form with a combo box part number that auto fills a point value and a time stamp then totals all the points of the day together. How would I get Access to know when a QR Code is scanned to fill out the combo box so everything runs together?