A Microsoft Office (Excel, Word) forum. OfficeFrustration

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.

Go Back   Home » OfficeFrustration forum » Microsoft Access » Using Forms
Site Map Home Register Authors List Search Today's Posts Mark Forums Read  

# of items on a switchboard on Access 03



 
 
Thread Tools Display Modes
  #1  
Old March 17th, 2009, 07:42 PM posted to microsoft.public.access.forms
Norm
external usenet poster
 
Posts: 149
Default # 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  
Old March 17th, 2009, 08: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
  #3  
Old March 19th, 2009, 02:51 AM posted to microsoft.public.access.forms
Albert D. Kallal
external usenet poster
 
Posts: 2,874
Default # 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

Posting Rules
You may not post new threads
You may not post replies
You may not post attachments
You may not edit your posts

vB code is On
Smilies are On
[IMG] code is Off
HTML code is Off
Forum Jump


All times are GMT +1. The time now is 11:44 AM.


Powered by vBulletin® Version 3.6.4
Copyright ©2000 - 2024, Jelsoft Enterprises Ltd.
Copyright ©2004-2024 OfficeFrustration.
The comments are property of their posters.