Welcome to SPN

Register and Join the most happening forum of Sikh community & intellectuals from around the world.

Sign Up Now!

Switchboard items limit

Discussion in 'Information Technology' started by sgarrington, Nov 10, 2005.

  1. sgarrington

    sgarrington
    Expand Collapse
    Guest

    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?
     
  2. Loading...


  3. Larry Linson

    Larry Linson
    Expand Collapse
    Guest

    "sgarrington" wrote

    > 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?


    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.

    Larry Linson
    Microsoft Access MVP
     

Share This Page