How do I use MSCOMM to read data from a COM port in Access 2007?
I am developing an Access 2007 "project" (.adp) as a front-end to a SQL Server 2005 Express database.
In some of my Access Forms I want to read data sent from a barcode scanner attached to a COM port. I am fairly familiar with the barcode scanner side of things because this is an upgrade of an old DOS application that has been using various scanners for many years.
From what I have found so far on the web, MSCCOMM appears to be the suggested method of doing this. What I'm not so sure about is how I go about getting this installed and operational. Can anyone advise me on how to do this or point me to a relevant article? How do I get MSCOMM installed on my PC and how do I make Access 2007 aware of it so that I can use it in the VBA code behind my Forms?
Many thanks. Colin.
In some of my Access Forms I want to read data sent from a barcode scanner attached to a COM port. I am fairly familiar with the barcode scanner side of things because this is an upgrade of an old DOS application that has been using various scanners for many years.
From what I have found so far on the web, MSCCOMM appears to be the suggested method of doing this. What I'm not so sure about is how I go about getting this installed and operational. Can anyone advise me on how to do this or point me to a relevant article? How do I get MSCOMM installed on my PC and how do I make Access 2007 aware of it so that I can use it in the VBA code behind my Forms?
Many thanks. Colin.
ASKER CERTIFIED SOLUTION
membership
This solution is only available to members.
To access this solution, you must be a member of Experts Exchange.
ASKER
Thanks for your prompt comments.
I had been in my VBA Tools - References area but there was no mention of MSCOMM in the offered list of "Available references".
I have now tried to "browse" in "C:\Windows\System 32\" as suggested but cannot find an "MSCOMM.OCX" entry there.
Presumably if I can find a download on the internet and can install it, it should eventually appear there (???).
I will give it a try and get back to you.
I had been in my VBA Tools - References area but there was no mention of MSCOMM in the offered list of "Available references".
I have now tried to "browse" in "C:\Windows\System 32\" as suggested but cannot find an "MSCOMM.OCX" entry there.
Presumably if I can find a download on the internet and can install it, it should eventually appear there (???).
I will give it a try and get back to you.
Possibly. I dont know the design licence usage for it. Maybe it is part of vb as I have visual studio. Not sure if it is part of vbruntime.
If you do find it, you will need to register it (regsvr32) and hopefully it will let you use it.
If you do find it, you will need to register it (regsvr32) and hopefully it will let you use it.
ASKER
Thanks rockiroads.
Managed to find and download mscomm32.ocx get VBA editor to reference it and create an "MSComm" control on an Access Form.
All I have to do now is make it work for my barcode scanner.
Thanks for your help so far.
Managed to find and download mscomm32.ocx get VBA editor to reference it and create an "MSComm" control on an Access Form.
All I have to do now is make it work for my barcode scanner.
Thanks for your help so far.
Cool, good luck with getting it to work with the barcode scanner. Search EE as Im sure this type of question has been asked before,
I found this old post with regards to using it. It may help you.
https://www.experts-exchange.com/questions/20944619/Writing-to-com-port-using-MsAccess-Accessing-Hyperterminal-saved-profile-settings-to-connect-to-device.html