Want to win a PS4? Go Premium and enter to win our High-Tech Treats giveaway. Enter to Win

x
?
Solved

Rs 232 data to ms access

Posted on 2006-06-23
4
Medium Priority
?
763 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 1000 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 1000 total points
ID: 16975244
0

Featured Post

Important Lessons on Recovering from Petya

In their most recent webinar, Skyport Systems explores ways to isolate and protect critical databases to keep the core of your company safe from harm.

Question has a verified solution.

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

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.
Did you know that more than 4 billion data records have been recorded as lost or stolen since 2013? It was a staggering number brought to our attention during last week’s ManageEngine webinar, where attendees received a comprehensive look at the ma…
Learn how to number pages in an Access report over each group. Activate two pass printing by referencing the pages property: Add code to the Page Footers OnFormat event to capture the pages as there occur for each group. Use the pages property to …
Access reports are powerful and flexible. Learn how to create a query and then a grouped report using the wizard. Modify the report design after the wizard is done to make it look better. There will be another video to explain how to put the final p…

636 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