• Status: Solved
  • Priority: Medium
  • Security: Public
  • Views: 2413
  • Last Modified:

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.
0
colinasad
Asked:
colinasad
  • 4
  • 2
1 Solution
 
rockiroadsCommented:
I dont know if its part of windows or not, as my lappy as other sdk on.

Look for mscomm32

if you go into vba editor then go into tools and references, is there Microsoft Comm Control listed? if not then if you hit the add or browse button, whichever one it is, see if you can find in windows directory\system32 for the file mscomm32
if so select it

With regards to using it, the reference added should allow you to define a type of MSCommLib.MSComm.
0
 
rockiroadsCommented:
the suffix for this is .ocx

I found this old post with regards to using it. It may help you.
http://www.experts-exchange.com/Microsoft/Development/MS_Access/Q_20944619.html

0
 
colinasadAuthor Commented:
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.
0
Prepare for your VMware VCP6-DCV exam.

Josh Coen and Jason Langer have prepared the latest edition of VCP study guide. Both authors have been working in the IT field for more than a decade, and both hold VMware certifications. This 163-page guide covers all 10 of the exam blueprint sections.

 
rockiroadsCommented:
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.
0
 
colinasadAuthor Commented:
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.
0
 
rockiroadsCommented:
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,
0

Featured Post

What is SQL Server and how does it work?

The purpose of this paper is to provide you background on SQL Server. It’s your self-study guide for learning fundamentals. It includes both the history of SQL and its technical basics. Concepts and definitions will form the solid foundation of your future DBA expertise.

  • 4
  • 2
Tackle projects and never again get stuck behind a technical roadblock.
Join Now