I'm trying to create a search keyword in vba for a database in access. It doesnt work

[JoseMessiHDZ]

 
 
Private Sub Command24_Click()
Dim strsearch As String
Dim strText As String
strText = Me.TxtSearch.Value
strsearch = "SELECT * from Spare_Parts where ((PartName/Description like ""*" & strText & "*"") or (Manufacturer like ""*" & strText & "*""))"
Me.RecordSource = strsearch
End Sub
 
Private Sub Command25_Click()
Dim strsearch As String
strsearch = "SELECT * from Spare_Parts"
Me.RecordSource = strsearch
End Sub
 
 
 

[Luk3r]

In VBA you must use the % operator instead of the * operator when using LIKE

[MikeTheBike]

Hi

I think for Access objects i.e. forms, list and combo boxes etc. (and DAO recordsets I think) you use an * as the wild card. However, ADO recordset definitely use a %.

I never use DAO recorsets, so been caught out a few time pasting sql view strings in to ADO sql variable.


MTB