Best way to show an update

[Duncs]

I've got several macros, that run quite a few queries / sections of
VBA code. What I'm looking for is a way to display, unobtrusively,
the name of teh query / piece of code that is currently being run. I
also want to display it and have it change with no interaction from
the user.

So, if Macro1 has the following queries:

qry1
qry2
VBProc_A
qry3
qry4
vbaProc_B
qry5

I'd like the database to show somewhere that it is running qry1, then
when that is finished it is running qry2. Then, when that finishes,
it is running VBAProc_A etc.

I'm not sure on the best way to do this, whether it should be a simple
window with a label / text field that is updated with the name of the
query etc. If so, how would I update the label / text control with
teh name?

Or, is there a better way to do it?

TIA

Duncs

 

[Nick 'The Database Guy']

I've got several macros, that run quite a few queries / sections of
VBA code.  What I'm looking for is a way to display, unobtrusively,
the name of teh query / piece of code that is currently being run.  I
also want to display it and have it change with no interaction from
the user.

So, if Macro1 has the following queries:

qry1
qry2
VBProc_A
qry3
qry4
vbaProc_B
qry5

I'd like the database to show somewhere that it is running qry1, then
when that is finished it is running qry2.  Then, when that finishes,
it is running VBAProc_A etc.

I'm not sure on the best way to do this, whether it should be a simple
window with a label / text field that is updated with the name of the
query etc.  If so, how would I update the label / text control with
teh name?

Or, is there a better way to do it?

TIA

Duncs

Hi Duncs,

You could do it in the status bar, to do this you must use the Echo
command in the macro. Set the echo to false and specify the status
bar text as the query that is running. This should be slightly moe
elegant than the label / text control you were going to use.

Good luck,

Nick

 

[Nick 'The Database Guy']

Hi Duncs,

You could do it in the status bar, to do this you must use the Echo
command in the macro.  Set the echo to false and specify the status
bar text as the query that is running.  This should be slightly moe
elegant than the label / text control you were going to use.

Good luck,

Nick- Hide quoted text -

- Show quoted text -

slightly more *

 

[Nick 'The Database Guy']

slightly more *- Hide quoted text -

- Show quoted text -

Before you exit the macro don't forget to turn the Echo back on!