Wild card search

[4808]

Hello,

Can anyone help me create a code to do a wild card search please.

Many thanks

Alph

 

[ZmrAbdulla]

Where? on form? In query? SQL?
In the criteria of the query.

Like "*" & [Forms]![FrmName]![FindText] & "*"

or

Like  [Forms]![FrmName]![FindText] & "*"

Did you try to have an Advanced Search?
also please read these FAQs those help you to get most out of your membership
JeremyNYC
MikeLacey
johnwm

Zameer Abdulla
Visit Me (New Look & style)

 

[HarleyQuinn]

If you are wanting to do it in SQL then something like:

SELECT *
FROM yourtable
WHERE yourfield LIKE "*"

If not you could do a keyword search for 'wildcard' and that will turn up lots of results to help you.

Cheers

Harleyquinn

---------------------------------
For tsunami relief donations

 

[HarleyQuinn]

Darn slow typing...

Harleyquinn

---------------------------------
For tsunami relief donations