Show progress of large macro

  • Thread starter Thread starter Guest
  • Start date Start date
G

Guest

I have a macro that runs a series (38 in all) of queries, functions and
macros to assign work items to various teams of people in our department.
Can anyone show me a way to display the progress of the macro while it is
running (other than leaving the warnings on and having to hit OKAY after all
the update queries)?
 
Molasses,

One simple approach is to run the process via an event on a form. This
form has a label on it, let's say you name the label "ProgressStatus".
After each of the 38 segments in the macro, you can add two actions like
this...
Action: SetValue
Item: [ProgressStatus].[Caption]
Expression: "1 of 38 items completed"
Action: RepaintObject
 
Back
Top