Window change - Form doesn't pop up while it's working

  • Thread starter Thread starter Reiner Harmgardt
  • Start date Start date
R

Reiner Harmgardt

Hi NG

I'm searching for the reason, while my Form in Access97 doesn't pop up again
while it's working, when i'm changing the window from the access-form to
f.e. Excel
or Explorer and then want to jump back again into my Access-Form.
It doesn't pop up until the work in the form is done.

If there's no work ongoing, it comes back as expected, but
if it's working, it don't.

Is there a special parameter to change in the form?

Thanks for helping

Regards

Reiner
 
Hi Reiner,
within loops (for example before the loop or next command)
and periodically within long processes include the line

doevents


this interupts code to facilitate window events such as
swopping between applications and so forth.

Luck
Jonathan
 
Access treats re-drawing the screen as a low-priority task, if it is busy
doing something else with a higher priority, such as executing a query, the
redrawing of the screen will be postponed. From your description, I think
that's what you're seeing. I don't believe there is any way to change that
behaviour.

--
Brendan Reynolds (MVP)
http://brenreyn.blogspot.com

The spammers and script-kiddies have succeeded in making it impossible for
me to use a real e-mail address in public newsgroups. E-mail replies to
this post will be deleted without being read. Any e-mail claiming to be
from brenreyn at indigo dot ie that is not digitally signed by me with a
GlobalSign digital certificate is a forgery and should be deleted without
being read. Follow-up questions should in general be posted to the
newsgroup, but if you have a good reason to send me e-mail, you'll find
a useable e-mail address at the URL above.
 
Back
Top