Wrox Programmer Forums

Need to download code?

View our list of code downloads.

Go Back   Wrox Programmer Forums > Microsoft Office > Access and Access VBA > Access
Password Reminder
| FAQ | Members List | Calendar | Search | Today's Posts | Mark Forums Read
Access Discussion of Microsoft Access database design and programming. See also the forums for Access ASP and Access VBA.
Welcome to the p2p.wrox.com Forums.

You are currently viewing the Access section of the Wrox Programmer to Programmer discussions. This is a community of tens of thousands of software programmers and website developers including Wrox book authors and readers. As a guest, you can read any forum posting. By joining today you can post your own programming questions, respond to other developers’ questions, and eliminate the ads that are displayed to guests. Registration is fast, simple and absolutely free .
DRM-free e-books 300x50
Thread Tools Search this Thread Display Modes
  #1 (permalink)  
Old April 23rd, 2004, 12:43 PM
Friend of Wrox
Join Date: Jun 2003
Location: South Bend, Indiana, USA.
Posts: 149
Thanks: 0
Thanked 0 Times in 0 Posts
Default RS-232 serial communications

I want to make an Access database that I can use to send and receive ASCII text files using the serial port on my computer. I don't need any special protocals, just hardware or software handshaking (Xon/Xoff).

I am sending a text file to and from a mcahine tool control, which in spite of the high cost, is pretty simple/dumb.

I have never worked with the MSComm control (or any other serial OCX or DLL) and was looking for some examples to learn from.
Reply With Quote
  #2 (permalink)  
Old April 23rd, 2004, 07:50 PM
Friend of Wrox
Join Date: Nov 2003
Location: Lehigh Acres, FL, USA.
Posts: 625
Thanks: 0
Thanked 0 Times in 0 Posts
Send a message via MSN to jemacc

I believe you have to use ms comm control
Here is some information

MS Comm Control
The MS Comm control comes with Visual Basic. This one came with VB 6.0. We have a license to distribute this OCX with our Visual Basic application. We have tried in to get a clarification from Microsoft if it is OK to distribute stand alone. We asked: "Do we have the right to distribute the MS Comm control which comes with Visual Basic with an Access application?" When this question was asked of the MS Access technical support people we could not find anyone that knew what the MS Comm control is. The closest we got was someone that thought we were talking about the Common Dialog control. It is our assumption that because we have the right to distribute this with a VB application we also should have the right to distribute it stand-alone.

This is the MSCOMM32.OCX that should be stored in your \windows\system directory.

To register within Access go to TOOLS/ACTIVE X CONTROLS and select \windows\system\mscomm32.ocx or Microsoft Communications Control and click on the REGISTER button.

If you get a licensing error the only way we know to get the licensing is to install VB 6 Professional. Microsoft Technical Support and Sales Staff was of no use when we tried find out how to register or purchase the Comm control.

Download Now mscomm.zip 50K bytes

Private Sub MSComm1_OnComm()
    Select Case MSComm1.CommEvent
        Case comEventBreak ' A Break was received.
        Case comEventCDTO ' CD (RLSD) Timeout.
        Case comEventCTSTO ' CTS Timeout.
        Case comEventDSRTO ' DSR Timeout.
        Case comEventFrame ' Framing Error.
        Case comEventOverrun ' Data Lost.
        Case comEventRxOver ' Receive buffer overflow.
        Case comEventRxParity ' Parity Error.
        Case comEventTxFull ' Transmit buffer full.
        Case comEventDCB ' Unexpected error retrieving DCB]

         ' Events
        Case comEvCD ' Change in the CD line.
        Case comEvCTS ' Change in the CTS line.
        Case comEvDSR ' Change in the DSR line.
        Case comEvRing ' Change in the Ring Indicator.
        Case comEvReceive ' Received RThreshold # of chars.
            'Sets the global mstinbuff to = what is received by the commm control
            mstInBuff = mstInBuff & MSComm1.Input
            'Resets the variable used to count the lack of response to 0 so that
            'counting restarts.
            mdblReceived = 0

    End Select
End Sub

Reply With Quote

Thread Tools Search this Thread
Search this Thread:

Advanced Search
Display Modes

Posting Rules
You may not post new threads
You may not post replies
You may not post attachments
You may not edit your posts

BB code is On
Smilies are On
[IMG] code is Off
HTML code is Off
Trackbacks are Off
Pingbacks are On
Refbacks are Off

Similar Threads
Thread Thread Starter Forum Replies Last Post
RS-232 and Access 2007 VBA database Gajun BOOK: Beginning Access 2007 VBA ISBN: 978-0-470-04684-5 1 June 2nd, 2010 11:08 AM
Communications News softomania JSP Basics 0 October 27th, 2008 12:57 PM
Serial communications Allan- VB How-To 0 November 23rd, 2005 12:40 PM
Serial port communications Skoog C# 1 September 28th, 2005 09:18 AM
RS Manager and RS Server on 2 different computers Choose File BOOK: Professional SQL Server Reporting Services ISBN: 0-7645-6878-7 1 July 22nd, 2004 10:56 AM

All times are GMT -4. The time now is 12:21 PM.

Powered by vBulletin®
Copyright ©2000 - 2020, Jelsoft Enterprises Ltd.
© 2013 John Wiley & Sons, Inc.