>Hi, I am going to be searching for a record in the db.I am using the recordset.find method to search through the data.
>Heres the code..
>
>Dim cnClientdata As ADODB.Connection
>Dim rsClientdata As ADODB.Recordset
>Dim sFindCriteria As String
>
>Set cnClientdata = New ADODB.Connection
>Set rsClientdata = New ADODB.Recordset
>
>sFindCriteria = "clientphone like '" & _
> Phonenum & "*'"
>
>
>With cnClientdata
> .Provider = "SQLOLEDB"
> .ConnectionString = "User ID=user;Password=user;" & _
> "Data Source=user;" & _
> "Initial Catalog=user"
> .Open
>
>End With
>
>*When this line gets executed, I get an error: COMMAND TEXT NOT SET *
>* What does this mean ? *
>
> rsClientdata.Open , cnClientdata
> rsClientdata.MoveFirst
> rsClientdata.Find SearchCriteria, , adSearchForward
>
> Thanks
>Niv
Use % instead of *
Éric Moreau, MCPD, Visual Developer - Visual Basic MVP
Conseiller Principal / Senior Consultant
Moer inc.
http://www.emoreau.com