Avatar of Frank Sifuentes
Frank Sifuentes
 asked on

Using a Symbol barcode scanner in a form that was created in Access 2010

I created a form with text boxes. Made a database in excel 2010. The program works good. I would like to use my Symbol barcode scanner to log in our dance club members when they attend our dance by scanning there RCSC members card. What Do I need to do so that new members are added to the database and older members show that they attended the dance? My form has fields that give the members : RCSC number, last name,  first name, emails, phone numbers, and date attended. Help! Thanks Frank
Microsoft Access

Avatar of undefined
Last Comment
Frank Sifuentes

8/22/2022 - Mon
ASKER CERTIFIED SOLUTION
yo_bee

THIS SOLUTION ONLY AVAILABLE TO MEMBERS.
View this solution by signing up for a free trial.
Members can start a 7-Day free trial and enjoy unlimited access to the platform.
See Pricing Options
Start Free Trial
GET A PERSONALIZED SOLUTION
Ask your own question & get feedback from real experts
Find out why thousands trust the EE community with their toughest problems.
SOLUTION
Hamed Nasr

THIS SOLUTION ONLY AVAILABLE TO MEMBERS.
View this solution by signing up for a free trial.
Members can start a 7-Day free trial and enjoy unlimited access to the platform.
See Pricing Options
Start Free Trial
GET A PERSONALIZED SOLUTION
Ask your own question & get feedback from real experts
Find out why thousands trust the EE community with their toughest problems.
Jim Dettman (EE MVE)

Couple of other comments.

 What's been  said is only true if the scanner is a "wedge "device. Most scanners are so for the moment we will assume  it is.    

 Anything scanned will show up in a text box waiting for input. But you may want to program the gun to either add a suffix or prefix so you can distinguish gun input from keyboard input.  You might also want to add a carriage return or tab so that it automatically jumps out of the control when something is scanned .

Jim
Frank Sifuentes

ASKER
2 questions, How do I make my form field focus and what is a wedge device?
because I still can not scan our members in using my Symbol handheld barcode scanner. Frank
Hamed Nasr

First try to scan while in a notepad document.
If it shows what you scan then comes the form issue.
Your help has saved me hundreds of hours of internet surfing.
fblack61
Jim Dettman (EE MVE)

A control that has the focus is one that contains the cursor and is ready for input.    In a macro, you'd use a goto control action.  In code you can do the same, or use the .Setfocus method.

A "wedge" device get's it name from being wedged between two existing things.   In the past, scanners would be connected between the keyboard and a PC.

 Now most scanners are USB based and have a device drive that makes them look like keyboard input.  

 There are still however some scanners that connect to a serial port and work differently.   Those are becoming rare, but if you picked up an old scanner laying around, you might have one like that, which is why I made the comment I did.

  Do as hnasr said and give it a go.

Jim.
Frank Sifuentes

ASKER
I guest I have to learn how to make my form in focus in access 2010 With the Symbol scanner. Where do I look or what do I do.