General information
Category:
COM, DCOM and OLE automation
Title:
Recordset FIND problems
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
Next
Reply
View the map of this thread
View the map of this thread starting from this message only
View all messages of this thread
View all messages of this thread starting from this message only