Ken Ivins said:
Is there code or a program that can be bought that allows you to input
information from a bar code scanner into Access? Both for data entry and for
look up purposes.
Thanks,
Ken Ivins
From my experience, most barcode devices will generate a text file which you
must then program Access to handle. I'm not aware of any that connect
directly to Access as say an Add In but I may be wrong. You'll have to
research the manufacturers to see if any are offering an Access interface
these days Their may be some but I've not heard of them.
You could alternatively program Access to make it seem as if its plugged
into it. For instance, You could have a barcode device create a file per
scan and have Access scan the devices destination directory at a 1 or 2 sec
interval the process the files found within. But its clunky.
Or you could have the device append to the one file each time it scans and
have access parse it at a given frequency picking up new records each time
it reads it. Not so clunky but still clunky.
Or you could have the device append to the one file each time it scans and
link the text file if you have it spec'd to the right format. This probably
the best way without writing a very specific interface to the device.
Hope this helps.
