• Status: Solved
  • Priority: Medium
  • Security: Public
  • Views: 1162
  • Last Modified:

Me.Repaint Doesn't Update Screen

I have an Access application which takes a long time to perform all of its functions.  I would like to work with other applications while I'm waiting for the work to complete.

I have a text box which is updated as key tasks are completed.  After I update the text box, I do a Me.Repaint (and even a Me.Refresh) to show the updated text.

However, as soon as I change the focus from my Access application to another application (such as Excel or Outlook) the Access application no longer updates.  I just freezes until the entire application is complete.

Is there a way to keep the Access screen updating even when it loses focus?
0
dastrw
Asked:
dastrw
  • 2
  • 2
1 Solution
 
shanesuebsahakarnCommented:
Try DoEvents instead.
0
 
dastrwAuthor Commented:
For 500 points could you be a little more specific like giving me a DoEvents example?

Thanks.
0
 
shanesuebsahakarnCommented:
That's literally all there is to it - just replace Me.Repaint with DoEvents, and that should kick it into action.
0
 
dastrwAuthor Commented:
Thanks.  I thought I might have to invoke, poll for, and trap events.

0

Featured Post

Get free NFR key for Veeam Availability Suite 9.5

Veeam is happy to provide a free NFR license (1 year, 2 sockets) to all certified IT Pros. The license allows for the non-production use of Veeam Availability Suite v9.5 in your home lab, without any feature limitations. It works for both VMware and Hyper-V environments

  • 2
  • 2
Tackle projects and never again get stuck behind a technical roadblock.
Join Now