Access Switch Board more than 8 selections

[Guest]

How do I get the Switchboard to allow more than 8 entries? I thought I had it
figured out but I must have missed something.

 

[Guest]

See below someone else's request -- my post -- Larry Linson Microsoft Access
MVP rebuttal.

:

Is it possible to change the limit on the number of items allowed on any
switchboard. The limit I have come across is 8 and I need about a dozen items
on one. If it is possible, how do I do that?
----------------------------------------------
My post -----

First backup the database as I once while messing with the code under the
switchboard hosed it so it could not be opened.

Next open the switchboard in design view.

Copy and paste the command buttons and labels. The bottom one is named
Option8 and OptionLabel8. When you paste them they will have a different
series of names like Command28 and Lavel24. Rename them following the
original naming convention.

Edit the On Click property from =HandleButtonClick(8) to the next
consecutive as =HandleButtonClick(9) for both the command button and label.

Next on the menu click on VIEW – Code. Scroll down to find –
Private Sub FillOptions()
' Fill in the options for this switchboard page.
' The number of buttons on the form.
Const conNumButtons = 8
Change the 8 to the maximum number of buttons.

Save and close the Visual Basic Editor.

Compact and repair. Close. Open add to the Switchboard table. Test.

Good luck.

----------------------------------------------------------------------
Larry Linson
Microsoft Access MVP

The only limit on number of selections on a Switchboard is that imposed by
the Switchboard Manager. I don't use the Switchboard Manager, because I
consider it a complex solution to a simple problem... with a table and (not
well documented) limits and quirks.

I note that Karl gave you a solution that involved manual modification of
the output of the Switchboard Manager, an approach that I definitely do not
recommend. Unless you are knowledgeable about the internals and operation of
the Switchboard Manager, your changes are likely to be lost, or broken, if
you again use the Switchboard Manager attempting to maintain your Switchboard
(perhaps not even the same Form that you modified).

I'd suggest you use an unbound Form, and add the Command Buttons you need to
open the Forms for each "feature" you include in your switchboard... assuming
you already have those Forms defined, the Command Button Wizard will lead you
through defining them. If, as is sometimes the case, you need to limit the
Records to be displayed on a Form or Report you are opening, you can add that
functionality with just a little knowledge of VBA.

 

[fredg]

How do I get the Switchboard to allow more than 8 entries? I thought I had it
figured out but I must have missed something.

It's been said in these newsgroups that the built-in switchboard is a
complex solution to a simple problem.

It is possible to add more buttons, however none of the extra buttons
are editable using the Switchboard manager. Any changes must be done
manually in the Switchboard Items table.

A better solution would be to make one of the 8 buttons open a second
switchboard page, and one on the second page to return to the first.
This you can do using the manager.

The best solution would be to create your own switchboard using
unbound form with command buttons. You can then have as many buttons
as you want, you will have more control over what the switchboard
appearance and what it will do, and maintenance will be much easier.

If you still insist upon adding more buttons to your current
switchboard, post back and I'll reply with the 'how to'.