How can I monitor a macro by query name and status?

P

petz

I have several macros that run multiple queries and would like to monitor
progress as queries run. I'd like to see the query name and status. Is there
a setting for this or an add-on I can get?
 
S

Steve Schapel

Petz,

Are you running the macro from an event on a form? If so, you could put
a label control on the form, and every time the macro moves on to the
next query, you could insert a SetValue action to change the label's
Caption property to the name of the query.
 

Ask a Question

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.

Ask a Question

Similar Threads

Tracking Resources as Trade Types - Rather than Individuals 1
Doughnut Chart linked with the slicer in the pivot table 0
Populate a table based on check box status 2
Incone & Expenses Statement 0
Need Help with Macro Security 1
Trying to create a report that will list unmatched records by Ticket Primary Key 0
Word VBA - Want to test if Full Name is NOT Present in document 0
Menu Macro Not Executing - Need Help 1

Top