Possible to get more than 8 Switchboard items?

  • Thread starter Thread starter LarryP
  • Start date Start date
L

LarryP

I've seen a hack for Access 2000 where you change some VB
[event Procedure] lines but the code seems different in
2002.

PS I'm not a fluent VB programmer, and not even a
programmer at all, so ...

Thanks!
 
Hi,

Follow these steps to add more than 8 items to the
Switchboard Form. I'm assuming you're using the built-in
Access Switchboard Manager feature.

1. You need to create additonal command buttons and labels
to match the number of items you want. Easiest way to do
this is to highlight the last command button and label and
select Copy. Then Paste them onto your form to create
additonal ones. Now make sure you change the name of the
NEW command button(s) to Option9, Option10, etc. Also
change the name of the NEW labels to OptionLabel9,
OptionLabel10, etc.

2. Now go to the properties area of each new command
button. In the click event, enter the following:
=HandleButtonClick(9), =HandleButtonClick(10), etc. to
match up with your selection. Do exactly the same thing
for the Click event of the labels (unless you turned those
off).

3. Now go to the code behind the Switchboard form. Scroll
down until you come to this line in the FillOptions Sub:
Const conNumButtons = 8
Change that number to 9, 10 or whatever you need.

Now if you use the Switchboard Manager interface you are
still restricted to 8 items. To add more you have to add
the entries manually into the Switchboard Items TABLE.
Shouldn't be hard to do if you take a few mintues and see
how the records are entered. You can EDIT more than 8
entries from the Wizard, but cannot ADD more than 8.

I think I got everything. Let me know if I missed
something.

Hope that helps,
Jeff Conrad
Bend, Oregon
 
You're very welcome Larry, glad to help.
Come back any time.

Jeff Conrad
Bend, Oregon
 
Back
Top