Printable Version of Topic

Click here to view this topic in its original format

UtterAccess Forums _ Access Automation _ Barcode Scanner

Posted by: wheeledgoat Jul 29 2019, 09:23 AM

Exciting times - dipping a toe into something I've no experience in: Barcode Scanners

I've done my homework and read all the threads here on UtterAccess and I'm left with a choice:

K.I.S.S. (usually the best policy) and just get a https://www.amazon.com/dp/B01GDJ2BH6/ref=cm_sw_em_r_mt_dp_U_dZVpDbPVZGRSB

Or go for the gold and look at a https://www.amazon.com/dp/B07KSR1ZB5/ref=cm_sw_em_r_mt_dp_U_P5VpDbMXVKD6T. While not critically necessary, it would be pretty slick to be able to run around (within range of the device) and perform basic functions like inventory verification without being tied to the PC. But there seems to be no shortage of problems and complaints with these fancier ones (But then again no one complains when they work.)

Hoping to elicit some responses on first-hand experience with barcode scanners and perhaps unit recommendations... Thanks!


Posted by: ranman256 Aug 14 2019, 08:21 AM

I got a simple scanner , that scans to a text file on the scanner.
then I connect it via USB to the pc, the access sees it as a file to import.
I run query to import the data.

Posted by: Jackal Aug 16 2019, 11:49 AM

I just completed a barcode project my work place.

Previously, we receive inventory manually using paperwork. As the number of items received is huge (more than 300 items), it takes quite a while and involves quite a few people so that we don't hold back the delivery driver while we count.

So I put together a simple Access system where barcode are being scanned and matched against the Purchase Order. It supports multiple barcode scanning (form timer interval of .15seconds). The incorporation of barcode scanning is pretty simple originally..using HID emulation (like a keyboard). However, when using 2 barcode scanner using HID, it jumbled up the input and it has a problem of not knowing which scanner is responsible for the correct scan. So I eventually modified it to use this scanner called Nadamoo BUR3003 which allows multiple scanners to operate using a virtual usb com port. I prefixed each scanner to have "x:" e.g. ScannerA input will be "A:99999" where 99999 is the barcode read. So the VBA module will strip out the first 2 characters and know it is from Scanner A.

So far its been working like a charm!

Posted by: wheeledgoat Aug 16 2019, 02:05 PM

Interesting... thanks for the info!