I get error Syntax error (missing operator) in query expression 'Name LIKE '%V%@'' on this code
Code:Select Case cmbOperation(0).ListIndex Case 0 strFilter = strFilter & " LIKE '%" & txtFilter(0).Text & "%'" Case 1 strFilter = strFilter & " = '" & txtFilter(0).Text & "'" Case 2 strFilter = strFilter & " <> '" & txtFilter(0).Text & "'" Case 3 strFilter = strFilter & " > '" & txtFilter(0).Text & "'" Case 4 strFilter = strFilter & " >= '" & txtFilter(0).Text & "'" Case 5 strFilter = strFilter & " < '" & txtFilter(0).Text & "'" Case 6 strFilter = strFilter & " <= '" & txtFilter(0).Text & "'" End Select ConnectToDB Set mobjRst = New ADODB.Recordset 'mobjRst.Open "SELECT * from Customer where " & Me.cmbFields.Text & strFilter strSQL = "SELECT * from Customer where " & Me.cmbFields.Text & strFilter mobjCmd.CommandText = strSQL Set mobjRst = mobjCmd.Execute
Debug linecan anyone help?Code:Set mobjRst = mobjCmd.Execute




Reply With Quote