Changing the number of Switchboard items on a page

  • Thread starter Thread starter David
  • Start date Start date
D

David

The switchboard manager allows only 8 items on a page -
how do I increase this to say 12. I have tried changing
Const conNumButtons = 8 to 12 in the OnOpen event
procedure for the Form but obviously I need to change
something else as well - can you please help?
 
Hi David,
I would suggest making your own switchboard using
an unbound form. You could put as many buttons on it as
you need and aren't constrained by Microsofts idea of what
a switchboard should be. Hope this helps

The Easy Day
 
The switchboard manager allows only 8 items on a page -
how do I increase this to say 12. I have tried changing
Const conNumButtons = 8 to 12 in the OnOpen event
procedure for the Form but obviously I need to change
something else as well - can you please help?
Click to expand...

Adding more buttons can be done, but the Switchboard manager will only
allow you to edit the original 8. That means extra time wasted by you
whenever changes to the extra buttons have to be made.

Either use one of the original 8 buttons to open a second switchboard,
or better yet, make your own switchboard from an unbound form using
command buttons. If you use the command button wizard, Access will
create most of the code for you. You are not limited to the number of
buttons, you control the switchboard's appearance, and maintenance
will be much easier.
 
Hi David,

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.

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, 12 items may be pushing the envelope a bit.
Too many options may confuse and/or alienate your users.
As mentioned elsethread you may also want to consider
creating your own switchboard-type form as well.

Jeff Conrad
Access Junkie
Bend, Oregon
 
Adding more buttons can be done, but the Switchboard manager will only
allow you to edit the original 8. That means extra time wasted by you
whenever changes to the extra buttons have to be made.
Click to expand...

Actually the wizard WILL allow you to edit more than 8 items, you just cannot use the wizard
to ADD more than 8 items.

Jeff Conrad
Access Junkie
Bend, Oregon
 
Thanks Jeff - this worked a treat and saved some time but
I may try the other suggestions later

Thanks again - you've made an amateur very happy!!
David
 
You're welcome, glad to help.

The Switchboard Manager is good for starting out, but for more advanced stuff it really is best to
create your own unbound Switchboard-type form.

Good luck,
Jeff Conrad
Access Junkie
Bend, Oregon
 
Back
Top