I have a macro with a long list of queries that run one after the other. I
would like some feedback that would say "now running query1" "now running
query2", etc.
A MsgBox stops and requires you to close it before moving to the next query.
I would prefer that the screen just update with the new message.
I tied "Echo" but it echoes so quickly and then the task bar displays
"running query" but no query name.
I also created a function to update a form, and then called the function
from the appropriate place in the macro. It works, but it does not update in
a timely fashion. It will say "running query1" while it is really on
query4. I tried adding "do events" to the function but it does not help.
I am not sure what you mean by "update a form". You could certainly use
a label on a form, to show the information you want, by adjusting its
Caption property. In the macro, you would do this by using a SetValue
action. You would possibly need to use a RepaintObject action as well.
So the macro might look something like this...
Want to reply to this thread or ask your own question?
You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.
