2003: Switchboard - Need more than 2 menu levels - is this possible?

[marcus101]

I would like a build a multi-level (more than 2) system of menus for Access 2003's switchboard for a database I am working on.

I am using an existing switchboard setup with 4 items on the main switchboard and 7-8 items on the second level.

However, I'd like to be able to add more layers, though I don't think that is directly possible via the Switchboard Manager, as it doesn't allow me to go beyond that.

It just terminates at level 2, only allowing commands to be added at that level/layer.

Here is what I have in my current database:

Main Menu
Item A
Item B
Item C

Clicking on Item A gives me 7 Items
Item A1
Item A2
Item A3
Item A4
Item A5
Item A6
Item A7

Here is what I would LIKE to do - rather than just have items that lead to a command (like open a form or run a report), I'd like to have ANOTHER SWITCHBOARD PAGE LEVEL at this level (ie: a menu within a menu within a menu).

I'm guessing this is NOT doable within the switchboard manager but MIGHT be doable using VBA code.

*IS* this possible? And if so, how involved would the code be to create this functionality?

Right now, Access only seems to allow 2 switchboard menu layers, the main one and one level down. I'd like to have 4 or perhaps maybe 5 layers/levels.

Any outline thoughts/ideas/suggestions on how I might start doing this? Or is this too complex and time-consuming to try unless absolutely necessary?

Thanks,


marcus101
Access/SQL/XML Developer
Ottawa, Canada

 

[MajP]

I might be missing something here, but I think you can do it with switchboards. People who know vba often "poo-poo" the switchboard, but I will often prototype in it first, and it is pretty robust. So here is four level down with an "X" by the selection. Does this organization meet your needs?:

Page 1 Main Menu (Level 1)
X Administrator Menu
User Menu

Page 2 Administrator Menu (Level 2)
Admin Utilities
X Admin Forms
Admin Reports
Return to Main Menu

Page 3 Admin Forms (Level 3)
X Personnel Forms
Program Forms
return to Administrator Menu

Page 4 Personnel Forms (Level 4)
Personnel Data
Travel Form
.
.
X return to Admin Forms