0

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
10
Views
3 Years
Discussion Span
Last Post by Oxiegen
0

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.

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.