Databases - MS Access Application Navigation
There are several ways to navigate an application
Menus
Switchboard
Microsoft's Application Navigation wizard provides a GUI
to create and edit a simple navigation system.
Tools / Add-Ins / Switchboard Manager
If a Switchboard is not already present,
the manager prompts you to create one.
the Switchboard Items table (5 fields)
and the Switchboard form.
Table:
- The primary unique key is composed of SwitchboardID
and ItemNumber.
- ItemText - displayed on the buttons
- Command - 1 of 8 predefined constants
- Argument - Name of the form or report
Form:
- 8 generic buttons
- The buttons and labels are displayed/hidden based on data in the table.
- There are 8 command verbs - open form, open report, run command
select menu, exit, and 3 more. In the wizard,
you select these from a list
- The default colors (olive and gray) are hideous - but you can fix this.
This does not provide a way to open a report with the result of a query.
Author: Robert Clemenzi -
clemenzi@cpcug.org