Results 1 to 4 of 4
  1. #1
    2 Star Lounger
    Join Date
    Aug 2001
    Location
    Kent, England
    Posts
    108
    Thanks
    0
    Thanked 0 Times in 0 Posts

    Swithboard Items (Access 2000)

    Is there a way of increasing the number of switchboard items to more than 8?

  2. #2
    3 Star Lounger
    Join Date
    Dec 2000
    Location
    Columbus, Ohio, USA
    Posts
    286
    Thanks
    0
    Thanked 0 Times in 0 Posts

    Re: Swithboard Items (Access 2000)

    John: I had the same question some time back and this is the response I received from Microsoft. I never had the chance to try it though, so let us know. HTH.

    If you are curious about how to have more than 8 buttons per switchboard page,
    you can perform the following steps to test:
    I assume that you have a main switchboard form named "switchboard" in your
    database.
    1. Back up the database first.
    2. Open the "switchboard" form in design view.
    3. Add the ninth button named "Option9" and in the "On Click" event property
    sheet input "=HandleButtonClick(9)".
    4. Add the ninth label named "OptionLabel9" and in the "On Click" event
    property sheet input "=HandleButtonClick(9)". Also, set its "caption" property
    to "command9"
    5. Save the changes and then open VBE by press ALT+F11.
    6. Find the underlying VBA module of "switchboard". Its name should be
    "Form_switchboard".
    7. In this module, find the FillOptions() procedure. Then, change the code
    below
    From
    Const conNumButtons = 8
    To
    Const conNumButtons = 9
    8. Compile and save the changes.
    9. Now, you can add the ninth option directly to the "Switchboard Items" table.
    Note: you are still not allowed to new the ninth switchboard item through
    Switchboard Manager.
    For example, if the record of "option 8" is:
    SwitchboardID ItemNumber ItemText
    18 commond 8
    Then, add a new record like below:
    SwitchboardID ItemNumber ItemText
    1 9 commond 9
    Save the changes.
    10. Open Switchboard Manager, you will note the command 9 is in the switchboard
    item list. Then, you can set the operation for the "commond 9" switchboard
    item.

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

    Re: Swithboard Items (Access 2000)

    That method works, but I would be very careful about how many items you put on a switchboard page. Once you get past 8 or 9 tops, it becomes very difficult to find things in the list and it's visually confusing.

    The preferred method is to add switchboard pages to break the selections up in to digestible chunks. So you put the key items in the main switchboard, and you create additional switchboards for the less frequently selected items or to group selections logically. For example, a Reports switchboard to list your reports could be broken up into a reports switchboard that listed *types* of reports, with each type having its own switchboard.
    Charlotte

  4. #4
    2 Star Lounger
    Join Date
    Aug 2001
    Location
    Kent, England
    Posts
    108
    Thanks
    0
    Thanked 0 Times in 0 Posts

    Re: Swithboard Items (Access 2000)

    I have 10 items that sit nicely together & it just BUGS me that I can only get 8 items on a page. I don't think I'll try changing the code behind the switchboard - well not yet anyway

Posting Permissions

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