Results 1 to 4 of 4
  1. #1
    serialcomms is offline Novice
    Windows 10 Access 2019
    Join Date
    Aug 2022

    Post Serial (COM) Ports in Access VBA

    Hello All,

    I've uploaded a new set of VBA functions for anyone still interested in using Serial COM Ports with Access.

    Serialcomms/Serial-Ports-in-VBA-new-for-2022: Using Serial COM Ports in Visual Basic for Applications (VBA) (

    Functions are generic for Excel, Access & Word , also cross-posted to Excel forums Serial COM Ports in Excel VBA - Microsoft Tech Community

    Please let us know if they work for you thanks.


  2. #2
    STN is offline Novice
    Windows 11 Office 365
    Join Date
    Nov 2023

    Thanks a lot, that's fine.
    You just have to change the max of com number (actually at 2)
    Best regards

  3. #3
    davegri's Avatar
    davegri is online now Excess Access
    Windows 11 Access 2019
    Join Date
    May 2012
    Ah, where were you back in the 80's, when we only had COM and LPT ports? As they say, "The beauty of the RS-232 'Standard' is the abundance of options!"
    Last edited by davegri; 11-19-2023 at 08:48 AM.

  4. #4
    STN is offline Novice
    Windows 11 Office 365
    Join Date
    Nov 2023
    Dear Davegri

    Try to transfert critical information by wifi in an operating room during electro surgery ... With "Com" and Lora it's ok !

    Old yes, but still alive, just like Access ;-)

    Best regards

Please reply to this thread with any new information or opinions.

Similar Threads

  1. Replies: 3
    Last Post: 07-07-2015, 12:29 PM
  2. serial number
    By akellaavss in forum Reports
    Replies: 12
    Last Post: 06-21-2015, 11:07 PM
  3. How To Lock Usb Ports On SQL Server 2008 R2
    By David92595 in forum SQL Server
    Replies: 0
    Last Post: 10-31-2012, 05:55 PM
  4. Unable to Read from COM ports in Access 2003
    By userThree in forum Programming
    Replies: 3
    Last Post: 07-31-2011, 08:59 PM
  5. How do I find the serial value of Now()?
    By JoeG in forum Queries
    Replies: 0
    Last Post: 03-13-2007, 08:16 AM

Tags for this Thread

Posting Permissions

  • You may not post new threads
  • You may not post replies
  • You may not post attachments
  • You may not edit your posts
Other Forums: Microsoft Office Forums