Form field capabilities

[Guest]

If I have a barcode reader (plus its software, if needed) is it possible to
scan a barcode and have the information appear in a field on an access form.
Thus I can scan a barcode, tab to the next field and enter the next....thus
having a database that will track the info for me?

Thank you

 

[Tom Collins\(Home\)]

Yes. A barcode represents a set of numbers (and in some cases letters)
that is just formatted differently. Your typical barcode reader will
read the bar code and send text to the computer just like you were
typing it on the keyboard. Barcode I have worked with in the past also
send a CR at the end.

So you basically need a lookup field. Type the ID number and hit
enter, or scan the barcode. Have that do a lookup.

Tom Collins


message | If I have a barcode reader (plus its software, if needed) is it
possible to
| scan a barcode and have the information appear in a field on an
access form.
| Thus I can scan a barcode, tab to the next field and enter the
next....thus
| having a database that will track the info for me?
|
| Thank you

 

[barcodewiz]

One thing I'd like to add to Tom's comment.
If you use a keyboard wedge scanner, the CR (usually) is transmitted at
the end of each scan. The CR is appended by the scanner (not the
barcode). Most scanners will allow you to use other terminating
characters (such as TAB).

If you'd like to see an example, take a look at the demo of our
BarCodeWiz Barcode ActiveX Control (it's a barcode printing plug-in).
The demo includes an mdb file with a form, which allows you to scan
barcodes and look up the data in a table.

http://www.barcodewiz.com/demo.asp


Alek Szymanski
http://www.barcodewiz.com

 

[wangzhe]

oh yeah