Switchboard

  • Thread starter Thread starter Jonathan Smith
  • Start date Start date
J

Jonathan Smith

Is it possible to have more than Eight Items on an Access 2002 Switchboard?

If so, how might one accomplish this?

Thanks for the help.
 
Go into the code of the form.

Somewhere in there is a constant that is set to eight.
Change it to what you need it to be
then add a couple of text boxes under the ones already on the form obseving
any name conventions used in the exsisting boxes

Ie if the current last box is called 'box8' then call your next one 'box9'

sorry i cant be more specific i haven't used the switchboard for ages
I write my own cos u have a lot more control
 
Jonathan Smith said:
Is it possible to have more than Eight Items on an Access 2002 Switchboard?

If so, how might one accomplish this?
Click to expand...

First there is a constant defined (conNumButtons) as 8. You need to change
that to the number of buttons you want. Then the switchboard uses a trick to
simulate a control array. All the buttons and labels are named with names
like:

Option1
Option2
....
Option8

Then the code refers to the buttons with the fake array like:

For intOption = 2 To conNumButtons
Me("Option" & intOption).Visible = False

So you must add all your buttons and labels with the next consecutive
numbers and feed the code those numbers. Like:

=HandleFocus(9)

Be careful, there are lots of transparent buttons that must be accomodated.
It is better to make a few copies of the switchboard form and play around
awhile to get the hang of it. That said, I suggest you find an easier way to
build a menu.
--
Arvin Meyer, MCP, MVP
Microsoft Access
Free Access downloads:
http://www.datastrat.com
http://www.mvps.org/access
 
Back
Top