Query on Switchboard

[conormooney]

I wish to be able to add one of my queries to the switchboard and simply click on a command button and it will run, i did it last year so i know its possible i just cant remember how to do it?

 

[Lol Owen]

Well mate I'm fairly new to Access but I reckon if you drag a button onto your switchboard in design view the command button wizard gives you the options, one of which is Miscellanious. In there is a Run Query option. Follow that and you should be away. Hopefully.

Cheers, Lol

 

[dcx693]

What kind of query is this? A regular select query? Or an action query (like a make-table, delete or append query)?

You can use the DoCmd.OpenQuery method, the DoCmd.RunSQL method or the Currentdb.Execute method depending on what you need.

 

[Pat Hartman]

If there is ever anything you want to do from the switchboard for which there is no separate option, just create a macro.