Reading serial port into Access

  • Thread starter Thread starter Simon
  • Start date Start date
S

Simon

Is it possible, or is there a vb script out there to read the serial port
into Access ?

I am reading the output of a barcode reader.

Thanks
Simon
 
A wedge type barcode scanner would be much simpler for you (scan is brought
in same as key presses). That aside, you'd need MSCOMM.OCX or equivalent
activeX control to programmatically retrieve serial port data. The wedge
type scanner will save you quite a bit of programming.
 
A quick and easy solution would be to use a third party tool like
BC-Wedge or WinWedge from TAL Technologies. Both programs run in the
background and feed serial data to other programs by stuffing the data
through the keyboard buffer so that the bar code data would appear as
keyboard input. The WinWedge program also supports DDE so you can feed
data directly to an Access VBA subroutine without having to go through
the keyboard buffer.
For more info visit: http://www.taltech.com
 
Thomas Lutz said:
A quick and easy solution would be to use a third party tool like
BC-Wedge or WinWedge from TAL Technologies. Both programs run in the
Click to expand...
For more info visit: http://www.taltech.com
Click to expand...

I've downloaded a trial of CPS Plus - this does exactly what I want. CPS
Plus seems great value at only 30 Euros.

" CPS Plus software enables serial devices like barcode scanners, magnetic
stripe readers, gages,electronic scales, sensors, laboratory instruments
and modems to communicate with any Windows application. CPS Plus will
accept data from almost any serial device operating via RS232 port and
convert the data to keystrokes.
This allows data to be entered directly into any Windows application just as
if it was being typed in using a keyboard.
CPS Plus is designed to read and buffer data from up to 8 com ports
simultaneously."
 
Back
Top