• Swithboard Items (Access 2000)

    Author
    Topic
    #360807

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

    Viewing 0 reply threads
    Author
    Replies
    • #544124

      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.

      • #544145

        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.

        • #544155

          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

    Viewing 0 reply threads
    Reply To: Swithboard Items (Access 2000)

    You can use BBCodes to format your content.
    Your account can't use all available BBCodes, they will be stripped before saving.

    Your information: