Search

[Bill]

Hi,

I am able to search the name anything when searching "Dav" and I got the
results:
David
Davie
Dav

Criteria = "UCASE([Name]) Like " & Chr(34) & SearchName & "*" & Chr(34)

Am I doing wrong with CODE and not getting the result. I want to search
"avi" but I couldn't get any results. I want to see two names only without
"DAV"
David
Davie

Your help would be much appreciated.

 

[Brian]

Hi,

I am able to search the name anything when searching "Dav" and I got the
results:
David
Davie
Dav

Criteria = "UCASE([Name]) Like " & Chr(34) & SearchName & "*" & Chr(34)

Am I doing wrong with CODE and not getting the result. I want to search
"avi" but I couldn't get any results. I want to see two names only without
"DAV"
David
Davie

Your help would be much appreciated.

To get just the names containing "avi" you need another wildcard at the
front i.e.

LIKE "*avi*"

or, in your code:

Criteria = "[Name] Like ""*" & SearchName & "*"""

Note that the case is irrelevant, hence I have removed the Ucase function.

 

[Michael Cheng [MSFT]]

Hi Bill,

I think Brian's suggestion hit the right trick! Have you tried it? If you
encounter any difficulty, please do not hesitate to let me know. Please
post here and let me know the status of your issue. Without your further
information, it's very hard for me to continue with the troubleshooting.

Looking forward to hearing from you soon


Sincerely yours,

Michael Cheng

Online Partner Support Specialist
Partner Support Group
Microsoft Global Technical Support Center