what is a switchboard manager/about switchboard in MS Access

[Guest]

What does a switchboard(MS Access) do? What is it used for?

 

[Alex White MCDBA MCSE]

Hi,

rudimentary menu system, that is dynamically created from a menu table.

 

[Lynn Trapp]

It is designed to create a user friendly menu-type screen for an Access
application. It can be very helpful, but has quite a few limitations that
cause most professional developers to opt for creating their own menu
screens.

--
Lynn Trapp
MS Access MVP
www.ltcomputerdesigns.com
Access Security: www.ltcomputerdesigns.com/Security.htm
Jeff Conrad's Big List: www.ltcomputerdesigns.com/JCReferences.html

 

[Jeff Conrad]

in message:

What does a switchboard(MS Access) do? What is it used for?

Here is a past post of mine on this subject which should help:The Switchboard form is bound to a table in your database called
"Switchboard Items." If you open this table in Design View you
will see all the various fields. Looking at the various records in
the table may help you understand what is going on behind the
scenes with the form.

Through code the form will display one "menu" of items at a time.
Through the wizard interface you can add/edit/delete items from
your various menus. Behind the scenes the wizard is actually
changing the data in this table. Each SwitchboardID number
corresponds to a different "menu." So the form will display any
matching SwitchboardID numbers and present that as a "menu"
type interface.

Here are some links that may help explain the process. Watch
out for any possible line wrapping on these links:

http://msdn.microsoft.com/archive/d...dnaraccessdev/html/ODC_CreateASwitchBoard.asp

http://office.microsoft.com/en-us/assistance/HP051887321033.aspx

http://office.microsoft.com/en-us/assistance/HP051887361033.aspx
Hope that helps,