Switchboards within a switchboard

  • Thread starter Thread starter Mark909
  • Start date Start date
M

Mark909

Im hoping to create a switchboard whereby there will be a start switchboard
containing 3 buttons with different headings for differing functions.

Upon pressing one of the buttons a new swtichboard will open containing 4 or
5 buttons with headings for different functions. Each button will create a
different type of report containing relevant information.

Is this possible? If so..how?

Also I was wondering if it will be possible to display the switchboard
without having to open access. Will it open up as a GUI on its own but linked
up to Access in some way?

Thanks for any help
 
Upon pressing one of the buttons a new swtichboard will open containing 4 or
5 buttons with headings for different functions. Each button will create a
different type of report containing relevant information.

Is this possible? If so..how?
Click to expand...

Yes. You could use the built in Switchboard Manager
(under Tools/Database Utilities in A2003 or prior). You can set it
up with multiple switchboard forms. Alternatively, you could create
your own forms, with command buttons for switching from one to
the other.
Also I was wondering if it will be possible to display the switchboard
without having to open access. Will it open up as a GUI on its own but linked
up to Access in some way?
Click to expand...

No. Access forms have no existence outside of the application.
 
The simplest way to do what you want is to create an unbound form with the 3
Command Buttons, and use the command button wizard to create the code/macros
(depending on Access version) to open the secondary swithchboard forms, each
of which is a similarly constructed unbound form. I don't recommend using
the "Switchboard Manager" to create switchboard forms -- it is a complex
solution to a simple problem, and from what we see in the newsgroups, causes
more problems than it solves. You can use Tools | Start on the menu to set
the first unbound form as the one that automatically displays when you open
the database (in Access 2003 or earlier); Start Setup is also available in
Access 2007, but in a different place -- in the Ribbon or other Controls --
in the new user interface.

Larry Linson
Microsoft Office Access MVP
 
Back
Top