Solved

Me.Repaint Doesn't Update Screen

Posted on 2004-10-06
4
1,159 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
[X]
Welcome to Experts Exchange

Add your voice to the tech community where 5M+ people just like you are talking about what matters.

  • Help others & share knowledge
  • Earn cash & points
  • Learn & ask questions
  • 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

MS Dynamics Made Instantly Simpler

Make Your Microsoft Dynamics Investment Count  & Drastically Decrease Training Time by Providing Intuitive Step-By-Step WalkThru Tutorials.

Question has a verified solution.

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

Access custom database properties are useful for storing miscellaneous bits of information in a format that persists through database closing and reopening.  This article shows how to create and use them.
This article describes a method of delivering Word templates for use in merging Access data to Word documents, that requires no computer knowledge on the part of the recipient -- the templates are saved in table fields, and are extracted and install…
With Microsoft Access, learn how to specify relationships between tables and set various options on the relationship. Add the tables: Create the relationship: Decide if you’re going to set referential integrity: Decide if you want cascade upda…
Add bar graphs to Access queries using Unicode block characters. Graphs appear on every record in the color you want. Give life to numbers. Hopes this gives you ideas on visualizing your data in new ways ~ Create a calculated field in a query: …

696 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