Home | Contact Us | FAQ | Search & Site Map | Link to Us
Sign In | Join | Other 45 Sites in Network
Home
Discussion GroupsFormsForms ProgrammingQueriesModules / DAO / VBAReports / PrintingMacrosDatabase DesignSecurityConversionImporting / LinkingSQL Server / ADPMultiuser / NetworkingReplicationSetup / ConfigurationDeveloper ToolkitsActiveX ControlsNew UsersGeneral 1General 2
Access DirectoryToolsTutorialsUser Groups
Related Topics
SQL ServerOther DB ProductsMS OfficeMore Topics ...

MS Access Forum / Developer Toolkits / June 2003

Tip: Looking for answers? Try searching our database.

Switchboard replacement

Thread view: 
Enable EMail Alerts  Start New Thread
Thread rating: 
Sigurd - 30 Jun 2003 10:06 GMT
I need a replacement for Switchboard as this is difficult to follow with all
choices in my ongoing project.

Thanks!
Sigurd
John Vinson - 30 Jun 2003 18:09 GMT
>I need a replacement for Switchboard as this is difficult to follow with all
>choices in my ongoing project.
>
>Thanks!
>Sigurd

Note that the Microsoft switchboard allows you do "nest" switchboards
- your main switchboard could simply have a list of the toplevel
choices, and the user could "drill down" to the actual desired action.
You don't need to have all the choices onscreen at once!

An alternative technique that I use routinely is to "roll my own"
switchboard. It is a form based on a table named Switchboard; this
table has fields for Category (integer), ObjectName, ObjectType,
UserLabel, and Action (defaulting to Open).

On the Form is an Option Group allowing the user to select a Category,
and a Listbox based on a query showing all the UserLabel entries for
the selected category.

In the Listbox's DoubleClick event, there's code to perform the
selected Action on the selected ObjectName - i.e. if the Action is
Open, the ObjectType is acForm (I use the builtin constants), and the
ObjectName is "MyForm" the code opens that form.

                 John W. Vinson[MVP]    
   Come for live chats every Tuesday and Thursday
http://go.compuserve.com/msdevapps?loc=us&access=public
 
Sign In
Join
My Latest Posts
My Monitored Threads
My Blog
My Photo Gallery
My Profile
My Homepage

Start New Thread
Enable EMail Alerts
Rate this Thread



©2008 Advenet LLC   Privacy Policy - Terms of Use
This website includes both content owned or controlled by Advenet as well as content owned or controlled by third parties.