If this is your first visit, be sure to check out the FAQ by clicking the link above. You may have to register before you can post: click the register link above to proceed. To start viewing messages, select the forum that you want to visit from the selection below. |
|
|
Thread Tools | Display Modes |
#1
|
|||
|
|||
# of items on a switchboard on Access 03
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 |
#2
|
|||
|
|||
# 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 |
#3
|
|||
|
|||
# of items on a switchboard on Access 03
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/AlbertKal.../ridesrpt.html -- Albert D. Kallal (Access MVP) Edmonton, Alberta Canada |
Thread Tools | |
Display Modes | |
|
|