By using this site, you agree to our updated Privacy Policy and our Terms of Use. Manage your Cookies Settings.
435,426 Members | 3,118 Online
Bytes IT Community
+ Ask a Question
Need help? Post your question and get tips & solutions from a community of 435,426 IT Pros & Developers. It's quick & easy.

Scanning a barcode into Access 2003

P: 2
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
Share this Question
Share on Google+
1 Reply

P: 2
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.