Wildcard form search

[Guest]

Hi there,

When I use the following code:
stLinkCriteria = "[strVendor]=" & "'" & Me![txtExpVend] & "'"
as part of my open form criteria obviously I get EXACTLY what is typed into
txtExpVend. I want to be able to find "Bay" for example, but if the data was
entered as "The Bay", this code won't find it. I've tried messing aboud with
the * sign but am not sure where to put it.

All help appreciated!

JR

 

[Ken Snell \(MVP\)]

stLinkCriteria = "[strVendor]=" & "'*" & Me![txtExpVend] & "*'"

 

[Ken Snell \(MVP\)]

Error in my just-sent post. This is the correct expression:

stLinkCriteria = "[strVendor] Like " & "'*" & Me![txtExpVend] & "*'"

 

[Brendan Reynolds]

stLinkCriteria = "[strVendor]=" & "'*" & Me![txtExpVend] & "*'"

The aim is that the result of the expression ends up looking like so ...

'*Bay*'

 

[Guest]

Try using Like

stLinkCriteria = "[strVendor] Like '*" & Me![txtExpVend] & "*'"

 

[Marshall Barton]

When I use the following code:
stLinkCriteria = "[strVendor]=" & "'" & Me![txtExpVend] & "'"
as part of my open form criteria obviously I get EXACTLY what is typed into
txtExpVend. I want to be able to find "Bay" for example, but if the data was
entered as "The Bay", this code won't find it. I've tried messing aboud with
the * sign but am not sure where to put it.

stLinkCriteria = "strVendor='*" & Me![txtExpVend] & "*'"

 

[Brendan Reynolds]

Oops! Forgot to change the second "=" to "LIKE" ...

stLinkCriteria = "[strVendor] LIKE " & "'*" & Me![txtExpVend] & "*'"

--
Brendan Reynolds
Access MVP

stLinkCriteria = "[strVendor]=" & "'*" & Me![txtExpVend] & "*'"

The aim is that the result of the expression ends up looking like so ...

'*Bay*'

--
Brendan Reynolds
Access MVP

Hi there,

When I use the following code:
stLinkCriteria = "[strVendor]=" & "'" & Me![txtExpVend] & "'"
as part of my open form criteria obviously I get EXACTLY what is typed
into
txtExpVend. I want to be able to find "Bay" for example, but if the data
was
entered as "The Bay", this code won't find it. I've tried messing aboud
with
the * sign but am not sure where to put it.

All help appreciated!

JR

 

[Guest]

Hi Marsh
Apperantly almost everybody forgot to change the = to Like

--
\\// Live Long and Prosper \\//

When I use the following code:
stLinkCriteria = "[strVendor]=" & "'" & Me![txtExpVend] & "'"
as part of my open form criteria obviously I get EXACTLY what is typed into
txtExpVend. I want to be able to find "Bay" for example, but if the data was
entered as "The Bay", this code won't find it. I've tried messing aboud with
the * sign but am not sure where to put it.

stLinkCriteria = "strVendor='*" & Me![txtExpVend] & "*'"

 

[Guest]

Thanks all for that group effort! Works perfectly!

JR
--
www.brightfuture.ca/bright
My email address can be found on my site.

Hi Marsh
Apperantly almost everybody forgot to change the = to Like

--
\\// Live Long and Prosper \\//

When I use the following code:
stLinkCriteria = "[strVendor]=" & "'" & Me![txtExpVend] & "'"
as part of my open form criteria obviously I get EXACTLY what is typed into
txtExpVend. I want to be able to find "Bay" for example, but if the data was
entered as "The Bay", this code won't find it. I've tried messing aboud with
the * sign but am not sure where to put it.

stLinkCriteria = "strVendor='*" & Me![txtExpVend] & "*'"

 

[Marshall Barton]

Hi Marsh
Apperantly almost everybody forgot to change the = to Like

Yech, it's been one of those weeks. I hope I recover soon
;-)