Adding Queries to the Switchboard Form

[mds1124]

Access 2007 - How do I add queries to the switchboard form???

Fairly new to Access, but I know this can be done...

Thanks In Advance...

 

[gemma-the-husky]

look in handlebuttonclick event on the switchboard form

this will show the constant values for the command column in the switchboarditems table

1 = goto switchboard page
3 = open form etc

if there is an open query, this will be one of the options
if not, you can easily add code in here to make one

 

[mds1124]

OK...In Access 2007, how do I get to the code behind the Switchboard Form???

Thanks In Advance...

 

[Poppa Smurf]

You will need to create a module to run your query as there is no method to open a query directly from the switchboard.

 

[Galaxiom]

A switchboard is essentially a crippled type of form.
Just make a form with buttons so you can run whatever code you want.

 

[gemma-the-husky]

OK - this is trivial if you have an understanding of whats going on

All this in HandleButtonClick event

add a constannt at the top

Const conCmdOpenQuery = 9

in the case statement, add the following at a suitable point

Case conCmdOpenQuery
DoCmd.OpenQuery rst![Argument]

now, in your switchboard items table, just add options, with command value 9.

-------------
now I suspect the reason MS didint put it there, is because its unusual to want ot open a query directly. If its editable, you lose control of data entry, and it becomes dangerous. But its easy to do, as explained