Is there a way to put Action Queries on a switchboard? I know that might be
a bad idea, but I was just wondering.
Do you mean a switchboard created by yourself using an unbound form
with command buttons?
Sure?
Add a command button and set it's click event to something like:
DoCmd.OpenQuery "YourQueryName"
If this is an Action Query, you will be given a warning before the
query runs.
if you do not wish Warnings, then code the event:
DoCmd.SetWarnings False
DoCmd.OpenQuery "YourQueryName"
DoCmd.SetWarnings True
If you mean the switchboard created by using the Access built-in
Switchboard Manager, then
No.. and Yes.
You cannot add any query to the switchboard using the built-in manager
as it is, however, you can create an OpenQuery Macro (or an OpenQuery
Sub in a public Module), and set the manager to Run Macro or Run Code,
and use the name of the Macro/Sub to run it. See the information
about Warnings above.
