filter with like

Question

Hi,

I want to use 'Filter' to search by 'First Name' in my tblEmployees.

Me.Filter = " strFirstName= Like ' " &txtFilterFirstName& " * ' "

I want to add 'Like ' to use wildcard.

Do you think this is right code?

Answer 1

I want to use 'Filter' to search by 'First Name' in my tblEmployees.

 

Me.Filter = " strFirstName= Like ' " &txtFilterFirstName& " * ' "

 

I want to add 'Like ' to use wildcard.

 

Do you think this is right code?

It seems to me that it's almost right, except that the equals operator (=) and the Like operator are mutally exclusive, and you seem to have extra spaces in the filter string.  In some places an extra space doesn't matter, but in other places it does.  I would write this:

    Me.Filter = "strFirstName Like '" & txtFilterFirstName & "*'"

That assumes that "strFirstName" is actually the name of the First Name field in your table.  Note also that this code will fail if txtFilterFirstName contains a single-quote or apostrophe (').  Maybe it would be better to use double-quotes around the specified name fragment, but to do that, you have to double up the double-quotes, like this:

    Me.Filter = "strFirstName Like """ & txtFilterFirstName & "*"""

Answer 2

Thanks!!

Answer 3

Thank you so much!!

I spent quiet some time to fix this but I couldn't.

How can I learn these quotation marks? 

You're welcome.

At least in Access 2003, 2007, and 2010, there's an article in the online help file entitled "Quotation Marks in Strings".  The same article is posted online here:

    http://msdn.microsoft.com/en-us/library/office/aa212167(v=office.11).aspx

That's the Access 2003 version, but I don't think it's any different among the various version of Access.

Answer 4

Thank you so much!!

I spent quiet some time to fix this but I couldn't.

How can I learn these quotation marks?