Switchboard Manager

[Guest]

I want to create a switchboard manager where as well as going into forms and
reports I can go into queries or tables - there doesn't seem to be an option
for this - how do I do it?

Thanks

 

[Guest]

Download

http://www.cardaconsultants.com/en/msaccess.php?lang=en&id=0000000007#album

the album sample db.

It has a switchboard, can't remember the original source, but it is quite
good. The argument controls the action executed (open form, open report, run
code, run macro,...) and you can always add more case statement to suit your
needs but it is definitely a good starting point to build on.

Daniel P

 

[fredg]

I want to create a switchboard manager where as well as going into forms and
reports I can go into queries or tables - there doesn't seem to be an option
for this - how do I do it?

Thanks

There isn't any option to do that directly.
Easiest method is to first create a macro (or use code) to open the
query.
Then you can use the switchboard manager to run the macro (or run the
code). Those 2 options are available using the manager.

Note: You can also modify the code behind the switchboard to allow
opening a query, but you will not be able to modify that option using
the manager.

The best solution would be not to use the built-in switchboard manager
at all, but to create your own switchboard using an unbound from with
command buttons. You will have more control over it's appearance and
functionality, and maintenance will be easier.
Creating your own command buttons (using the command button wizard,
you can open a query directly from the button. The Open Query command
is listed under the wizard's Miscellaneous list of options.