On Sep 20, 3:58*pm, "Nick 'The Database Guy'" <nick...@btinternet.com>
wrote:
> On Sep 20, 3:58*pm, "Nick 'The Database Guy'" <nick...@btinternet.com>
> wrote:
>
>
>
>
>
> > On Sep 20, 3:41*pm, Duncs <true.kilted.s...@gmail.com> wrote:
>
> > > 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- Hide quoted text -
>
> > - Show quoted text -
>
> slightly more *- Hide quoted text -
>
> - Show quoted text -
Before you exit the macro don't forget to turn the Echo back on!
|
Similar Threads
