3 Years
Discussion Span
Last Post by Hanif1993


What have you tried so far? Where is your attempt?

To give you a start, check out How to Open ADO Connection and Recordset, this will show you how to connect to a database using ADO and how to open a recordset which will contain records from the database based on a query. It isn't a complete tutorial as it is missing some pieces such as moving through the recordset, but it will get you going. Then post back the code that you have tried and we will be able to help you further.



thanks i advance for the answer
i have linked a database with ado now how can i get a record from a field in a table? via box or via combo? and how? my db has tables and they have feilds, now i want to enter a record to the box and it show me the result how?


i don't know exactly what to do i will upload you a picture this picture i have linked the textbox to a datafild, now when i want to click on serach it should show me the result in the next textbox.

Edited by Hanif1993

Attachments Capture.JPG 25.09 KB

i figured it out and found the solotion like this:
'Adodcdsearch.Recordset.Find "[Name]='" & txtdsearch.Text & "'"
this was the code i was searching for.
thank you guys.

Edited by Hanif1993

This question has already been answered. Start a new discussion instead.
Have something to contribute to this discussion? Please be thoughtful, detailed and courteous, and be sure to adhere to our posting rules.