Microsoft Access 2010 Bible

Chapter 30: Using Access Macros

1055

Action Action Argument Action Argument Setting

Echo Echo On No

Status Bar Text Step 1: Deleting Data

OpenQuery Query Name qryDeleteContactsBackup

View Datasheet

Data Mode Edit

OpenQuery Query Name qryDeleteProductsBackup

View Datasheet

Data Mode Edit

Echo Echo On No

Status Bar Text Step 2: Appending Data

OpenQuery Query Name qryAppendContactsBackup

View Datasheet

Data Mode Edit

OpenQuery Query Name qryAppendProductsBackup

View Datasheet

Data Mode Edit

Echo Echo On Yes

Status Bar Text <Leave Blank>

SetWarnings Warnings On Yes

Hourglass Hourglass On No

MessageBox Message Contacts and Products have been archived.

Beep Yes

Type Information

Title Finished Archiving

Here’s a look at the actions this macro performs:

l (^) Hourglass: This action changes the cursor to an hourglass or a pointer using the
Hourglass On argument. For macros that may take a while to run, set this argument to
Yes at the beginning of the macro and to No at the end of the macro. Be sure not to forget
to set Hourglass off at the conclusion of the macro. Otherwise, the hourglass cursor
stays on indefinitely.