FredixBlog

Quertion: I have a bar code reader I would like to use to input serial numbers into an Access application. My understanding is that a bar code reader is just like your keyboard and it also has an “enter” key to place the data. The numbers I want of the 10 digit number scanned are only the rightmost 5 digits. Can anyone walk me through coding this so that the digits go into the correct text box on my form and I capture the last 5 digits of the number?
Fredix gave this response on 11/28/2001:
Hi!

The big difficulty, as you said, was to ensure that the input of the reader goes into the right field.

At many places, the program has the following line:

DoCmd.GotoControl "ReaderInput"

Also, ensure that the user has the less control possible on the input form: No Tab, Enter, Arrow keys, mouse. Ensure that all of these actions ends by going to the “ReaderInput” control.

After a torough testing, it finally works as expected, but this is not easy, I must tell.

For capturing only the 5 rightmost chars, use something like:

Serialnumber = right(me.ReaderInput,5)

Regards.

No related posts.