Problem is clicking min. button, not minimizing in code

[paul]

Thanks for the information. However, instead of writing
code to minimize/maximize Access, I would like to know
why the minimize button for the main Access window is
responsive to a mouse click when a modal dialog is
displayed. Isn't this incorrect behavior? And once the
window is minimized, it can't be restored.

Before I click a button on the modal form to run some VB
code, the minimize button of the main Access window does
not respond to mouse-clicks, as expected. It's only
while my code is executing that Access can be minimized
by clicking the minimize button on the main Access
window, while the modal form is displayed (and then the
Access window can't be restored).

 

[Wayne Morgan]

I just did some testing on this. It appears that if windows gets a chance,
it will minimize the Access window while the code is running. I sometimes
had to click the minimize button several times before it actually minimized.
I was always able to restore, but it wouldn't suprise me if the same timing
issue would occur on the restore. You may find that adding a DoEvents line
into the loop in the code or in a few stategic locations in the code if
there is no loop, may allow the mouse messages through and improve the
problem.