ADODC Search code

[cybuster]

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

[PVBert]

I don't get it. Don't you have google?

In 1 second I got this result.
Look here: http://hamilton.bell.ac.uk/swdev1/notes_pp1_5.doc

I just searched on: +adodc +recordset +select
You can also try to seach on: +adodc +recordset +find

[jamello]

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

adSearchForward or adSearchBackward can be used.

[ahmed elweshahy]

re as recordset
dim x as string
x=inputbox("enter the name please :")
re.findfirst"name=' " & x & " ' "
if re.nomatch then
msgbox "the name You Entered not found"
end if

[PVBert]

The .nomatch property doesn't exist in ADO.

[mivc]

Remember that you can only search on 1 field with the FindFirst method.

The following code will not work;

rs.findfirst "NAME=" & 'NAME' & " AND POBOX=" & '2300 PD'

[PVBert]

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 "
cmd.Execute
    
' 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()

rs.Close
cn.Close