How may I create a dynamic message box/ progress bar with access 97?

Well, I do hate asking vague questions bu开发者_运维技巧t I can't help it this time: Some macros I'm coding are taking a long time to run - and I just realized that it's incredible boring to just wait for it.

I want a progress bar. Or even a message box stating "Loading..." with a cancel button. I tried using MS help to do this, but they require an ActiveX controller and that's just not an option.

Personally, I really didn't even try to code anything becouse I'm not even sure if it's possible! Everytime I open a MsgBox the whole program stops running, and that's not my idea.

I tried checking some concepts in C+ or Java, but most people seem to use a function just for that.

Anyway, any kind of lead or small piece of information would help a lot.

PS.: Yeah, I'm using Access 97, and that's not something I can change in the moment.

1. The problem with using MsgBox is that it stops everything until it gets a user response. That's not what you need for this.

2. Try making a very simple Wait form. It would have 1 unbounded label that says "Please Wait". Before your calculations begin, call it up with a docmd.OpenForm(... and close it when you're done with a docmd.closeform(...