467,915 Members | 1,517 Online
Bytes | Developer Community
New Post

Home Posts Topics Members FAQ

Post your question to a community of 467,915 developers. It's quick & easy.

Scanning a barcode into Access 2003

My client is a baseball league who started a Kids Club which has membership cards that have a barcode and their own specific number to monitor the number of times that the KidsClub members come to the games. They donít have any software to go with the cards though. They asked me if I could help. I created a simple table in Access to capture the name, address, telephone, email, number of games attended. The cards have a barcode on them, and they would like to be able to scan the card with a USB handheld scanner and have the number of games attended field to be updated by the scan. Each card has its own number that is programmed into the barcode, which could be the primary key for Access. Can you offer any assistance in how to get the scan of the card to update the "number of games attended" field I created based upon the barcode number?
Jun 6 '07 #1
  • viewed: 2351
Share:
1 Reply
There are two things happening that I'm not certain how to fix. I open Access to the form. First, I have a field named "BarCodeID" which the barcode when scanned places the card number in the that field. I need it to bring up the data that corresponds to that card number. For example: Card number 00850 belongs to John Doe, 2525 Data Way, Greenville, SC 29601. So, when the card is scanned in, I would like the data that corresponds to the card number to come up. Right now it's over writing the card number that is currently in the field when Access is opened up.

Second issue. When the card is scanned and the appropriate data that corresponds to the card comes up, I would like the field called, "Number Of Games Attended" to increase by 1 each time the card is scanned.

Can you help?
Jun 6 '07 #2

Post your reply

Sign in to post your reply or Sign up for a free account.

Similar topics

21 posts views Thread by CHANGE username to westes | last post: by
8 posts views Thread by DS | last post: by
4 posts views Thread by tim | last post: by
1 post views Thread by daniell | last post: by
By using this site, you agree to our Privacy Policy and Terms of Use.