Trying to get this code to work

[jonwentz]

Hi All,

I have been trying for some to to get this code to work in an ADP, it works just fine in and MDB. It has me stumped. I have tried it as a View, SP, Function. I have tried to change the wildcard from * to %, but it still will not work.

Like "*" & [Forms]![Searchform]![Searchtext] & "*"

I am trying to use a from to provide my query data.

Thanks in Advance
Jon

 

[FoFa]

Like "'%" & [Forms]![Searchform]![Searchtext] & "%'"

You need the single quotes around the whole thing, and I think %, but if that doesn't work try the * again.

 

[jonwentz]

just tried you suggestion but it didnt like it

 

[FoFa]

This will only work in a dynamic SQL statement, or access query. You can use it in a SP but have to pass the value as a parameter. A SQL statement running on the SQL server will not be able to access the value from the form directly.
Can you expand on how you are using it?

 

[jonwentz]

What I am trying to do is use the example that Gromit Posted for an Access database, and use it in an ADP