How to read/write serial port from MS Access (VBA) using just API calls ?

Bean

I just need simple "read a byte / write a byte" functions.

We don't have MSCOMM and don't want to have to use someone elses libarary.

I've search for awhile, but I can't find anything that just tells you how to do it.

Has anyone done this before ?

Bean.




▔▔▔▔▔▔▔▔▔▔▔▔▔▔▔▔▔▔▔▔▔▔▔▔
“The United States is a nation of laws -· poorly written and randomly enforced.” - Frank Zappa

- - - - - - - - - - - - - - - - - - - - - - - - - - - - - - -
www.hittconsulting.com
·

JonnyMac

The .NET framework has serial stuff built in -- you might see if you can make .NET calls from VBA (assuming you have .NET installed).

stamptrol

Hi Bean,

If you can live with going back to an older version of Windows that has DOS, QuickBasic or most of the other Basics have direct access to the com ports from within the language.

Its a simple process to do what you want, almost like Pbasic!

·· edit ---just saw you're using Access

---

may not be as simple!

Cheers

▔▔▔▔▔▔▔▔▔▔▔▔▔▔▔▔▔▔▔▔▔▔▔▔
Tom Sisk

http://www.siskconsult.com
·

Kevin Wood

This article might get you started...

msdn2.microsoft.com/en-us/library/aa140088(office.10).aspx

Propability

·· Just a little googling.

http://www.sharewareconnection.com/windows-std-serial-comm-lib-for-visual-basic.htm

Pete

Propability

and this also.

http://www.microsoft.com/communities/newsgroups/en-us/default.aspx?query=communication&dg=microsoft.public.access.modulesdaovba&cat=en_US_6ba00683-ae31-4f15-abe2-3bc70e8bebb1&lang=en&cr=US&pt=&catlist=&dglist=&ptlist=&exp=&sloc=en-us