Search all for data containing....problem.

[ShawnCartwright]

Hi,

I'm new to access and visual basic and have currently set up a database. I want the search button to return all the values containing the information I have entered. Such as *Karen*. Is there away to do this by putting in a value. I saw something with '%" but dont really know what Im doing with it. Sorry bit of a noob but still trying to learn.

I've used this code below for the search. If anyone can help me Id be grateful.



If Me.txtSupplierNumber > "" Then
varWhere = varWhere & "[SupplierNumber] like " & SupplierNumber & Me.txtSupplierNumber & SupplierNumber & " AND "
End If

[ShawnCartwright]

Was going to delete this for being a complete tool but Im sure someone will benefit from it. Add the value "*" either side of the textbox or object you wish to search for.

If Me.txtCustomerNumber > "" Then
varWhere = varWhere & "[CustomerNumber] like " & CustomerNumber & "*" & Me.txtCustomerNumber & "*" & CustomerNumber & " AND "
End If

[Missinglinq]

You need to also note that

If Me.txtCustomerNumber > "" Then

doesn't really validate whether or not txtCustomerNumber is populated. There are a number of ways to do that, I usually use

If Nz(Me.txtCustomerNumber, "") <> "" Then

which checks for Nulls (which is what the majority of 'empty' Controls/Fields actually hold) and for Zero-Length Strings ("") which, under some circumstances, can display as 'empty.'

Linq ;0)>