User Interface: Query

[Guest]

Hi,

Instead of having to go into design view and type specific queries, is there
a way to create a friendly user interface, such as on a Switchboard, to allow
users to type in what they are searching for and then have the results
displayed, or is the only way to make queries through the design view?

Thanks,

 

[Allen Browne]

If you have a form, you can use the Filter buttons on the toolbar to filter
the form without having to create a query.

 

[Guest]

If the queries are often looking up the same thing, such as a particular
invoice number, you can create a query with something like the following in
the criteria:

[Forms]![frmSearch4Invoice]![txtInvoice]

Now create a form not linked to any table (AKA unbound form) named
frmSearch4Invoice. On this form put a text box named txtInvoice. Also put a
button on the form that will run the query. The Command Button wizard will
guide you through it under Miscellaneous, Run Query.

Your users open the form, type in an invoice number, press the button, and
here's the answer. You could also have it open a form or report (based on the
querey) instead of the query.

Now if you mean ad hoc queries, that's a LOT more difficult.