How to Add a return to barcode scan

[balin]

I'm discovering how to use a barcode scanner to input data into form text boxes.

The scanner I have doesn't appear to be able to be programmed to add a carriage return to the input string (number) This would eliminate the need to press enter after the scan.

Each scan is a std 13 digit barcode number.

Can anyone start me on the right track. I'm thinking I need an event procedure but which one??
JON

 

[PHV]

In the barcode control Change event procedure:
If Len(Me![barcode control].Text) = 13
Me![another control].SetFocus
End If

Hope This Helps, PH.
FAQ219-2884
FAQ181-2886

 

[sentineluk]

Hi Jon,

How are you interfacing the Barcode scanner with your PC,
Is it with a Barcode wedge or something similar?

You should be able to create a carriage return with the "Post amble" part of the software that you are running the barcode software with.

Garry

 

[balin]

I'm just using a scanner that has a "Y" ps/2 connector. This allows it to (wedge) connect between the key board and PC so that it's input appears to come directly from the keyboard. There is no software with it (that I have found).

I've also found there is "wedge" software available. This seems to require the scanner to be connected via a com port. It then intercepts scanner input and redirects it to the keyboard buffer (with added characters etc. if needed).

But my scanner only has ps/2 connectors. Can I Move the ps/2 mouse to a USB port and use the mouse Ps/2 port as a com port ?? I'm a bit vague on this. If so I would choose to use the wedge software. Other wise I'l try the event procedure in the meantime.


Thanks all - I find this forum to be of the highest standard.
JON

 

[67peshawar294]

balin,
As long as each scan is a EAN-13 you can use an "input mask" for your EAN13 text box.
I use one in my upca and it works without problem.
try:
0000000000000;0;@ and see how that works.
jim

 

[jrbarnett]

Jon

You say your mouse has ps/2 and usb connections, but the scanner needs a usb port.

What connector does your keyboard have?

John

 

[balin]

Thanks everyone...I've used a combination of all ideas.

used on change event to initiate some set value actions.
used Dlookup to fill in other related fields.
Format with auto tab also works.
I also use macros extensively.

so one click on the scanner is all that is needed cursor jumps to qty field then F9 (auto Key Macro) saves the record.

Didn't get anywhere with software wedge. By the way John Keyboard is ps/2.

JON

 

[cbice]

Jon,

If you tell me the scanner module, I can tell you how to set the carriage return. Normally the scanner comes with documentation, and in that documentation is a barcode that you scan that activates the carriage return. If you give me the make and model i will try and point you in the right direction.

 

[jrbarnett]

If the scanner has a ps/2 connector and the keyboard has a ps/2 connector what's the problem? Just plug the scanner into the keyboard port then the keyboard into the scanner's pass through port for the keyboard.

Take up cbice's offer of checking to see if there is a scanner setting for appending a return to the end of the input or not, and you should be fine.

John