Solved

Rs 232 data to ms access

Posted on 2006-06-23
4
756 Views
Last Modified: 2008-01-09
I have a digital weighing scale that uses RS232 serial port . I want the infomation from the scale to end up in MS Access (sitting on a windows XP machine). What references do I need to add in and does someone have some sample code? Please help.

Cheers & Thanks
 
0
Comment
Question by:sigs66
4 Comments
 
LVL 16

Accepted Solution

by:
Rick_Rickards earned 250 total points
ID: 16974097
Assuming the scale came with software that exposes the API you would need to do one of two things.  

1) Create a reference that points tho the DLL, OCX or other support file that exposes the API.  Once you know what file to point to open any module and select the tools pull down menu, then select references.  If you don't see the library in the list you can click brows and direct windows to its location.

OR

2) Declare a Function that will provide Access to the supporting file(s) required.  Declarations such as these are inserted into modules and look similar to this...

          Private Declare Function SetWindowRgn Lib "user32" (ByVal hwnd As Long, ByVal hRgn As Long, ByVal bRedraw As Boolean) As Long

Exactly which library or libraries need to be exposed will depend on your scale and the software that came with it.  Also, if you need to declare functions in this way it is possible that you may have to write some additional code, (often times a class object or two in addition to a few supporting modules), so that you can instantiate objects that allow you to retain a dialog with the device (or should I say the devices driver).

In either case all of this starts with the first question, whether or not the scale came with software that exposes the API that will make all this possible.  If so the battle can likely be won.

Rick
0
 
LVL 54

Assisted Solution

by:nico5038
nico5038 earned 250 total points
ID: 16975244
0

Featured Post

Ransomware-A Revenue Bonanza for Service Providers

Ransomware – malware that gets on your customers’ computers, encrypts their data, and extorts a hefty ransom for the decryption keys – is a surging new threat.  The purpose of this eBook is to educate the reader about ransomware attacks.

Question has a verified solution.

If you are experiencing a similar issue, please ask a related question

QuickBooks® has a great invoice interface that we were happy with for a while but that changed in 2001 through no fault of Intuit®. Our industry's unit names are dictated by RUS: the Rural Utilities Services division of USDA. Contracts contain un…
I see at least one EE question a week that pertains to using temporary tables in MS Access.  But surprisingly, I was unable to find a single article devoted solely to this topic. I don’t intend to describe all of the uses of temporary tables in t…
Basics of query design. Shows you how to construct a simple query by adding tables, perform joins, defining output columns, perform sorting, and apply criteria.
In Microsoft Access, learn how to “cascade” or have the displayed data of one combo control depend upon what’s entered in another. Base the dependent combo on a query for its row source: Add a reference to the first combo on the form as criteria i…

948 members asked questions and received personalized solutions in the past 7 days.

Join the community of 500,000 technology professionals and ask your questions.

Join & Ask a Question

Need Help in Real-Time?

Connect with top rated Experts

21 Experts available now in Live!

Get 1:1 Help Now