G
Guest
Can anyone tell me if it is possible to increase the number of items on a
Switchboard to more than the default 8??
Switchboard to more than the default 8??
R
Rick B
Sure, but it would involve you going in and doing some major overhaul.
A better solution is to create your own menus to do exactly what you want.
Rick B
A better solution is to create your own menus to do exactly what you want.
Rick B
J
Jeff Conrad
Hi,
Well very soon you'll hopefully be able to download my
Advanced Switchboard Manager Add-In which will take
care of this, as well as a bunch of other new tricks.
In the meantime, here are the steps you need to add more
than 8 items to the Switchboard Form. Please make a backup
copy of your database before proceeding.
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. All
the experts create their own "switchboard-type" forms instead of
using the Switchboard Manager.
(Although they haven't seen mine yet <vbg>)
Well very soon you'll hopefully be able to download my
Advanced Switchboard Manager Add-In which will take
care of this, as well as a bunch of other new tricks.
In the meantime, here are the steps you need to add more
than 8 items to the Switchboard Form. Please make a backup
copy of your database before proceeding.
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. All
the experts create their own "switchboard-type" forms instead of
using the Switchboard Manager.
(Although they haven't seen mine yet <vbg>)