RS 232 ASCII input directly into MS Access 2003

[Guest]

Does anyone know the easiest was to have Access read standard text input from
the com port on the PC into a field in a table or form? Is there a control I
can download or is it allready part of Access?

Thanks.

 

[Dick Watson]

I suspect you will need some kind of serial comm control. There are many of
thee. Try http://www.google.com/search?hl=en&q=vba+serial+comm+control. Code
will be required.

 

[Brendan Reynolds]

Tony Toews has links to some relevant resources at the following URL ...

http://www.granite.ab.ca/access/serialport.htm

 

[Thomas Lutz]

You might look at a product called WinWedge from TAL Technologies.
WinWedge is an executable program that runs in the background and
feeds incoming serial data directly to other apps either as
"keystrokes" or as DDE Data items. Access supports DDE so you could
use either method for transferring data from WinWedge to Access.
For more info about WinWedge visit:
http://www.taltech.com/products/winwedge.html

To see samples of how to pass data from WinWedge directly to an Access
table or an Access form see the code samples at:
http://www.taltech.com/support/dde_sw/ddeaccess1.htm
http://www.taltech.com/support/dde_sw/ddeaccess4.htm