Results 1 to 9 of 9
  1. #1
    5 Star Lounger
    Join Date
    Jan 2001
    Location
    Jacksonville,NC, USA
    Posts
    705
    Thanks
    0
    Thanked 0 Times in 0 Posts

    Switchboard Limit? (Access 2000)

    Curious? is there a limit to how many items you can add to the main switchboard in Access?
    NMPadgett
    I'm thinking there isn't a limit. Hit me back if any one has heard of one.
    Thank you
    NMP <img src=/S/cool.gif border=0 alt=cool width=15 height=15>

    If you can't convince them, confuse them. - Harry Truman <img src=/S/scratch.gif border=0 alt=scratch width=25 height=29>

  2. #2
    Plutonium Lounger
    Join Date
    Dec 2000
    Location
    Sacramento, California, USA
    Posts
    16,775
    Thanks
    0
    Thanked 1 Time in 1 Post

    Re: Switchboard Limit? (Access 2000)

    There is a constant in the code behind the switchboard that limits it to 8 items. Look in the FillIOptions() sub for this:

    <pre> ' The number of buttons on the form.
    Const conNumButtons = 8</pre>

    Charlotte

  3. #3
    Super Moderator
    Join Date
    Aug 2001
    Location
    Evergreen, CO, USA
    Posts
    6,496
    Thanks
    3
    Thanked 42 Times in 42 Posts

    Re: Switchboard Limit? (Access 2000)

    As Charlotte indicates, the limit is 8 - in point of fact no individual menu can contain more than 8. It can be changed by adjusting the size of the form and modifying the constant (and a couple of other things as I remember from a few years ago), but the code that you use to edit the switchboard menu won't work in those cases, and you have to build and edit the SwitchBoard table by hand. If you want more details, I can try to dredge them up.
    Wendell

  4. #4
    Star Lounger
    Join Date
    Aug 2001
    Location
    Cleveland, Ohio, Ohio, USA
    Posts
    76
    Thanks
    0
    Thanked 0 Times in 0 Posts

    Re: Switchboard Limit? (Access 2000)

    Good morning Wendell,
    Is there a definitive reason that one should use the SwitchBoard Mgr. rather than create their own form as a "SwitchBoard". I have built "SwitchBoards" with 30+ buttons which seem to work fine.

    Jim

  5. #5
    Super Moderator
    Join Date
    Aug 2001
    Location
    Evergreen, CO, USA
    Posts
    6,496
    Thanks
    3
    Thanked 42 Times in 42 Posts

    Re: Switchboard Limit? (Access 2000)

    Well, the nice thing about the Switchboard is that it let's you tier menu's, which presumably makes it a more friendly, logical interface. There are certainly other ways of doing the same thing, although 30+ buttons can get pretty confusing to a novice user. In fact, we have recently adopted a task-bar approach to some of our more complex systems, and users seem to like it.
    Wendell

  6. #6
    2 Star Lounger
    Join Date
    Jan 2001
    Location
    Goose Creek, South Carolina, USA
    Posts
    108
    Thanks
    3
    Thanked 0 Times in 0 Posts

    Re: Switchboard Limit? (Access 2000)

    Wendell:

    Would you care to elaborate any on your "Taskbar" approach to providing menus for an app?

    I have also avoided the "Switchboard" in past applications (mainly due to not really understanding its approach) in favor of forms and tabbed forms to avoid "button overload" for novice users.

    Having said this, I find that Susan Novalis' Access 2000 VBA Handbook makes an intriguing case for the switchboards as single forms with different characteristics depending on function.

    I'm one of those people who have been "doing the job" for several years using necessary vba coding and some probably shameful workarounds but producing useful apps that work and don't break. Now that I'm officially a senior citizen I'm getting back to learning some of the basics now.

    Have really appreciated this forum for the last several years.

  7. #7
    Super Moderator
    Join Date
    Aug 2001
    Location
    Evergreen, CO, USA
    Posts
    6,496
    Thanks
    3
    Thanked 42 Times in 42 Posts

    Re: Switchboard Limit? (Access 2000)

    Hi Dick,
    I appreciate that senior citizen business - having retired (so to speak) 13 years ago. The taskbar approach I referred to works something like Outlook, in that you have a set of menu items that are displayed on the left-hand side of the screen, and they can be nested to handle multiple sub-options. Take a look at this screen shot to see what I mean. The disadvantage of the taksbar is that it takes up a fair bit of real estate on the screen. The advantage of this and the switchboard approach is that you have a single form that handles several levels of menu nesting and the opening of forms and reports, and can be revised and updated without making design changes in forms.
    Wendell

  8. #8
    2 Star Lounger
    Join Date
    Jan 2001
    Location
    Goose Creek, South Carolina, USA
    Posts
    108
    Thanks
    3
    Thanked 0 Times in 0 Posts

    Re: Switchboard Limit? (Access 2000)

    That's interesting, Wendell. Went to your site and looked at AccessUI to get a better view.

    Thanks,

  9. #9
    5 Star Lounger
    Join Date
    Jan 2001
    Location
    Jacksonville,NC, USA
    Posts
    705
    Thanks
    0
    Thanked 0 Times in 0 Posts

    Re: Switchboard Limit? (Access 2000)

    Very interesting stuff. Thank you Wendell for all the extra information. I too have been creating my own switchboard from scratch for years, and to me it just seems to work better, but the question was for a former student who emailed me about the 8 limit. Always learning something new in here. Thats why I love it. I salute you.
    NMPadgett
    NMP <img src=/S/cool.gif border=0 alt=cool width=15 height=15>

    If you can't convince them, confuse them. - Harry Truman <img src=/S/scratch.gif border=0 alt=scratch width=25 height=29>

Posting Permissions

  • You may not post new threads
  • You may not post replies
  • You may not post attachments
  • You may not edit your posts
  •