Exporting to Excel from Switchboard (Switchboard Manager)

[Jeff H]

I have created a switchboard for a transportation disbursal database using
the switchboard manager (Access 2003). In the database I have various
crosstab queries that I need to export out to Excel to build YTD spreadsheets
that I email to my supervisor (and others). In the switchboard manager, I see
two choices either Run Macro or Run Code. Which is the better option to use
to export to Excel?

Below is what I envisioning as the buttons on the switchboards

Button 1: Export YTD for all Partners (Queries: YTD Cost, YTD Count, YTD
Clients)
Button 2: Export YTD for Partner 1 (Queries: Partner 1 Cost, Partner 1
Count, Partner 1 Clients)
Button 3: Export YTD for Partner 2 (Queries: Partner 2 Cost, Partner 2
Count, Partner 2 Clients)
Button 4: Export YTD for Partner 3 (Queries: Partner 3 Cost, Partner 3
Count, Partner 3 Clients)
Button 5: Export YTD for Partner 4 (Queries: Partner 4 Cost, Partner 4
Count, Partner 4 Clients)
Button 6: Export YTD for Partner 5 (Queries: Partner 5 Cost, Partner 5
Count, Partner 5 Clients)

I am trying to set up the switchboard so that if I am not here all anyone
has to do is click the appropriate button and the queries are exported to
Excel. In other, I need a simple one-step, one-click, dummy-proof way. I
really don't want to have to spend time writing step-by-step procedure manual
for people who aren't familar with Access.

THANKS!

 

[Mike Painter]

I have created a switchboard for a transportation disbursal database
using the switchboard manager (Access 2003). In the database I have
various crosstab queries that I need to export out to Excel to build
YTD spreadsheets that I email to my supervisor (and others). In the
switchboard manager, I see two choices either Run Macro or Run Code.
Which is the better option to use to export to Excel?

I don't bother with the switchboard but build my own menus with buttons on a
form.

In general code will always be better becasue you can intercept errors and
do more with those errors.