Switchboard Limitations

[ITProg]

Is there a way to work around the 8 item limitation on a switchboard? I have broken my menus down as much as I can, but I still need to get 10 items on one switchboard.

 

[drctx]

first ***make a backup of the database first or atleast copies of the original switchboard form and table

in the FillOptions() vba code change the conNumButtons variable to 10
' The number of buttons on the form.
Const conNumButtons = 10

copy the command button and label
name the label: OptionLabel9
name the command button: Option9
add to the onclick event for both: =HandleButtonClick(9)

name the label: OptionLabel10
name the command button: Option10
add to the onclick event for both: =HandleButtonClick(10)

 

[MichaelRed]

The limitation is just a programmed value in the Ms. generated form. You can just as easily look at the design of the form and create your own either as a simple variation a-la drctx 's or just understand the concept and roll your own from scratch. I often just use a combo box listing the options available according to the users (security) group. I maintain a simple table of all available forms (or reports) along w/ the security group(s) authourized and fill the combo box with the items from the table where the users' (security) group matches the objects' (security) group.





MichaelRed

 

[ITProg]

I followed drctx's directions, but still receive the error message that I am limited to 8 items. Is there another variable I need to change?

 

[PHV]

Have you tried to step the code to discover where the lilitation is coming from ?

Hope This Helps, PH.
Want to get great answers to your Tek-Tips questions? Have a look at FAQ219-2884 or FAQ222-2244

 

[psemianonymous]

There are three good solutions for this:

1. Use submenus. If you still can't fit, make more submenus. The main switchboard is thus filled with a bunch of links (precisely 8), which may link to further submenus, or may be populated with 'regular' switchboards. This is fine and acceptable.

2. Stop using the switchboard and start making your own menus. If you're doing a complicated enough application, you're going to need to do this eventually anyway (trust me, you will).

3. Go fancy and build your own Windows-style menus, e.g. your own 'File' menu, your own 'Help' menu, etc.