View Single Post
  #2  
Old March 17th, 2009, 07:55 PM posted to microsoft.public.access.forms
fredg
external usenet poster
 
Posts: 4,386
Default # of items on a switchboard on Access 03

On Tue, 17 Mar 2009 11:42:06 -0700, Norm wrote:

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.

--
Fred
Please respond only to this newsgroup.
I do not reply to personal e-mail