Jump to content
Sign in to follow this  

Read Access Database

Recommended Posts


I am having trouble grasping some of the programming needed to open an Access Database and read recoreds from it.

I created a System DSN for my database so that SQL querys can be perfomred on the database. I can manuall query the database and get the recored and filelds I want to use.

What I am trying to do is present a list of the database records sorted buy Company Name and them present it in a list to the user. I will then let the user select a record fromthe list. What should I use a check box, pressing enter, what do you recommend? Based on the users selection I will set variables for specific fields and pass them to my program.

These was some code I got from the site that did not work due to a bad variable. I was unable to resolve the problem, after many hours of trying, and gave up.

Any help here would be greatly appreciated. I tried all weekend to get this working but do not have enough skills yet to get it accomplished.


Share this post

Link to post
Share on other sites


Create Retrieve info button

Run query

Loop through records

Add ListViewItem for each record

End Loop

GuiCtrlRead Listview to get listview position

Read from array element position of previous statement

Share this post

Link to post
Share on other sites

Create an account or sign in to comment

You need to be a member in order to leave a comment

Create an account

Sign up for a new account in our community. It's easy!

Register a new account

Sign in

Already have an account? Sign in here.

Sign In Now
Sign in to follow this