Barcode scanning

[Ezerick78]

How exactly do you scan a barcode and only have access pick the information
that is needed from that barcode? I'm working on a database for tracking
mailing list labels with PID numbers embedded into the barcode. It has other
information that is not needed. Any help would be appreciated.

 

[Scott McDaniel]

How exactly do you scan a barcode and only have access pick the information
that is needed from that barcode? I'm working on a database for tracking
mailing list labels with PID numbers embedded into the barcode. It has other
information that is not needed. Any help would be appreciated.

You'd have to parse whatever information you need from the captured data. For example, if you want the first 4
characters:

Left(YourScannedData)

There are several text functions which may help: Right, Left, Mid, InStr, Trim are just a few. See online help for basic
instructions about their use.

Scott McDaniel
scott@takemeout_infotrakker.com
www.infotrakker.com

 

[Tony Toews [MVP]]

How exactly do you scan a barcode

You need a bar code reader of some sort. These devices usually fit
between your keyboard and your computer and mimic someone keying in
the bar code directly.

and only have access pick the information
that is needed from that barcode? I'm working on a database for tracking
mailing list labels with PID numbers embedded into the barcode. It has other
information that is not needed.

Scott gave you a good answer on this part. You'd put the necessary
code in the afterUpdate event of the bar code field.

Just to be on the safe side I'd retain the entire bar code you are
scanning in one field. And then put the parts that you are interested
in another field.

I'm sure that in a few months someone will come to you and ask for
something else. This way you can allegedly spend days and days
retrieving that information while goofing off. <smile>

Tony

--
Tony Toews, Microsoft Access MVP
Please respond only in the newsgroups so that others can
read the entire thread of messages.
Microsoft Access Links, Hints, Tips & Accounting Systems at
http://www.granite.ab.ca/accsmstr.htm
Tony's Microsoft Access Blog - http://msmvps.com/blogs/access/