search

[lee123]

I have a form on which I want to search and find a company name in a datagrid. The button I have I have named cmdsearch but the code to use the "find" I don't understand it. So if someone could explain how to use this method it would be great:

object.find(cri teria[,skiprows][,searchdirectio n][,start])

adodc is run by an Access database (2000).

lee123

[daniel aristidou]

I have a form on which I want to search ...

Could you please state which version of VB you use?

[lee123]

yes i can i am using vb6.0

lee123

[daniel aristidou]

i am using vb6.0

lee123

Could you also post which datagrid you are using eg microsoft datagrid 6
Since each datagrid uses different methods

[lee123]

yea it's datagrid 6.0 i hope that helps.

lee123

[lee123]

ok i have entered this in the button:

Private Sub CmdSearch_Click()
    Dim strcompanyname As String
    strcompanyname = InputBox("Enter In A CompanyName Please")
    Adodc1.Recordset.Find "Companyname= '" & strcompanyname & "'"
End Sub

but when i search for a record it only searches down and not up. how do i get it to search both ways.

lee123

[Killer42]

Not really familar with ADODC, but perhaps you need to do something like MoveFirst before starting the search, so it starts form the beginning. The nice thing about this, of course, is that by not going to the start, you can easily do a "find next" function.

[lee123]

Hey that will work. You know I should of thought of that but I didn't. Thanks killer42 you really are good at this.

lee123

[Killer42]

Thanks for that. I'm just glad we could help.