How to set up search form using WILDCARDS in data access page?

E

ebb

I am designing in Access2003. A simple parameter query using LIKE and "*"
does not work. I realize a different engine reads the query and doesn't read
the wildcards. What can I do? Different ANSI code?
 
T

Tim Ferguson

I am designing in Access2003. A simple parameter query using LIKE and
"*" does not work. I
Click to expand...

Depends on the library you are using. ADODB uses standard % and _ for
wildcards, while DAO still uses DOSalike * and ?

Hope that helps


Tim F
 
Top