Why is access limited to eight items per switchboard?

  • Thread starter Thread starter Guest
  • Start date Start date
Can the ammount be changed? If so how.

Access isn't limited (you can have some 750 controls on a Form, not
just 8); but the Switchboard Wizard is.

I'd suggest creating your own Switchboard form, and not using the
switchboard wizard at all. One way is to use a Listbox displaying the
objects that you want the user to be able to open; set its Doubleclick
event to open the selected row. There are lots of ways to do a
switchboard other than the Switchboard Wizard!

John W. Vinson[MVP]
Join the online Access Chats
Tuesday 11am EDT - Thursday 3:30pm EDT
http://community.compuserve.com/msdevapps
 
Hi,

I will be releasing my Advanced Switchboard Manager very
soon which will take care of this as well as the addition of a
whole bunch of extra cool stuff.

In the meantime, follow these steps to add more than 8 items
to the Switchboard Form:

1. You need to create additional command buttons and labels
to match the number of items you want. Easiest way to do
this is to highlight the last command button and label and
select Copy. Then Paste them onto your form to create
additional ones. Now make sure you change the name of the
NEW command button(s) to Option9, Option10, etc. Also
change the name of the NEW labels to OptionLabel9,
OptionLabel10, etc.

2. Now go to the properties area of each new command
button. In the click event, enter the following:
=HandleButtonClick(9), =HandleButtonClick(10), etc. to
match up with your selection. Do exactly the same thing
for the Click event of the labels (unless you turned those
off).

3. Now go to the code behind the Switchboard form. Scroll
down until you come to this line in the FillOptions Sub:
Const conNumButtons = 8
Change that number to 9, 10 or whatever you need.

4. 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.

FWIW, too many options may confuse and/or alienate your users.
You may also want to consider creating your own switchboard-type
form as well when you need more control and complexity.
 

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Similar Threads

SWITCHBOARD MANAGER 7
Access Switchboard error message 1
switchboard problem 4
I've lost my Switchboard ! 3
Switchboard 4
re Switchboard 1
Switchboard Questions 2
2000-2003 to Access 2007 Switchboard 1

Back
Top