How do I change the switchboard item limit to be greater than 8?

[Guest]

When using the Switchboard Manager under Tools/Database Utilities... the
limit is 8 menu items. I tried changing the constant from 8 to 9, modified
the records in the Switchboard table, and added a new label and option button
& set the event handler in the Switchboard form but it didnt' work.

I assume the limit of 8 is an option setting some place but I can't find it
and the Help does not seem to address this limitation.

Appreciate your help.
Ray

 

[Guest]

You need to create an additional switchboard or maybe switchboards if you
need more than 8 options. One of the options would be to go to a different
switchboard. Yeah, you can edit the switchboard code but it's not
recommended. Personally, I don't use the Switchboard Manager. I use standard
unbound forms to run my navigation. A standard command button works just as
well as the option buttons...but has more possibilities.

 

[Jeff Conrad]

Hi Ray,

Yes, you can add more labels and command buttons to the Switchboard
form itself to have more than 8 items. However, the wizard itself will
prevent you from *adding* more than 8 items. You can add more items
by opening the "Switchboard Items" table and entering them manually.
If you study the records for a little bit you will see how they are set up.
The wizard will actually let you *edit* more than 8 so once you create
some new entries through the table you can then use the wizard to edit
them.

Don't forget that you can create additional menus with the SBM.
You can then have your users navigate to other menus with
items grouped together that are similar.

The wizard code could be changed to allow more than 8 since it is
really only a few lines of code (trust me, I know this). However,
MS only released "un-locked" wizard code modules for Access 97
so you would have a LOT of work ahead of you to make this work
for later versions.

Now for the good news. I've already done all the work.

I've made an Advanced Switchboard Manager Add-in for Access.
My AdvSBM will allow more than 8 items and also includes a bunch
of new cool things he...he...he... It also is compatible with Access
97, 2000, 2002, and 2003. Version 1.0 is already finished, but
not quite ready for deployment. Access MVP Sco graciously went over
this thing with an incredibly fine-tooth comb to test everything. He
offered some suggestions for "tweaking" it just a bit and even something
else I could incorporate into the add-in. So I am busy making the
changes we have discussed and then will release the final product
hopefully in the near future. Yes, bad news, you'll have to wait
just a bit.

BTW, don't even bother asking Sco what I've added; he has been
sworn to secrecy! <g>

 

[Guest]

hi.
I agree with rowiga. I don't use switchboards either. an
unbound forms with buttons (or ever lables using the
doubleclick event) are much more flexable.