[Last Call] Learn about multicloud storage options and how to improve your company's cloud strategy. Register Now

x
?
Solved

Me.Repaint Doesn't Update Screen

Posted on 2004-10-06
4
Medium Priority
?
1,161 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 2000 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

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

Question has a verified solution.

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

Preparing an email is something we should all take special care with – especially when the email is for somebody you may not know very well. The pressures of everyday working life stacked with a hectic office environment can make this a real challen…
Did you know that more than 4 billion data records have been recorded as lost or stolen since 2013? It was a staggering number brought to our attention during last week’s ManageEngine webinar, where attendees received a comprehensive look at the ma…
Access reports are powerful and flexible. Learn how to create a query and then a grouped report using the wizard. Modify the report design after the wizard is done to make it look better. There will be another video to explain how to put the final p…
With Secure Portal Encryption, the recipient is sent a link to their email address directing them to the email laundry delivery page. From there, the recipient will be required to enter a user name and password to enter the page. Once the recipient …

650 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