Solved

Me.Repaint Doesn't Update Screen

Posted on 2004-10-06
4
1,148 Views
Last Modified: 2008-01-09
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
Comment
Question by:dastrw
  • 2
  • 2
4 Comments
 
LVL 41

Accepted Solution

by:
shanesuebsahakarn earned 500 total points
ID: 12240823
Try DoEvents instead.
0
 
LVL 2

Author Comment

by:dastrw
ID: 12240877
For 500 points could you be a little more specific like giving me a DoEvents example?

Thanks.
0
 
LVL 41

Expert Comment

by:shanesuebsahakarn
ID: 12240905
That's literally all there is to it - just replace Me.Repaint with DoEvents, and that should kick it into action.
0
 
LVL 2

Author Comment

by:dastrw
ID: 12240950
Thanks.  I thought I might have to invoke, poll for, and trap events.

0

Featured Post

Is Your Active Directory as Secure as You Think?

More than 75% of all records are compromised because of the loss or theft of a privileged credential. Experts have been exploring Active Directory infrastructure to identify key threats and establish best practices for keeping data safe. Attend this month’s webinar to learn more.

Question has a verified solution.

If you are experiencing a similar issue, please ask a related question

Suggested Solutions

Most if not all databases provide tools to filter data; even simple mail-merge programs might offer basic filtering capabilities. This is so important that, although Access has many built-in features to help the user in this task, developers often n…
In a multiple monitor setup, if you don't want to use AutoCenter to position your popup forms, you have a problem: where will they appear?  Sometimes you may have an additional problem: where the devil did they go?  If you last had a popup form open…
In Microsoft Access, learn different ways of passing a string value within a string argument. Also learn what a “Type Mis-match” error is about.
In Microsoft Access, learn how to use Dlookup and other domain aggregate functions and one method of specifying a string value within a string. Specify the first argument, which is the expression to be returned: Specify the second argument, which …

910 members asked questions and received personalized solutions in the past 7 days.

Join the community of 500,000 technology professionals and ask your questions.

Join & Ask a Question

Need Help in Real-Time?

Connect with top rated Experts

21 Experts available now in Live!

Get 1:1 Help Now