I would like to know the meaning of the number commands in the Access
switchboard items table, and how to manually create a switchboard from a
form. Thanks
If you open the Switchboard form in Design View and go to the code
module you will see these constants listed:
Const conCmdGotoSwitchboard = 1
Const conCmdOpenFormAdd = 2
Const conCmdOpenFormBrowse = 3
Const conCmdOpenReport = 4
Const conCmdCustomizeSwitchboard = 5
Const conCmdExitApplication = 6
Const conCmdRunMacro = 7
Const conCmdRunCode = 8
Here is what they do:
1 - Go to a Switchboard Menu
2 - Open a form in Add mode (only new records allowed)
3 - Open a form in Edit mode (show all records from the data source)
4 - Open a specific report
5 - Launch the wizard again to make modifications
6 - Exit the current database (keeps Access open though)
7 - Run a specific macro
8 - Run some code (usually from a module)
I'm not quite sure I understand the second part of your question.
The Swithboard 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