Barcodes (1 Viewer)

[JPFred]

I ordered a bar code scanner to play around with scanning barcodes into a ms access database. Does anyone have any code examples to link the scanner to the database to do immediate and/or batch scanning?

I am going to take the Christmas break to see if I can make it work.

Thanks in advance,

Doc

 

[theDBguy]

Hi. There should be no code needed. Access should treat the barcode scanner just like any other input device like the mouse or the keyboard.

 

[Uncle Gizmo]

The barcode scanner should work perfectly straight out of the box, just don't mess around with the set-up codes.

Set your cursor in any text box on any form and point the barcode scanner at a barcode, pull the trigger and the information from the barcode will appear in the text box, just as if you typed it in with the keyboard. In fact, that's how the barcode scanner works it duplicates the functionality of the keyboard.

 

[JPFred]

That sounds GREAT! I will get the scanner on the 21st and give it a try. Thanks!

 

[theDBguy]

That sounds GREAT! I will get the scanner on the 21st and give it a try. Thanks!

Good luck and let us know how it goes.

 

[JPFred]

Good luck and let us know how it goes.

Just an update ... I did get the scanner in and it seems to work just fine. As you mentioned when I pull the trigger while on a text box the information is automatically entered. I went one step further and downloaded a free barcode font that gives me the ability to create and print out barcodes. Is there a font out there for the qr codes? I have been looking but have not found one yet.

Supper big thanks to all of you for your help!

 

[Uncle Gizmo]

You probably want to avoid using QR codes with MS Access, see my comments on it on my website here:-

Barcodes - Nifty Access

Barcodes Bar-codes along with a bar-code scanner can be a very useful feature to add to your database. You can quickly scan in serial numbers from mass deliveries of items / components. Bar codes are also very handy for managing the repair process of an item returned for repair. For example, by...

www.niftyaccess.com

With regard to generating QR codes in MS Access, there have been several threads in access world forums about it, I particularly recall this long thread, the QR code discussion started Here:-

VBA barcode code generator not working

Unfortunately I've got 64-bit, and it doesn't work for me with the "Value" .... I've got a couple of other things to try. I'm using MS Access 2016 on a 64-bit machine, and the code works fine. Initially it didn't. I discovered that because I use "Option Explicit" by default the line of code...

www.access-programmers.co.uk

I don't think it is possible yet, not without some sort of web interface. As I say on my website it's probably not the way to go, QR codes are for storing a lot of information, probably overkill with in MS Access.

 

[isladogs]

There isn't such a thing as a QR font.
However you can generate QR codes successfully in Access.
See this sample database (1) QRCode Image Generator | Access World Forums (access-programmers.co.uk)

 

[JPFred]

You probably want to avoid using QR codes with MS Access, see my comments on it on my website here:-

Barcodes - Nifty Access

Barcodes Bar-codes along with a bar-code scanner can be a very useful feature to add to your database. You can quickly scan in serial numbers from mass deliveries of items / components. Bar codes are also very handy for managing the repair process of an item returned for repair. For example, by...

www.niftyaccess.com

With regard to generating QR codes in MS Access, there have been several threads in access world forums about it, I particularly recall this long thread, the QR code discussion started Here:-

VBA barcode code generator not working

Unfortunately I've got 64-bit, and it doesn't work for me with the "Value" .... I've got a couple of other things to try. I'm using MS Access 2016 on a 64-bit machine, and the code works fine. Initially it didn't. I discovered that because I use "Option Explicit" by default the line of code...

www.access-programmers.co.uk

I don't think it is possible yet, not without some sort of web interface. As I say on my website it's probably not the way to go, QR codes are for storing a lot of information, probably overkill with in MS Access.

Thanks for the input. For what I am doing I think you're right. A standard bar code will capture all I need.