Things I've tried:
Popping up a form announcing "Processing". The form has both Pop Up and
Modal attributes set to Yes. (BTW - Even if the form displays "Don't
click the mouse while this is working" the users still do and crash the
Turned the Pop Up and Modal attributes to No.
Better indexed my data.
Enabled the "Raise execution priority from Windows applications" option
in SQL Server.
Thanks in advance. Any help would be greatly appreciated.
I tried it, but the program still crashes hard.
It's the Access version of the BSOD (Blue Screen Of Death)
Thanks for the tip, it got me thinking and trying new things.
I got the code to work using DoEvents and here is how I did it:
FOR intX = 1 TO SomeLargeNumber
IF intX MOD 200 = 0 THEN
The reason I did it this way is because DoEvents will slow a loop down,
so I only evoke it every 200 loop cycles.