Solved

Rs 232 data to ms access

Posted on 2006-06-23
4
758 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

Free Tool: Site Down Detector

Helpful to verify reports of your own downtime, or to double check a downed website you are trying to access.

One of a set of tools we are providing to everyone as a way of saying thank you for being a part of the community.

Question has a verified solution.

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

Suggested Solutions

Title # Comments Views Activity
Adding new field to an existing database in access 3 28
Error can't find table ?? 5 28
Problem with vba code 4 45
Number of records returned on a form 5 26
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…
This article describes two methods for creating a combo box that can be used to add new items to the row source -- one for simple lookup tables, and one for a more complex row source where the new item needs data for several fields.
With Microsoft Access, learn how to specify relationships between tables and set various options on the relationship. Add the tables: Create the relationship: Decide if you’re going to set referential integrity: Decide if you want cascade upda…
In Microsoft Access, when working with VBA, learn some techniques for writing readable and easily maintained code.

821 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