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

Insert Serial Port Data using the MSCOMM control

I need to create a procedure in Access to read GPS data from COM4.  I think that using the mscomm control offers the best chance of success, but I have never worked with it before.  Can anyone point me in the right direction to start writing the code.
Aaron Greene
Aaron Greene
1 Solution
Scott McDaniel (Microsoft Access MVP - EE MVE )Infotrakker SoftwareCommented:
There's not much written on using this control with Access, but lots with Visual Basic. The syntax should basically be the same, the only difference being that you must often refer to the .Object property of the Activex control:


The easiest way is to set a variable to an instance of the control and use that:

Dim ctl As MSCOMM.Control <or whatever library you need>
Set ctl = Me.YourControl.Object

Now you can use Intellisense ...

Here's a link to a site that may be useful:
Aaron GreeneProgrammerAuthor Commented:
I'm just ranting, but I've been looking into this for a while, and I have found very little on the subject.  Using MS-Access to store GPS data seems like a "no brainer", but there seems to be very little information on  the subject.  Is there a reason for this?  All of the information that I have found refers to a third party software to act as a bridge between the GPS reciever and Access.  I don't have a problem using a third party app, but I'd like to know if I'm going down the wrong path in thinking that Access and GPS should be a natural fit.
Question has a verified solution.

Are you are experiencing a similar issue? Get a personalized answer when you ask a related question.

Have a better answer? Share it in a comment.

Join & Write a Comment

Featured Post

Easily Design & Build Your Next Website

Squarespace’s all-in-one platform gives you everything you need to express yourself creatively online, whether it is with a domain, website, or online store. Get started with your free trial today, and when ready, take 10% off your first purchase with offer code 'EXPERTS'.

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