SWITCHBOARD MANAGER

[Bob Spence]

ACCESS 2007 - I have amended the code for the maximum number of buttons from
8 to 16.
I have copied the buttons and labels and renamed them sequentially using the
naming conventions.
When I am in Switchboard manager I get "Sorry, only 8 items allowed per
switchboard page"

 

[John Spencer]

This may or may not be true in Access 2007, but in earlier versions

Step 1. Open the code window for the form and change the line
Const conNumButtons = 8
to
Const conNumButtons = <The Number You Need>


John Spencer
Access MVP 2002-2005, 2007-2010
The Hilltop Institute
University of Maryland Baltimore County

 

[Victoria]

n

 

[Bob Spence]

Hi John

I have done this as:

Const conNumButtons = 16

I have also compacted and repaired and closed and open Access - all to no
avail.

 

[Tom Wickerath]

Hi Bob,

Switchboard FAQ

1. Q: How do I have more than eight items on the switchboard form?
http://www.accessmvp.com/JConrad/accessjunkie/switchboardfaq.html#eight

This includes the following:

"Compile the code, save and close the form. Now if you use the Switchboard
Manager interface you are still restricted to 8 items. To add more you have
to add the entries manually into the Switchboard Items Table. Shouldn't be
hard to do if you take a few minutes and see how the records are entered. You
can EDIT more than 8 entries from the Wizard, but cannot ADD more than 8."


Personally, I think you will be much happier using an unbound Switchboard
form, perhaps with a tab control.


Tom Wickerath
Microsoft Access MVP
http://www.accessmvp.com/TWickerath/
__________________________________________

 

[jose]

IS NOT THAT GOOD OF A HELP U KNO

 

[Lynn Trapp]

For Access 2007, you actually don't have to go through all that effort to
modify code. Instead, you simply add additional records to the Switchboard
Items table and it will give you the appropriate number of buttons on your
switchboard. Unfortunately, you cannot use the Switchboard manager to get
more than 8 buttons on a switchboard, no matter what you do -- regardless of
the version.

 

[james hall]

ACCESS 2007 - I have amended the code for the maximum number of buttons
from
8 to 16.
I have copied the buttons and labels and renamed them sequentially using
the
naming conventions.
When I am in Switchboard manager I get "Sorry, only 8 items allowed per
switchboard page"