Barcode reader

[Tjina]

I've created a main/subform (order and orderdetail).
In de orderdetail i enter the productID by scanning the barcode on the
products.
The situation now is that the reading of the barcode goes well, the focus
move automatically to the next record.
My problem is that once i scan for a second time i receive an error that the
productID doesn't exist, but it does. Somehow i got to view the data in the
field and i noticed the scan adds 2 square box at the beginning of the
productid.
How can i resolve this problem with the Barcode reader??
i just want to scan the items and print at the end.

please help

 

[Guest]

Hi Tjina,

I have developed a couple of systems that use barcode technology and the
first thing you want to avoid is having to create some sort of parsing system.

The first thing that I would try, based on your description of it
automatically moving to the next record, would be to review the manual for
the barcode scanner itself and remove the <RETURN> key code that sounds like
is activated.

Another piece of advice is to always use the Trim() method around anything
that the scanner receives; just to ensure that garbage characters are not a
part of your query.

Lastly, I don't know how you have the form which receives your scan set up
but I would try to either eliminate as many user-interactive controls as
possible (i.e. combo boxes, textboxes - anything that can receive keyboard
input) or check the KeyPress event on the form when receiving data. If you
have a common prefix for your barcode items, you can usually distinguish
between user entry and the barcode scanner; regardless if it is a wireless
device or a wedge.

Let me know if that works for you.

Good luck.

Lance