Access barcode capture

  • Thread starter Thread starter Guest
  • Start date Start date
G

Guest

I would like to scan into a form and automatically advance to the next
control. I have tried a me.nextcontrol.setfocus in all the events without
success. Is there another way? Thanks!!!
 
Let me clarify...I scan a barcode with a wedge scanner into a control.
Instead of requiring the user to tab to or click in the next control, I'd
like Access to automatically advance. thanks
 
A lot of barcode scanners allow you to specify a termination character.
Have you looked at that? In any case, you need to know what character the
scanner sends to represent the end of field. If you have the scanner set to
use tab as the termination character, you wouldn't need to do anything. If
it uses a different termination character, you'd have to use the KeyPress
event to trap the EOF character, set KeyAscii = 0, and .Setfocus to the next
control.
 
I've ran some testing with bar code readers and the termination character can
be set to send the "Enter" character. You simply need to set the "Enter"
action of the control box to move to the next field.
 
Yes...that works too...sometimes. The problem being that if focus is
somewhere that it shouldn't be when you do the scan, you may have an
unintended/undesired effect...i.e., focus in on cancel button, you
scan...guess what. If you use tab, this is less of a problem. If you use
some other character, i.e., ASCII 0 or some high ASCII number, it is even
less of a problem. But it depends on the scanner.
 
Back
Top