only 8 Items in switchboard

[Guest]

I am back in the jurrassic using access 97....Im trying to add items to my
switchboard for a particular page that displays the months of the year. I
keep getting an error message saying that only 8 items are allowed in the
switchboard page. How can I add more?

 

[Joan Wild]

I am back in the jurrassic using access 97....Im trying to add items to my
switchboard for a particular page that displays the months of the year. I
keep getting an error message saying that only 8 items are allowed in the
switchboard page. How can I add more?

You can make one of those 8 a link to another page of the switchboard. Or
you can forget the switchboard manager altogether. It's easier and gives
you more flexibility to just create an unbound form of your own. You can
put all the buttons/controls on it that you like.

 

[Guest]

First make a copy of the switchboard just in case things go wrong.

Open switchboard in design view. Click on View - Code.
Go down to ---
Private Sub FillOptions()
' Fill in the options for this switchboard page.

' The number of buttons on the form.
Const conNumButtons = 8

Change the 8 to new value - 10 or 12. Save. Close code screens.

View properties. Click on OptionLabel8, copy, paste and position for as
many as you are adding. Edit the captions of the copies - both Option button
and label.

Edit the OnClick of each new button to match --
=HandleButtonClick(9)
=HandleButtonClick(10)
etc.

 

[Keith]

You can make one of those 8 a link to another page of the switchboard.

You can also fool Access into giving you more than 8 items per "page" by
tweaking one of the hidden/system tables but I wouldn't recommend it to the
OP unless they are an experienced user.

 

[Fred Boer]

Creating your own switchboard form (as suggested by Joan) is good advice;
however, if you would like to stay with what you are familiar with, you can
find useful information here, including instructions on increasing the
number of items:

http://home.bendbroadband.com/conradsystems/accessjunkie/switchboardfaq.html

Good Luck!
Fred Boer

 

[Joan Wild]

You can also fool Access into giving you more than 8 items per "page" by
tweaking one of the hidden/system tables but I wouldn't recommend it to
the OP unless they are an experienced user.

Sure you can, but it's still a complicated implementation of something
rather simple. Go with an unbound form.

 

[Guest]

Thanks to all who responded - I took both Fred's and Karl's advice and the
combinaton proved successful!!!!!