Wildcards?

G

GregB

I want to create a query that lets users search for an item in a column.

I know for input you put Like [Enter Search Here]
and I know for wild cards you use the * key

However, I am having a trouble putting them together. For example if a user
wants to search the notes function.

Thanks!
 
J

Jerry Whittle

Debug.Print StrConv("HAPPY EASTER",3) returns Happy Easter. 3 = vbProperCase.

Debug.Print StrConv("HAPPY EASTER",2) returns happy easter. 2 = vbLowerCase.

Debug.Print LCase("HAPPY EASTER") returns happy easter.

Debug.Print Left(UCase("HAPPY EASTER"),1) & Mid(LCase("HAPPY EASTER"),2)
returns Happy easter.
 
G

GregB

Thanks, Works Great!

kingston via AccessMonster.com said:
To create a parameter query with wildcards, do something along these lines:

Like "*" & [Parameter1] & "*" & [Parameter2] & "*"

I want to create a query that lets users search for an item in a column.

I know for input you put Like [Enter Search Here]
and I know for wild cards you use the * key

However, I am having a trouble putting them together. For example if a user
wants to search the notes function.

Thanks!
Click to expand...
Click to expand...
 
J

Jerry Whittle

Whoops! That was what I hope is the right answer for another question.

Sorry about that.
--
Jerry Whittle, Microsoft Access MVP
Light. Strong. Cheap. Pick two. Keith Bontrager - Bicycle Builder.


Jerry Whittle said:
Debug.Print StrConv("HAPPY EASTER",3) returns Happy Easter. 3 = vbProperCase.

Debug.Print StrConv("HAPPY EASTER",2) returns happy easter. 2 = vbLowerCase.

Debug.Print LCase("HAPPY EASTER") returns happy easter.

Debug.Print Left(UCase("HAPPY EASTER"),1) & Mid(LCase("HAPPY EASTER"),2)
returns Happy easter.
--
Jerry Whittle, Microsoft Access MVP
Light. Strong. Cheap. Pick two. Keith Bontrager - Bicycle Builder.

GregB said:
I want to create a query that lets users search for an item in a column.

I know for input you put Like [Enter Search Here]
and I know for wild cards you use the * key

However, I am having a trouble putting them together. For example if a user
wants to search the notes function.

Thanks!
Click to expand...
Click to expand...
 
Top