Tek-Tips is the largest IT community on the Internet today!

Members share and learn making Tek-Tips Forums the best source of peer-reviewed technical information on the Internet!

  • Congratulations IamaSherpa on being selected by the Tek-Tips community for having the most helpful posts in the forums last week. Way to Go!

Linking Switchboard to a Query

Status
Not open for further replies.
Jul 17, 2001
19
US
I was wondering if anyone knew how to link a switchboard command to a query. I clicked on "tools", then "add-Ins" and clicked "switchboard manager". it lets me assign commands but it doesnt have queries on the list. i want the button on the switchboard to take me to a query in design view. if anyone could help i would greatly appreciate it. Thanks.
 
can you launch a macro from switch board?

If so make a macro that opens the query then open the macro with the switch board thingy.

;-) DougP, MCP

Visit my WEB site to see how Bar-codes can help you be more productive
 
I ran into this problem too, all I did was add a little code into the switchboard form, like this:

In the procedure that runs when you click a button on your switchboard, you will find the code where it does a Select Case on rst![command], this is where it decides if you wan't to open a form, a report, run a macro etc.

Now, at the end of the preset actions, insert this:

Case 9
Docmd.openquery rst![argument]

Now if you look at the Switchboard Items table, you will see a command field, this is a number from 0 to 8, if you change a record to 9, that signifies a query.

The main problem is you still can't use the built in editor for inserting query items on your switchboard.

HTH

Andrew.
 
Status
Not open for further replies.

Part and Inventory Search

Sponsor

Back
Top