Tek-Tips is the largest IT community on the Internet today!
Members share and learn making Tek-Tips Forums the best source of peer-reviewed technical information on the Internet!
-
Congratulations Shaun E on being selected by the Tek-Tips community for having the most helpful posts in the forums last week. Way to Go!
Direct Scanning into a form
- Thread starter hsrour
- Start date
When you scan bar codes, it is similar to as if the end user is typing in data. You have to remember to keep a few things in mind...
- Position the cursor at the data entry field. Use Me.YourContolName.SetFocus at the end of the scan / start of a new record so the cursor is at the right location. for example, scanning bar codes with ISBN information -- you would want to position the cursor at the ISBN control (field) on the form for the scan.
- You want to perform an a key-control after the scan such as a carriage-return, or tab.
- After the data has been scanned, you probably want to run a bit of logic. For example, with the library book, after the ISBN scan, run a look-up to retrieve the information on the book. Or run a verification of the scanned data to ensure data integrity.
Dont be intimidated by scanners -- they are just another input device.
Richard
- Position the cursor at the data entry field. Use Me.YourContolName.SetFocus at the end of the scan / start of a new record so the cursor is at the right location. for example, scanning bar codes with ISBN information -- you would want to position the cursor at the ISBN control (field) on the form for the scan.
- You want to perform an a key-control after the scan such as a carriage-return, or tab.
- After the data has been scanned, you probably want to run a bit of logic. For example, with the library book, after the ISBN scan, run a look-up to retrieve the information on the book. Or run a verification of the scanned data to ensure data integrity.
Dont be intimidated by scanners -- they are just another input device.
Richard
- Thread starter
- #3
- Status
