Ms Access limitation?

D

Douglas J. Steele

Write your own Switchboard.

If you really want to continue using the existing one, Jeff Conrad offers
the following advice at
http://home.bendbroadband.com/conradsystems/accessjunkie/switchboardfaq.html

Q: How do I have more than eight items on the switchboard form?

A: Make a backup of your database before beginning. You need to create
additional 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 additional 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.

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).

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.

Compile the code, save and close the form. 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 minutes and see how the records are entered.
You can EDIT more than 8 entries from the Wizard, but cannot ADD more than
8.
 

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Top