Database macros can be stored in one of two ways in: global or local. The following table explains the differences:
|
Global macros |
Database specific macros |
Stored in |
Global database macro file (abdata.abd). The file is in the program directory ("c:\program files\ability office\" by default) |
The database it was created in. |
Create using |
Tools/Macros menu. |
File/New/Macro from menu (a database must be open). |
Run by |
Tools/Macros menu – can also be run from a button on the toolbar or by keyboard shortcut. |
Double-click directly from Database Manager. |
Notes |
Identical operation to global macros in Spreadsheet and Write. |
Can contain one or more subroutines or functions – the first one in the file will be the default (i.e. double-click will run the top most macro). |
Database shares the same database engine as Microsoft Access and some users may already be familiar with automation using DAO. Ability allows access to two of the fundamental DAO objects. See Using DAO automation for more details.
See also: