Macro Status

[Mark]

Currently I run a month end macro which calls about 20-30 queries in order –
due to server issues this process can take up to 2 hours is there anyway I
can get Access to show a status box during this time? (a box which shows
which query is being run)

Cheers

Mark

 

[Ken Snell [MVP]]

You could create a form with a label on it. As the first step in the macro,
open the form in normal mode. Then, just before you run a query, use the
SetValue action to set the caption text in the form's label -- something
like this:

Action: SetValue
Expression: Now running query [name]....
Control Name: Forms!YourFormName!LabelName.Caption

Then close the form as the last step in the macro.