# of items on a switchboard on Access 03

[Norm]

How many forms, queries, &/or reports can a switchboard hold? For example I
need to have about 15 reports on the switchboard, is this possible.

Thank you

 

[fredg]

How many forms, queries, &/or reports can a switchboard hold? For example I
need to have about 15 reports on the switchboard, is this possible.

Thank you

Whose switchboard?
The built-in on created by the Switchboard Manager?

The Switchboard manger can only support 8 buttons on a Switchboard
page. You can use one of the buttons to open another switchboard page,
and have many pages, but each page is limited to 8 buttons. You can
increase that number by manually adding buttons, but you will then
have to also adapt the code needed as well as manually entering the
necessary items into the Switchboard Items table. The Switchboard
Manager won't do that for you nor can you use the Manager to Edit the
added switchboard items in the future..

A better solution is to create your own switchboard using an unbound
form. You can then add as many command buttons as you wish. If you use
the command button wizard when adding the buttons, Access will write
much of the code for you.

 

[Albert D. Kallal]

I would simply build your own form.

For reports, I often use a listbox..and then you can add a lot more then 15
in it...

here is some screen shots and ideas of how I deal with reports.:

http://www.members.shaw.ca/AlbertKallal/ridesrpt/ridesrpt.html