Need assistance with data entry via comm/serial port

Thread view:

Enable EMail Alerts

Start New Thread

Thread rating:

TF - 15 Jul 2003 20:50 GMT

My environment:
Software: Windows 2000, Access 2000
Hardware: Desktop PC, Magtek check reader/scanner with serial port
connection

I need information on how I can get Access to recieve the information that
is being sent to the comm port from the check reader/scanner. Does anyone
have a link, or guide that can help me accomplish this? All I could find in
my searches is third party apps or through the coding my own application
using various programming languages (such as MSComm thru Visual Basic) but
nothing for just Access and its limited version of VB.

I cannot find a good reference on how to even begin. Please help!

Reply to this Message

Paul Overway - 15 Jul 2003 23:00 GMT

I've done similar work You need an ActiveX control or DLL for reading the
comm port....Access alone doesn't do it. If you have VB, create a DLL for
this purpose...you will need to create a class and a form (for the MSComm
control). The form doesn't ever have to be shown. The class should
instantiate the form (hidden)...also look at using WithEvents for the form
to get comm port data as it comes in. After you have created your DLL, you
can reference it in Access.

> My environment:
> Software: Windows 2000, Access 2000
[quoted text clipped - 9 lines]
>
> I cannot find a good reference on how to even begin. Please help!

Reply to this Message