data input via a comms port

[Nick T]

Hi,
I have a form with a text box on it called 'weight'.
I am planning to link a weighing scale upto the computer via the comms port.
The weigh scale does automatically send data out when it sees a weight,
however any suggestions how i can get this data to appear in my text box
'weight' on my form??
Is there any code i can write for this??

Thank in advance for any help.

 

[Arvin Meyer MVP]

Yes, you'll need an ActiveX control. See:

http://www.hardandsoftware.net/

where you should be able to find relevant information.

 

[Nick T]

Humm,
would you be able to provide a little more detail. I really dont know what
i want or where to start.....??
All i know is my scale will be connected to my comms port and i want the
output data to appear on my form in a specific text box.
How does an activeX control work and what to i do with it??

Thanks for any further guidance

 

[Nick T]

do you think i could avoid all this by using a RS232 - USB adaptor??

iv linked up a barcode scanner to a access db before and the scanner just
plugged into the usb port. this effectively put the scanned data into
whichever txt box had focus.

any thoughts anyone??

 

[Arvin Meyer MVP]

I have one device that uses a USB to Serial (RS232) adapter, but that
adapter is supplied by the device manufacturer, so I have no way of knowing
if they all do.

Glean what you can from Dick Grier's website mentioned below. He is the
expert and his site and book will have all the information you'll need.

 

[Albert D. Kallal]

There is a good list of articles here for using the serial port from
ms-access:

http://www.granite.ab.ca/access/serialport.htm

 

[Cory Dove]

Hi,
I have a form with a text box on it called 'weight'.
I am planning to link a weighing scale upto the computer via the comms
port.
The weigh scale does automatically send data out when it sees a weight,
however any suggestions how i can get this data to appear in my text box
'weight' on my form??
Is there any code i can write for this??

Thank in advance for any help.