Show progress of large macro

[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)?

 

[George Nicholson]

Displaying a Progress Bar (using syscmd and Access' own Status Bar)
In the Q & A section of:
http://office-watch.com/access/archtemplate.asp?7-23

Free chapter from the Access Cookbook: How to Create a Generic Reusable
Status Meter
http://msdn.microsoft.com/library/d.../en-us/dnacbk02/html/ODC_CookbookChapter9.asp

HTH,

 

[Steve Schapel]

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