 |
 | Home | Contact Us | FAQ | Search & Site Map | Link to Us |
 | Sign In | Join | Other 45 Sites in Network |
MS Access Forum / Macros / September 2005user feedback from macro
Is there a way to get user feedback with a macro to let you know which query is running? 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?  SignatureSteve Schapel, Microsoft Access MVP > Is there a way to get user feedback with a macro to let you know which query > is running? 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, > [quoted text clipped - 3 lines] > > Is there a way to get user feedback with a macro to let you know which query > > is running? 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 SignatureSteve Schapel, Microsoft Access MVP > 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 [quoted text clipped - 10 lines] > 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. |
Reply to this Message |
 Sign In
 Join
 My Latest Posts My Monitored Threads My Blog My Photo Gallery My Profile My Homepage Start New Thread Enable EMail Alerts Rate this Thread
|
©2008 Advenet LLC Privacy Policy - Terms of Use
This website includes both content owned or controlled by Advenet as well as content owned or controlled by third parties.