Query by Form Text Boxes, can it be done..

  • Thread starter Thread starter Guest
  • Start date Start date
G

Guest

I have 15 columns of data I'd like to filter. The database I'm creating is
supposed to be so user friendly someone with no experience can navigate.

Anyhow, the idea is to have a form set up with 15 text boxes the user can
input values into, each box corresponds to a column to be searched.

Is there a way to set up a query to allow for any number of the 15 text
boxes to remain empty and still query the results filtering by the user
defined values?
 
In the code behind the form, parse each of the entered values into a SQL
WHERE clause.
 
You must log in or register to reply here.

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Similar Threads

Query using text from form or anything if empty 2
Multiple Parameter Crosstab query filter by form 1
Is It Possible To Disable Combo Box on Parameter Query Form 4
Using a form instead of a parameter query. 4
Query Criteria Not Working 2
Query Criteria from Form Problem 7
use field list from form to specify query fields 2
Append query from form input - Access 2000 1

Back
Top