Member Avatar for bratinela

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
  • 133 Views
  • 1 Day Discussion Span
  • Latest Post Latest Post by ImZick
Member Avatar for ImZick

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

Be a part of the DaniWeb community

We're a friendly, industry-focused community of developers, IT pros, digital marketers, and technology enthusiasts meeting, networking, learning, and sharing knowledge.