Switchboard and Queries

  • Thread starter Thread starter AAK
  • Start date Start date
A

AAK

I would like to set up a switchboard that gives access to several
queries that require the end use to input data to run the query. For
example, find a person in the database by entering first name and last
name in a query. Is there a way to do this from Switchboard? I would
like to limit end user access to the Switchboard so that end users do
not actually have access to the full functionality of Access and the
databases, but do have the ability to run the queries. Thank you in
advance for any assistance you can provide.
 
Would you consider creating a search form for this purpose?

That means you can let the user search on a combination of various fields,
and show results (since some searches will yield more than one match.)

If that sounds useful, download the example database here:
Search form - Handle many optional criteria
at:
http://allenbrowne.com/ser-62.html
It does involve some VBA code to create the filter string, but you can copy
the example if you have some understanding of what's going on.
 
Would you consider creating a search form for this purpose?

That means you can let the user search on a combination of various fields,
and show results (since some searches will yield more than one match.)

If that sounds useful, download the example database here:
    Search form - Handle many optional criteria
at:
   http://allenbrowne.com/ser-62.html
It does involve some VBA code to create the filter string, but you can copy
the example if you have some understanding of what's going on.
Click to expand...

This actually might provide greater flexibility for the end user than
I had envisioned. I'll give it a try and see how things turn out.
Allen, really appreciate your suggestion. Thank You.
 
Back
Top