944,047 Members | Top Members by Rank

Ad:
  • VB.NET Discussion Thread
  • Unsolved
  • Views: 5395
  • VB.NET RSS
Jan 15th, 2007
0

VB.net Front-end Access Back-End Question

Expand Post »
I want to use an MS Access Database as a back-end.

I am trying to:
Use data in one field (column) of my Access database as the items in a listbox

Example, "Customer #" is a field in my database, i want to show all of the customer numbers in a dropdown.

I need help from the database connection, to displaying items in one field of my database in a listbox.

Is there anybody out there that knows how to do this??? Please help.

P.S. I am trying to somehow be able to input a customer number, and have my VB program display some other info about that record (other columns). if you have a suggestion overall of a better way to do this than a listbox I am open to suggestions.
Last edited by Tim Riley; Jan 15th, 2007 at 5:04 pm.
Similar Threads
Reputation Points: 10
Solved Threads: 0
Newbie Poster
Tim Riley is offline Offline
2 posts
since Jan 2007
Jan 16th, 2007
0

Re: VB.net Front-end Access Back-End Question

in the "server explorer" tootlbar , right click to make a new conection and dataset and point it to your Access database - make sure you choose Jet as your data provider. Then you should just be able to set the comboiboxes datasource property to that table.
Moderator
Featured Poster
Reputation Points: 1800
Solved Threads: 575
Moderator
jbennet is offline Offline
16,526 posts
since Apr 2005

This thread is more than three months old

No one has posted to this discussion for at least three months. Please let old threads die and do not reply to them unless you feel you have something new and valuable to contribute that absolutely must be added to make the discussion complete. Otherwise, please start a new thread in this forum instead.
Message:
Previous Thread in VB.NET Forum Timeline: InvalidCastException in VB.NET?
Next Thread in VB.NET Forum Timeline: 8th Grade 14 IT Tech?





About Us | Contact Us | Advertise | Acceptable Use Policy
Forum Index | Build Custom RSS Feed


Follow us on Twitter


© 2011 DaniWeb® LLC