# of items on a switchboard on Access 03

  • Thread starter Thread starter Norm
  • Start date Start date
N

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