How to use a bar code scanner in my access program

[magezi]

I have designed a program for my client and he wants data input through a bar code scanner. It is a gudget that reads bar codes attached to items and interpretes the price and item codes and feeds them into the program just as one would do with a key board.

Can any one help.

the bar code scanner, the associated printer and computer are Epson products and most Supermarkets here use such an arrangement.
Nkabirwa Sowed Magezi
nkabirwa@netscape.net

A Ugandan Developer for

(1) School Management Information System(SMIS) - Foxpro 2.6 ; Ms-Acess 97

(2)Debt onitoring System(DMS) - Ms-Acess 97

(3) The Loans Recovery System(LS) - Ms- Access 97

(4) The Dry Cleaners System(DS) - Ms- Access 97

 

[nogarede]

the scanner will send data just as would the keyboard. Depending on the scanner you need a little interface program like BC-Wedge (

http://www.taltech.com)

which will make your scanner work just like info where entered on the keyboard (specially if the scanner is on port COM).
Once the scanner works, you have to interprete the code you receive.
Here some code that tracks the code in the codebar and go to a specific field.

Function Track_Key(KeyAscii As Integer)
If KeyAscii = 231 Then
Forms!Form1!numero.Locked = False
Forms!Form1.Visible = True
Forms!Form1!numero.SetFocus
Forms!Form1!numero = ""
End If

End Function