The db i have written needs to be able to search using
wildcards
e.g. *abc123
allowing suffix and prefix searches.
What is the code?!?!?!?
I have recordset.findfirst code but i can't wildcard.
Somebody pleez help.
Printable View
The db i have written needs to be able to search using
wildcards
e.g. *abc123
allowing suffix and prefix searches.
What is the code?!?!?!?
I have recordset.findfirst code but i can't wildcard.
Somebody pleez help.
This is ADO Code, but it might work with DAO.
rstMain.Find "FirstName like 'Elias*'"