Want to protect your cyber security and still get fast solutions? Ask a secure question today.Go Premium

x
  • Status: Solved
  • Priority: Medium
  • Security: Public
  • Views: 765
  • Last Modified:

Rs 232 data to ms access

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
sigs66
Asked:
sigs66
2 Solutions
 
Rick_RickardsCommented:
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
 
nico5038Commented:
0

Featured Post

Free learning courses: Active Directory Deep Dive

Get a firm grasp on your IT environment when you learn Active Directory best practices with Veeam! Watch all, or choose any amount, of this three-part webinar series to improve your skills. From the basics to virtualization and backup, we got you covered.

Tackle projects and never again get stuck behind a technical roadblock.
Join Now