Access template and Switchboard

  • Thread starter Thread starter John B
  • Start date Start date
J

John B

Hello to everybody,
I am creating a new database using the template supplied with Access 97.

How may I edit more the 8 items per switchboard page. If possible I need
something like 13 items per page.

Many thanks for your help.
Regards
John
 
It is possible to modify the Access default Switchboard form to add
more buttons, but this modification is not supported by the Wizard, so
you end up having to add and modify switchboard pages by manually
adding records to the Table that controls them. It is probably not
worth the effort unless you just have one or two pages that need extra
items. If you really need more than the 8 standard choices for
multiple pages, you are probably better advised to create your own
switchboard Forms from scratch.


Hello to everybody,
I am creating a new database using the template supplied with Access 97.

How may I edit more the 8 items per switchboard page. If possible I need
something like 13 items per page.

Many thanks for your help.
Regards
John
Click to expand...


Please respond to the Newsgroup, so that others may benefit from the exchange.
Peter R. Fletcher
 
[cut..]
It is possible to modify the Access default Switchboard form to add
more buttons, but this modification is not supported by the Wizard, so
you end up having to add and modify switchboard pages by manually
adding records to the Table that controls them. It is probably not
worth the effort unless you just have one or two pages that need extra
items. If you really need more than the 8 standard choices for
multiple pages, you are probably better advised to create your own
switchboard Forms from scratch.
Click to expand...


Thanks for your suggestions
John
 
Hi,

Follow these steps to add more than 8 items to the
Switchboard Form:

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

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.

4. 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.
 
Hello to everybody,
I am creating a new database using the template supplied with Access 97.

How may I edit more the 8 items per switchboard page. If possible I need
something like 13 items per page.

Many thanks for your help.
Regards
John
Click to expand...

The simplest method are:
1) Use one of the 8 buttons to open a second switchboard.
Use one of the 8 buttons on the second switchboard to return to the
first (or open a third) switchboard.
This can be done easily using the built-in Switchboard manager add-in.

2) Create you're own unbound form using command buttons to navigate
your database. If you use the Command button wizard to create the
buttons, Access will do most of the work for you. Add as many command
buttons as you need. This is what most professionals do.

Adding more buttons to the existing switchboard can be done, but it's
not supported by the switchboard manager.
It's just not worth the effort.
 
Back
Top