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

Thread view:

Enable EMail Alerts

Start New Thread

Thread rating:

Joe - 10 Jan 2008 19:47 GMT

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.

Reply to this Message

Klatuu - 10 Jan 2008 20:02 GMT

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.

Signature

Dave Hargis, Microsoft Access MVP

> 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.

Reply to this Message

Joe - 10 Jan 2008 20:30 GMT

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.

> 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
[quoted text clipped - 5 lines]
> > I would like to call a Query so I could export the table to Excel using the
> > switchboard.

Reply to this Message

Klatuu - 10 Jan 2008 20:44 GMT

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.

Signature

Dave Hargis, Microsoft Access MVP

> 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
[quoted text clipped - 12 lines]
> > > I would like to call a Query so I could export the table to Excel using the
> > > switchboard.

Reply to this Message

Joe - 10 Jan 2008 20:59 GMT

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.

> 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
[quoted text clipped - 17 lines]
> > > > I would like to call a Query so I could export the table to Excel using the
> > > > switchboard.

Reply to this Message

Klatuu - 10 Jan 2008 21:03 GMT

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)

Signature

Dave Hargis, Microsoft Access MVP

> 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?
[quoted text clipped - 21 lines]
> > > > > I would like to call a Query so I could export the table to Excel using the
> > > > > switchboard.

Reply to this Message

Joe - 10 Jan 2008 21:34 GMT

Export it from the file menu.

> No, you need to have a macro.
> How do you intent to get the data into Excel?
[quoted text clipped - 25 lines]
> > > > > > I would like to call a Query so I could export the table to Excel using the
> > > > > > switchboard.

Reply to this Message

Klatuu - 10 Jan 2008 21:40 GMT

Okay. That will work.

Signature

Dave Hargis, Microsoft Access MVP

> Export it from the file menu.
>
[quoted text clipped - 27 lines]
> > > > > > > I would like to call a Query so I could export the table to Excel using the
> > > > > > > switchboard.

Reply to this Message