Database macros

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:

Working with Databases

Working with tables

Working with fields