how to search data from access databse in VB6

In Visual Basic 6 if someone trying to access some data from a table from a column the best way is to use SQL.
Lets say the ADO control is named is dat1.So the SQL looks something like this 

dat1.RecordSource = "SELECT * FROM Table1 WHERE ID LIKE  '" & Text9.Text &"%'"       dat1.Refresh dat1.Caption = dat1.RecordSource

here 'Table1' is name of the table from where one want to search data,'ID' is the name of the column and 'Text9' is the name of the text box.The data entered in the  Text9 text box will be the search input.
I have used wildcard.For MS Access '&' is used as a wildcard.
This is the MS Access database table that i have connected to my VB project and from whare i want to search for data.

This is the application that search the ID and gives the relevant data.

 

GOOD LUCK!

WBUT ECE 3rd year syllabus

DOWNLOAD FULL SYLLABUS

Reclaim your DVDs.

Many times we face a very common yet unrecoverable problem and that problem is read error or CRC error while reading a DVD. 

Today I will show you different methods of overcoming this problem.

 First of all if you are installing from the DVD or playing directly from DVD then don’t do that. Copy it to your local hard drive. And eventually you will get the error message while copying from normal Window copy pest. You must use Tera copy (click on the link to download) or similar software which can error freely copy from a DVD.

The other thing that you can do yet the risky one is to clean you DVD read write side (i.e the glossy side which you are told not to touch) some time when a DVD is left for a long time due to moisture the glossy side becomes opaque due to dust deposition. Hence laser can not read correctly. So follow these steps.

1. Spray Collin or other cleaner that is used to clean tables or TV screen.(i.e used to clean glass) on the glossy side.

2. Leave it for a second and the rub the glossy side with cotton, rub it until all the Collin is dry.

3. DVD is ready for use.