hi im just starting to design a database using adodc but I have a problem...
can someone give me tip on how to create a search code for ADODC... thx in advance
Try the following code.
adcBrowser.Recordset.Find txtSearchHdr.Text & " like '" & txtSearch & "_'", , adSearchForward
'adcBrowser is the name of your ADODC
'txtSearchHdr.Text is your recordset field
'txtSearch is your search criteria
if you want to search for a hypothetic recordset field sname for "surname"
begining with "dav" then txtSearchHdr.Text is sname
and txtSearch is dav
findfirst doesn't exist at all, so even searching on one field won't go
you can you select statements and use:
Dim cn As ADODB.Connection
Dim cmd As ADODB.Command
Dim rs As ADODB.Recordset
Set cn = New ADODB.Connection
Set cmd = New ADODB.Command
Set rs = New ADODB.Recordset
' Open the Connection object
cmd.ActiveConnection = cn
cmd.CommandText = "select "
' Open a Recordset object on the new table.
cmd.CommandText = "SELECT * FROM YOURTABLENAME WHERE YOURFIELDNAME = 'YOURVALUE' "
' "SELECT * FROM YOURTABLENAME WHERE YOURFIELDNAME = 'YOURVALUE' AND YOUROTHERFIELDNAME = 'ANOTHERVALUE' "
Set rs = cmd.Execute()