An alert window when an macro is executing.

  • Thread starter Thread starter alexrs2k
  • Start date Start date
A

alexrs2k

Hi everyone.
I would like to know how I can display a message alerting the users to wait
while a macro is running. Thank you.
 
Hi alexrs2k,

Action: Openform
Form: Create a form with a label that includes your message.

Action(s): Your existing action(s) go here

Action: Close Form
Form: Close the same form you opened in the first action.

However, beware that if your macro fails for any reason at an earlier action
step, then your form will remain proudly displayed, requesting the user to
wait until perpetuity! In Access 2003 and all prior versions, one cannot trap
for errors and handle them gracefully when using macros. Any errors that
occur will cause a really ugly macro error dialog to be presented to your
users. The newest version of Access, Access 2007 allows for error trapping,
so macros are more appropriate to consider using for Access applications
created with Access 2007.

Consider the following quote:

From: "Inside Relational Databases, 2nd Edition, by Mark Whitehorn and Bill
Marklyn, published by Springer, p 151

"Macros offer the next level down, extending the functionality of the GUI.
Macros are still limited, however, and do not provide anything like the
enormous flexibility of a programming language. Both the macro and the
programming languages take some effort to learn and, surprisingly, often
require relatively different skills; in other words, a good working knowledge
of macros may not make it much easier to convert to using the programming
language. Perhaps even more surprisingly, I do not believe that programming
is fundamentally more difficult to learn. Macros are easier to use but not by
orders of magnitude."

"If you are new to RDBMSs, I suggest (with as much deference as possible)
that you may well not be in a position to judge whether you need macros or
programming. In that case, my advice is clear. Unless you are sure that your
needs really are simple, don't bother learning to use macros. Once you find
that you need more than the GUI offers, go straight to the programming
language. In this way you avoid the pain of climbing one learning curve only
to discover that the view from the top is unsatisfactory and another climb
awaits you."


Tom Wickerath
Microsoft Access MVP
http://www.accessmvp.com/TWickerath/
__________________________________________
 
Back
Top