Showing progress window in a macro

[Marc Beausejour]

Hi everyone,
I want to show the progress of a processing in an informational window when running a macro. The process can take 5 to 15 minutes to complete. Actually, the frame of the window is showing but no value is showing into the controls. The window form is read only form.
The process is like this:

Start - (Setup VarTemp of 0% complete)
.
Open window first time
.
Process...
.
Close window
Setup VarTemp of 25% complete
Re-open window
.
Process
.
Close window
Setup VarTemp of 40% complete
Re-Open window
.
Etc...

Because the window form is read only, each time the macro open the window form the process of the macro continue on the next step but the controls are not showing. If I insert a pause (like Zonemessage) between each open/close window instruction, the value of the controls of the window is showing as expected.

I tried to "requery" instead of "open/close" de window but the result is the same.

I'm sure I missed somthing into the setup of the window but I don't know what. Any Idea ?

I run MsAccess 2016 on window 365

Marc

 

[tvanstiphout]

Maybe it's because the system is so busy it doesn't get control back to update the screen.
In the form's Form_Load event write:
DoEvents
That will make all pending events execute, including screen drawing.