Hi
Can anybody help me on wildcard search in VB.06.
Database have two fields txtpwd and txtuser.
txtUser field has iali1, iali2, iali3... records
When i'm using txtuser value i could find the records but when i'm
trying to using wildcard method following error occurs.
Syntax error (missing operator) in query expression 'Like 'ial*'
On Error GoTo 12
Set cn = New ADODB.Connection
cn.ConnectionString = "Provider = Microsoft.Jet.OLEDB.4.0;Data
Source= C:\DBadodb.mdb;"
cn.Open
Set lgntable = New ADODB.Recordset
lgntable.ActiveConnection = cn
lgntable.Open ("Select * From tbllogin Where Like 'ial*'")
12:
Debug.Print Err.Description
Can anybody assist me on this
Thanks in advance.
