Barcode questions

  • Thread starter Thread starter Michael
  • Start date Start date
M

Michael

This may be a dumb question, but I bought an extension and I have got the
barcode on the page, now... what can I do with it?

I have the number on a page that is attached to a pallet. How do I get the
information into the database about this pallet? I have given it a ID code
based on the pallet number and the date, so each pallet has a unique number.
I have to go out and buy some scanners.

I would like to scan the pallet at certain points and have entries made into
the data base. With a scanner will it just call up the record and the
operator has to manually check the checkboxes, or can I write a macro to
have it check a check box or stamp a time?

Thank you

Michael
 
Typical barcode scanners act similar to a keyboard input device. So, when
you scan, the focus will need to be in some field designed to capture the
scanned data. You'll probably need to parse the data somewhat (i.e., from
within the KeyPress event). Once the parsing process is complete, you could
check a box and/or insert a time stamp. Most of this will need to be done
in VBA code...in fact, I'd do it all that way.
 
Thanks Paul,
Can something be done so that for instance if a barcode passes a scanner,
access would find that record and check a checkbox? This would control each
pallet that passes through a door.
michael
 
You'd still need someone to monitor and verify that the scan was good. But
yes, as I indicated previously, you could perform other actions like
checking a checkbox or adding a timestamp. You just need to do it in code
once you've parsed the scanned data.
 
Back
Top