Keyword Search in 2007

[Smac]

The expression
Like "*"&[find what]&"*"
works in 2003 but does not work in 2007.
I am looking for a similar expression which carries out the same function - a keyword search within field in table.
Cheers

 

[MSAccessRookie]

The expression
Like "*"&[find what]&"*"
works in 2003 but does not work in 2007.
I am looking for a similar expression which carries out the same function - a keyword search within field in table.
Cheers

You will still need the Quotes around [find what]. Either of the options below should work.

• "*"&"[find what]"&"*"
• "*[find what]*"

 

[Smac]

Many thanks for your prompt reply - I have now tried both of the options suggested by you - but they return errors of incorrect syntax or expression to complex to evaluate?

Smac

 

[MSAccessRookie]

Many thanks for your prompt reply - I have now tried both of the options suggested by you - but they return errors of incorrect syntax or expression to complex to evaluate?

Smac

I am not yet fully familiar with Access 2007. I am sure there are others that have more experience who will be able to provide additional assistance.

 

[ill_comms]

I believe I've had the " incorrect syntax or expression to complex to evaluate" error before and found that it had something to do with the length of the string and query being worked out, I just split it into two lines e.g.:

sqlquery = "select * from blah"
sqlquery = sqlquery + "where blah = blah"

Also have you tried using % instead of *

Hayden

 

[Galaxiom]

Are you just using the expression in the Access query designer?
If so your original syntax should also work in 2007.
What is the error?
Definitely don't use quote marks around the Parameter.

 

[Smac]

Many thanks for your replies. Really appreciated.
Cheers