In your Like call you need to use wildcards.
Such as "txt1 like '*" & textbox & "*'"
Printable View
In your Like call you need to use wildcards.
Such as "txt1 like '*" & textbox & "*'"
Actually I'm also facing this problem...
and but my problem is ...
i already included the wildcards
SQLString = "SELECT * FROM Main WHERE Name LIKE ('*John*')"
but it still cannot work with ado dc ..
btw, I using access2000 and the ado dc is bound to a datagrid.
Not an expert with ADO however I do beleive that the wildcard character is a '%' not a '*' .
The wildcard depends on if the the DBMS is ANSI standard...