Form not refresh, Access Not Respond when code running

[weekend00]

Hi All,

I always get a frozen form when the code is running, although my code keeps updating the message (textbox) in the form, the updates are not showed and Access is "Not Responding".

is there a way to show the updates? It's so boring waiting for a non reponding window.



I tried refresh, repaint, sleep(API), but could not get it work.

what else should I do?

[pbaldy]

Try DoEvents. I think it will work, though it can slow things down a bit. I've used SysCmd as an alternative to the textbox approach with success.

[weekend00]

DoEvents works fine.

Thank you, Pbaldy.

[weekend00]

I found some negative aticle about DoEvents, so I tried SysCmd, but SysCmd froze too. Maybe you mean that you used DoEvents with SysCmd?!