0

hi.please help me how to program a command search in simple way.because all sight here so hard and i'm just a beginner in vb6.with adodc codes,thanks :)))

2
Contributors
1
Reply
23
Views
4 Years
Discussion Span
Last Post by ImZick
0

I hope u know how to connect adodc1 to your database.

'Put this on a command button

Adodc1.RecordSource = "SELECT * FROM TABLE1 where last_name =  '" & Text1.Text & "' "
Adodc1.Recordset.Requery
Adodc1.Refresh
Adodc1.Caption = Adodc1.Recordset.RecordCount

In this example all the last_name field that equal to text1 will count

This topic has been dead for over six months. Start a new discussion instead.
Have something to contribute to this discussion? Please be thoughtful, detailed and courteous, and be sure to adhere to our posting rules.