Macro Status

[BigJimSlade]

Hi, Big Jim here:

I have a macro with 200 queries in it. Some of these queries take close to an hour to run.

Big Jim's boss wants to know if there is anyway to determine what query the macro is on. The Query status bar in the bottom left-hand corner doesn't provide much info. Is there something else I can use?

I know I could always build a form and put the queries into a listbox and create my own in-house macro, but I was hoping there was an easier way.

Thanks in advance!

Big Jim

 

[The_Doc_Man]

Insert an ECHO action between successive queries.

In the literal text for the ECHO, put any message you want.

Add one more at the end of the macro to echo READY.

 

[BigJimSlade]

Doc!

Big Jim sends his many thanks. I wonder if this command is related to the Echo On/Off statement from the days of DOS.

However, Big Jim's boss is looking for a way to do this without having to put ECHO in between every step. Any further thoughts?

Thanks again

Big Jim