Switchboard 1) 8 items max 2) Can you call a Query

[Joe]

It appears that there is a limit of 8 Items max. in the switchboard.

I would like to call a Query so I could export the table to Excel using the
switchboard.

 

[Klatuu]

Yes, the limit is 8, but you can use an option to open another switchboard
page, which has another 8 options, which then could each open another
switchboard page, which... oh well, I think you get the idea.
BTW, you do this with the Switchboard manager.

 

[Joe]

I do this but I have 3 switchboard screens for reports. I of the 8 has to be
return to previous screen and 1 for "additional reports" so that only leave 6
lines left.

I do not see an option to run a query from the switchboard. I only want to
see the table the query produces so I can export it to excel.

 

[Klatuu]

Opening a query and exporting to Excel are two different operations and would
take two different buttons. In either case, you can run a macro from a
switchboard, so you can create macros to do what you want and run the macros
from the switchboard.

 

[Joe]

I do not need to export to excel automatically just run a query and see the
table. Can that be done from the switchboard without a macro?
Thank you for all of your time.

 

[Klatuu]

No, you need to have a macro.
How do you intent to get the data into Excel?
(please don't tell me you are going to cut and paste)

 

[Joe]

Export it from the file menu.

No, you need to have a macro.
How do you intent to get the data into Excel?
(please don't tell me you are going to cut and paste)

 

[Klatuu]

Okay. That will work.