Is there any .ocx in Access to open Com Port (VBA)

[Engr. Matthew]

I have a challenge I am trusting honorable members of this platform to point me in a right direction. I want to display price of a product scanned to display on a POS Computer attached VFD display LD220. The only information I got from the company that sold the device is that the communication of the device to computer is through com port1.

I have no idea how to get Microsoft Access record display on a 2 line display device. Any help?? I know there maybe king of module, Function etc. to open the com port through VBA code and access an object attach to the com port 1. I really need help

thanks

 

[arnelgp]

there is a sample VBA serial com on Code Repository:

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. GitHub - Serialcomms/Serial-Ports-in-VBA-new-for-2022: Using Serial COM Ports in Visual Basic for Ap... Completely free, please let us know if they work for you thanks. J.

www.access-programmers.co.uk

 

[sonic8]

The only information I got from the company that sold the device is that the communication of the device to computer is through com port1.

Your challenges has two different layers.
The first layer is the low level handling of COM Port communication. The sample @arnelgp linked to is a good starting point and might be able to cover this for you completely.
The next layer is communicating with your external display. To do that you are going to need the document describing the communication protocol. Just googling for "VFD display LD220" turned up this User Manual which includes such a protocol description but I cannot say whether it actually applies to the device you are working with.