Does anyone know how to display a mesage box to say that a macro is running, while the macro is running.

Some one will correct me if I am wrong here but I think the only way you could do that is to have a custom made form with the message open at the begining of the macro and then closed at the end. You may have to hide it and then unhide instead of opening and closing it.

[This message has been edited by BukHix (edited 09-20-2001).]

Thanks!

When I load the form the shell loads but the contents don't. I can't work out how to load the form with the visible property set to 0 and then change it.

I've tried to load the form in one macro and set the 'on load' property to run the second macro but the form just doesn't appear, although it does run the second macro.

Any sugestions?

Easiest way with macros to display a message in the "Status Bar Text" or Bottom of the Access window is to set the first line of the macro to ECHO

Leave Echo On = True
Set the Message (You are limited to 255 characters) in the Status Bar Text Property.

Otherwise go to using code vice macros and you can Use the SysCmd to set up something similar to this.

Hope you don't mind if I chime in here.

Create an unbound form. Put some text or whatever you want to say on it...for example...PLEASE WAIT MACRO RUNNING. For this example the name of this form is frmPleaseWait

Your macro should read like this...

Action: OpenForm
FormName: frmPleaseWait
WindowMode: Normal

Action: now run your actions

Last one should be:

Action: CloseForm
ObjectType: Form
ObjectName: frmPleaseWait
Save: No

That should do it.

Thanks for your help everyone.

I got round the the problem of just the shell of the form opening by repainting it straight after I opened it.