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

Barcode scanner to open record automatically

P: 1
Hello everyone,

I need help regarding a couple of issues.
I have completed a cute and very functional database for a friend who owns a local gym -> mainly for tracking and managing clients etc.

Recently, we thought of incorporating a barcode scanner to the database and print barcodes in the back of the membership card.

Can anyone tell me whether it is possible to have a barcode scanner automatically input the data into a certain field (clientID in my case) on the form and open the specific record of the client.

How can this be done?
Has anyone done something simmilar before?

Thanks
Dec 16 '07 #1
Share this Question
Share on Google+
3 Replies


ADezii
Expert 5K+
P: 8,599
Hello everyone,

I need help regarding a couple of issues.
I have completed a cute and very functional database for a friend who owns a local gym -> mainly for tracking and managing clients etc.

Recently, we thought of incorporating a barcode scanner to the database and print barcodes in the back of the membership card.

Can anyone tell me whether it is possible to have a barcode scanner automatically input the data into a certain field (clientID in my case) on the form and open the specific record of the client.

How can this be done?
Has anyone done something simmilar before?

Thanks
I'm not positive, but I think the Bar Code Scanner can output the data in either a Fixed Width or Delimited Text File which can easily be used by Access, should that be the case. I think the answer lies with the capabilities of the Scanner.
Dec 17 '07 #2

Nathan H
100+
P: 104
I'm not positive, but I think the Bar Code Scanner can output the data in either a Fixed Width or Delimited Text File which can easily be used by Access, should that be the case. I think the answer lies with the capabilities of the Scanner.

We use a barcode scanner on a db that scans books. The barcode scan gun itself has to be set to enter/shift once a barcode is scanned. Then you just program your db fields as you would any other search. the "enter" on the scan gun then triggers the search. (same as if you scan a barcode and then hit enter on your key-pad)...

I hope this helps steer you in what you are looking for...
Dec 17 '07 #3

missinglinq
Expert 2.5K+
P: 3,532
I think the bottom line is that it will vary from manufacturer to manufacturer; you'll probably need to go thru the documentation or contact the scanner's maker.

Here's a Tony Toews site that has a bunch of links to sites dealing with barcode scanning. It may be of some help.

Welcome to TheScripts!

Linq ;0)>
Dec 17 '07 #4

Post your reply

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