Macro Progress

[StephenB]

Hello all. I've just inherited an Access database that has a macro with about 50 steps. This macro might run for almost an hour. I'd like to kick off the macro and go about my business, while looking back every few minutes to see at what stage the macro is at. However, all the status bar at the lower left hand corner gives me is "Running Query..."
I've looked into progress bars, but most of those are just pretty looking timers. I saw one example that called a form with labels corresponding to each step of the process. Each label was set to not visible (except for the first one.) As each step of the process completed, the corresponding label on the form was changed to visible. Peachy! Only things is that example had the process in VB in a module as opposed to a macro. I don't really want to take the time to re-invent the wheel by re-writing this guy's macro to vb.
I've tried working with message boxes, but that didn't work out to well, since I couldn't figure out how to not require dialog before going onto the next step in macro.
Any suggestions?
Thanks in advance.
Stephen

 

[Mike375]

The macro action you want is SetValue.

For visible it is

Item [Forms]![2ProspectT]![Label2139].[Visible]
Expression No

I use a similar thing to what you are talking about. However, I have a lot of unbound textboxes that are small squares across the screen and the background colour goes from transparent to red.

Here is forecolour

[Forms]![2ProspectT]![Label605].[ForeColor]
65280