wildcard on a text string

token_remedie

Registered User.
Local time
Today, 18:52
Joined
Jul 7, 2011
Messages
78
Hey all,
I'm using Allen Browne's wonderful search sheet(http://www.everythingaccess.com/tutorials.asp?ID=Build-a-search-criteria-form) and tweaking it for my own purposes and I would like the below text box to be wildcarded on each side, is this possible?

Code:
   strWhere = strWhere & "([Asset Description] Like  """ & Me.txtFilterAssetDescription & """) AND "


Thank you
 
Code:
strWhere = strWhere & "([Asset Description] Like  ""*" & Me.txtFilterAssetDescription & "*"") AND "
 
haha I was so close, I tried:

strWhere = strWhere & "([Asset Description] Like """&"*" & Me.txtFilterAssetDescription & "&"*"") AND "
and being a noob I'm happy that I was so close on my own before I came here
Thank you I'll test it out soon :)
 

Users who are viewing this thread

Back
Top Bottom