Searching using a datagrid..?
Posted on 2002-07-18
I would like to be able to search for records and have them displayed on a datagrid. It would be even better if I could just type part of the relevant field and get results that match. eg typing 'jo' and getting all the names that begin with Jo...
Ive tried using the following, with a few variations, to no avail. (I'm using MS Access 2000, and connecting with ADO)
"SELECT * from TableName WHERE FName like 'Jo*'",connect..
The connection and all are OK, My only problem is it seems to have a problem with the criteria...