Pop Up Windowing - Sometimes it just doesn't go away!

R

Rick Roberts

Access 2003

I have a popup/modal window that serves as a status display for a lengthy
report pre-processing. At the end of the pre process the code performs a

Docmd.close acform “PreProcessFormâ€
Followed by a
Docmd.OpenReport “MyReportâ€, acpreview

95% of the time this works as expected but every now and then the “closedâ€
window stays on top and the report preview is displayed underneath it. The
problem happens rarely but there must be a way to control the windowing 100%
of the time.

Any ideas?
 
S

strive4peace

Hi Rick,

you need a comma after acform
Docmd.close acform, “PreProcessFormâ€

if this isn't it, follow the ststament with
DoEvents


Warm Regards,
Crystal
*
:) have an awesome day :)
*
MVP Access
Remote Programming and Training
strive4peace2006 at yahoo.com
*
 
R

Rick Roberts

Thanks Crystal,

My aircode is not quite as good as my actual coding. The comma is there and
I do have a DoEvents that is executed immeaditely after the form close and
before the report open. It seems to be platform specific meaning it works
fine on my dev machine and on most prod users machines but there are two
users who run Windows XP where the problem exist.

The saga continues...

BTW I like your email addy
 
Top