SWITCHBOARD MANAGER

  • Thread starter Thread starter Bob Spence
  • Start date Start date
B

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"
 
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
 
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.
 
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/
__________________________________________
 
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.
 
Bob Spence said:
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"
Click to expand...
 
Back
Top