user feedback from macro

  • Thread starter Thread starter RCL
  • Start date Start date
RCL,

At a guess, I'd say you might be able to use a MsgBox in your macro for
this. Can you give more details of what you want to do, with examples?
 
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.
 
RCL,

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...

Action: SetValue
Item: [NameOfLabel].[Caption]
Expression: "Now running query1"
Action: RepaintObject
<arguments blank>
Action: OpenQuery
Query Name: query1
Action: SetValue
Item: [NameOfLabel].[Caption]
Expression: "Now running query2"
Action: RepaintObject
<arguments blank>
Action: OpenQuery
Query Name: query2
.... etc
 
Back
Top