VBA Processing Time

N

NotTechSauvy??

I am currently running a process that showcases what queries are being
executing by vba on the mainform. The issue is that when i try to
update the label(label.caption = "qry1-n") is doesn't refresh the
queries that run quickly. Is there a way to refresh the label quick
enough so that i can be seen on the main form
 
M

Michael Bednarek

I am currently running a process that showcases what queries are being
executing by vba on the mainform. The issue is that when i try to
update the label(label.caption = "qry1-n") is doesn't refresh the
queries that run quickly. Is there a way to refresh the label quick
enough so that i can be seen on the main form
Click to expand...

No. You have to slow down the process of displaying the label, probably
best with the Repaint method of the UserForm object.
 
Top