QR Codes in Access

Question

I am building an item->location database and I want to use QR codes to keep up with the item and what location they are in. I have built the tables with the items and locations but I'm having trouble figuring out the best way to get them connected with QR without going to a 3rd party program. I need this to work without internet as part of the locations are out of service.

Answer 1

A QR code is simply another way of representing a text string; many commercial QR code readers can be used to read the code from a scanned image. The input is just "seen" by the program as if someone were typing very fast and accurately. The scanner hardware will come with software to connect to your computer input. Similarly, most scanner vendors provide fonts which print a text string into a QR image; such fonts are also available online. Generally no special programming is needed - the scanner reads a text string, and any graphic printer can print a text string into a code.

Answer 2

Access – QR Code Generator | DEVelopers HUT (devhut.net)

Answer 3

if you want to scan throug iphone or android phone without specific app, encode a url to qrcode which be visited by web browser and send data to backend database.

above are sample qrcodes for insert log.

Answer 4

Hi George,

The tables have to be in a server-based database, not an accdb, though.

...or even in an Excel workbook, if you don't have many items, just not in an accdb.

SCNR

Karl

(Going hybrid with Access+Power Apps)

Answer 5

I started looking more into what programs will allow me to scan straight into Access. I have a pallet and a location and when I move the pallet I want to just scan the new location and it will update into my database. If you have any suggestions I'm open to that, I've only just started looking into that avenue. Thank you for all your advise!