Member Avatar for jose.angelo.santos

I needed help for the codes in displaying data from access by searching a keyword and display the other info on labels.

something like:

textbox(surname as keyword) commandbutton(search)

lblSurname lblFirstname lblMiddlename

thank you

  • 2 Contributors
  • 1 Reply
  • 89 Views
  • 10 Hours Discussion Span
  • Latest Post Latest Post by Oxiegen
Member Avatar for Oxiegen

I did that once in a project I was working on, but with SQL server.
You could construct a SQL query in which the WHERE clause looks something like this:

WHERE <field1> like '%<keyword>%' OR <field2> like '%<keyword>%' OR <field3> like '%<keyword>%'

And so on.

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.