Results 1 to 3 of 3
  1. #1
    Greg J Good is offline Novice
    Windows 8 Access 2013
    Join Date
    Oct 2015
    Location
    So CA, USA
    Posts
    3

    Sending MS Access data to a device connected by a Port on my computer.

    I have a Lawn watering system that runs on my computer. The watering system sends a string of data to a COM Port that has a device plugged in; this device is called a Firecracker. The Firecracker sends a signal (via RF wave) to another device that activates the watering valve.
    I would like to write a new watering system using MS Access. I think I know how to put the system together but I don't know how to send the required data string to the COM Port (Firecracker) that will ultimately control the watering valve(s). I'm looking for help creating the code required to get MS Access to talk to the Firecracker.
    Any help offered will be greatly appreciated.
    Thank you, Greg Good

  2. #2
    CJ_London is online now VIP
    Windows 10 Access 2010 32bit
    Join Date
    Mar 2015
    Posts
    11,398
    see this link which should provide you with the information you need

    https://stackoverflow.com/questions/...-port-from-vba

    Also google 'vba send data to com port' or similar to find a number of similar threads

  3. #3
    Greg J Good is offline Novice
    Windows 8 Access 2013
    Join Date
    Oct 2015
    Location
    So CA, USA
    Posts
    3
    Thank you! I will check this out.

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

Similar Threads

  1. Replies: 2
    Last Post: 11-23-2015, 06:40 PM
  2. Acquire Blue Tooth GPS data via comm port
    By Galmala in forum Import/Export Data
    Replies: 1
    Last Post: 04-18-2013, 01:49 PM
  3. Replies: 4
    Last Post: 11-29-2012, 12:45 AM
  4. Access as Default Program for Device
    By Meep in forum Forms
    Replies: 1
    Last Post: 04-13-2012, 10:40 AM
  5. Capture data from TCP port
    By todster in forum Access
    Replies: 0
    Last Post: 07-19-2011, 12:22 AM

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