Login | Register   
LinkedIn
Google+
Twitter
RSS Feed
Download our iPhone app
TODAY'S HEADLINES  |   ARTICLE ARCHIVE  |   FORUMS  |   TIP BANK
Browse DevX
Sign up for e-mail newsletters from DevX


Tip of the Day
Language: ADO
Expertise: Beginner
May 22, 2000

Searching with Multiple Fields

Question:
I am developing a s/w with an Access database, using ADO. Now, I want to search a table with multiple columns. As in find method (ADO), it allows only one column to search. How do I search a record with a multiple column search?

Answer:
Use the Recordset's Filter property. You can use any valid SQL WHERE clause (without the word WHERE), such rs.Filter="fname='Mike' AND lname='Jones'". This method filters the recordset to contain only matching records.

To remove the filter, set the filter property to blank or zero.

DevX Pro
 
Comment and Contribute

 

 

 

 

 


(Maximum characters: 1200). You have 1200 characters left.

 

 

Sitemap