Access barcode entry

[Guest]

I am setting up a database to use barcode input. All works fine except one
field where depending on a particular fault code, I need to scan in a 4 digit
number. There can be over 200 hunderd so rather than have 200 barcodes I want
to scan the 4 digits seperatley. How can I set the text box properties to
accept any scan data till I scan the "Tab" key.
Thanks

 

[John W. Vinson]

I am setting up a database to use barcode input. All works fine except one
field where depending on a particular fault code, I need to scan in a 4 digit
number. There can be over 200 hunderd so rather than have 200 barcodes I want
to scan the 4 digits seperatley. How can I set the text box properties to
accept any scan data till I scan the "Tab" key.
Thanks

I don't understand your logic here. A barcode is simply a way of depicting a
text string. I've scanned 12-digit barcodes with no problems whatsoever.

What do you mean by "200 hundred"? Why would you ever need 200 barcodes? What
is the structure of your table, and what are the values you will be scanning?

John W. Vinson [MVP]

 

[Guest]

John, sorry if I didn't make myself clear.
We test parts where there will be a variety of failure reasons. My main
report will group on these reasons. But for analysis the specific code will
be required by engineers. There are over 200 of these "reasons", each with a
differerent 4 digit code. So rather than a report which says x 1 fault code x
0001, x 1 fault code x 0002 etc, the report will say x 2 fault code x. But
weekly, engineers will need specifics, so I can query the database for them
which will show each individual code number. Rather than have all the 4 digit
codes in barcode I have 1~9 and they can scan the 4 digits seperately, but I
need the 4 digits to stay in once cell if possible. I have looked at a
seperate field for each number but I think that's the wrong way to go. They
could just type, but i was hoping to get away from the keyboard entirely.
Many thanks if you can help.