Scanner Guns

[KeithG]

Hello,

Is there a way to communicate with the Serial Ports from Access with out using MSCOMM? If any body has some code for using Access with a Scanner gun that they would post would be greatly apperciated.

Thank You

Keith

 

[jeremie_ingram]

It has been my experience that the standard scanner gun will work via the keyboard port and enter its "read" as text.

 

[KeithG]

The scanner that we have does not use a keyboard wedge it conects to COM1

 

[jeremie_ingram]

I have used 3 types of scanner input devices (4 counting that Qcat thing from Radio Shack ). One of these units was strictly USB, and once it was connected it worked in the same fashion as the PS2 connected model. Once connected, I was required to selected my barcode type/standard from the manual and scan their example in order to get the unit properly set. Once this was completed it would interface with the system no different that any other user input device, and convert the barcode into decimal notation in any available field or document.
I have implemented the use of a scanner with Access, but it required no additional programming to get it to work.
What make and model of scanner unit are you working with? Maybe if I reference the manufacturer I could get a better idea of what is necessary.
Have you connected and tested the scanner? Can it input data into something like a text document?

 

[KeithG]

I have a scanner from Symbol it is a Phaser 470

 

[systemx]

I'm also very interested to find out if a coding solution is available for configuring a serial scanning device (eg a horseshoe cheque MICR reader) to interface with Access successfully.

I am looking into cheque audit solutions in my own line of work - and want to avoid using any additional programs to convert the serial data to ASCII data.

I believe a coding solution exists - I recall reading about something on this forum somewhere - but also recall it was beyond my simple knowledge of VBA!

If anyone has a solution...would love to see it!

Cheers

Rob