How to create a "status" or progress [popup] display

[DKDiveDude]

Ok the question may sound cryptic, but I have a large database with many forms that all contains VBA code that can be iniated via a button and will perform some time consuming work.

I would like to be able to view some kind of status or progress of the work performed. Perhaps even dynamically like in from 0-100% work done.

Example send some status text to either a popup form or even the bottom "statusbar" text area. The problem with the latter is that I know how to change it via VBA, but as far as I know it requires me to access and change it using form and object. But I need this from so many forms and objects (buttons) that I would need to do a lot of code rework to actually know where I am calling my VBA code from.

Is it possible to change the status text "universally", that is without regards to a form and object?

Or how else can I go about to display some status/progress text which will work from any form and object without passing form and object name.

 

[DKDiveDude]

Ops I figured it out

retVal = SysCmd(acSysCmdSetStatus, "Hard at working burning CPU cycles...")

This also has an option to use a "meter" function which can be changed and updated to view progress

 

[llkhoutx]

The Syscmd progress meter has to be manually updated. It generally not satisfactory except for well timed events wherein you periodically update the progress bar manually.
I believe that a mere Hourglass does just as good. After a time, you users will know how long things take.

 

[DKDiveDude]

Yes I know it has to manually updated, and that's the beauty of it because you can show users the progress.

"I believe that a mere Hourglass does just as good. After a time, you users will know how long things take."

Are you joking or just not very user(customer) friendly?

The only downside I seen with the Syscmd using it yesterday, is that if I switch to another application, which can even be a simple thing as a screensaver invoking, when switching back MS Access busy doing work in VBA is just a blank screen so no more progress report there.

I do now need to investigate an alternate solution which would ALWAYS show the status and/or progress no matter what.

 

[llkhoutx]

Just experienced.