only 8 Items in switchboard

  • Thread starter Thread starter Guest
  • Start date Start date
G

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?
 
kuki_monster said:
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?
Click to expand...


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.
 
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.
 
Joan Wild said:
You can make one of those 8 a link to another page of the switchboard.
Click to expand...
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.
 
Keith said:
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.
Click to expand...


Sure you can, but it's still a complicated implementation of something
rather simple. Go with an unbound form.
 
Thanks to all who responded - I took both Fred's and Karl's advice and the
combinaton proved successful!!!!!
 
Back
Top