Switchboard and Queries

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.

--
Allen Browne - Microsoft MVP. Perth, Western Australia
Tips for Access users - http://allenbrowne.com/tips.html
Reply to group, rather than allenbrowne at mvps dot org.

"AAK" <akermisch.RemoveThis@gmail.com> wrote in message
news:f4a754e1-a21d-467f-a9b2-ccb8a319a1bd@r15g2000prh.googlegroups.com...
>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.