Search Access Records

Expand Post »

I'm working with Visual Studio.net and Access 2002 to build an interface to add, edit and delete records in the database. Eventually, I'd like to build a web page to be able to view the data.

Currently, I'm trying to search for a particular record in the database using a vb input box to retrieve data from two tables joined by an ID number. Following is the basic design:

User completes the input box to search for the ID number.
The input is used to select row from Table A and Table B where ID number is the same.
Display selected data from both tables for viewing, editing or deleting.

I had used VB6 years ago. I'm trying to get back into programming for my own use, so I'm basically teaching myself through trial and error. I've never used the OleDbDataAdapter or DataGrid before and have been unsuccessful in getting this to work. I understand parameters, but can't seem to come up with the right code and where to place it. Can anyone help?

Thanks!

Similar Threads

Create Access Database using SQL queries in MS Access and FileMaker Pro
sql query problem with MS Access and C# in C#
Searching for records contained in access from VB in Visual Basic 4 / 5 / 6
VB 6.0. Creating a file for random access in Visual Basic 4 / 5 / 6
Problems using a php generator in PHP

asdengler

Reputation Points: 10

Solved Threads: 0

Newbie Poster

Offline

2 posts
since Sep 2008

Permalink

Sep 12th, 2008

Re: Search Access Records

there are many good tutorials in net like this and this
you can search for more and it will help you to come up with your code
if you need help you can ask here

Last edited by manal; Sep 12th, 2008 at 4:25 pm.

manal

Reputation Points: 37

Solved Threads: 17

Junior Poster

Offline

122 posts
since Mar 2006

Permalink

Sep 12th, 2008

Re: Search Access Records

Thanks. I'll give it a try.

asdengler

Reputation Points: 10

Solved Threads: 0

Newbie Poster

Offline

2 posts
since Sep 2008

This thread is solved

Either the thread starter or a moderator has marked this thread as solved. You can most likely trust the responses and answers given. There is most likely no reason for any further responses to be posted here. If you have a related question, please start a new thread in this forum instead.

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.

Previous Thread in VB.NET Forum Timeline: Display weight base on a age value?

Next Thread in VB.NET Forum Timeline: C++'s SETW() Equivalent in VisualBasic.NET

DaniWeb Message

Cancel Changes

User Name
Password