Go4Expert (http://www.go4expert.com/)
-   Visual Basic ( VB ) (http://www.go4expert.com/forums/visual-basic/)
-   -   How to search an access database (http://www.go4expert.com/forums/search-access-database-t674/)

meetmaruthi 1Apr2006 21:33

How to search an access database
i have 13 fields in my access table.it stores the admission information of a table.now if i click open on particular form it shows a dialog box .it contains a textbox in which i type the admission number of student. i need the particular record associated with it and i want all records to be retrieved into respective texboxes.

I am using data1 control on form to connect to ms access and vb 6.0
pls help me

coderzone 2Apr2006 07:44

Re: How to search an access database
Either you need to be firing the SQL or you need to be matching them by moving through each id in the data control.

rahulnaskar 3Apr2006 10:21

Re: How to search an access database
possibly, the easiest one is to change the sql of your data control and make it like:

"select * from <table> where <field1> = <value>"

where table is your table name, field1 is the field you want to search and value is the value supplied by user, and refresh the data control. You will be having the desired record in shortest possible time and can refresh the form with retrieved fields.

Hope this helps...


All times are GMT +5.5. The time now is 21:17.