Creating Macros
- What is a macro?
- Running a macro manually
- Macro design window
- Starting and saving a macro group
- Naming a macro
- Selecting an action
- Selecting an action argument
- Creating a macro to View/Edit Tables/Queries
- Creating a macro to provide a message
- Creating a macro to view a report
- Creating a macro to transfer data
- Editing in a macro group
- Safe guarding a macro group
Menus and Forms
- Understanding events
- Command buttons using an existing macro
- Building a new macro with On Click property
- Renaming a referenced macro
Integrating Forms, Reports and Macros
- Form controls as report criteria
- Checking for null condition
Custom Command Buttons
- Creating record navigation buttons
- Duplicating fields from previous record
- Creating buttons that modify control data
|
Form Controls as Query Criteria
- Form controls as query criteria
Macros that Select Records
- Creating a submenu
- Using macros to synchronize forms
- Creating a form to select random records
Record Processing
- Creating historical data tables
- Using tag property for messages
Changing Form and Control Properties
- Using visible property for messages
- Using enabled property to dim controls
Special Topics
- (Optional) Storing default values for form controls
- Using a version table
- Creating a start up macro (Autoexec)
- Startup and exiting tools
- (Optional) Multi-MDB applications
|