Solved

Rs 232 data to ms access

Posted on 2006-06-23
4
760 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
[X]
Welcome to Experts Exchange

Add your voice to the tech community where 5M+ people just like you are talking about what matters.

  • Help others & share knowledge
  • Earn cash & points
  • Learn & ask questions
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: Path Explorer

An intuitive utility to help find the CSS path to UI elements on a webpage. These paths are used frequently in a variety of front-end development and QA automation tasks.

One of a set of tools we're offering 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

A simple tool to export all objects of two Access files as text and compare it with Meld, a free diff tool.
Microsoft Access is a place to store data within tables and represent this stored data using multiple database objects such as in form of macros, forms, reports, etc. After a MS Access database is created there is need to improve the performance and…
In Microsoft Access, when working with VBA, learn some techniques for writing readable and easily maintained code.
With Microsoft Access, learn how to start a database in different ways and produce different start-up actions allowing you to use a single database to perform multiple tasks. Specify a start-up form through options: Specify an Autoexec macro: Us…

696 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