[AccessD] Queries Progress Bar

Hi Stuart

I knew it!
William now has the ball.

/gustav


>>> stuart at lexacorp.com.pg 07-04-2009 07:02 >>>
I have one now :-)

ProgBar.exe displays a simple progress bar  in a small Topmost window in the centre of 
your screen.  Download the  zipped file from
http://www.lexacorp.com.pg/soft/ProgBar.zip 

Shell to it with a parameter of the number of seconds you want it to run for i.e.

Shell CurrentProject.Path & "\Progbar.exe 10", vbNormalFocus

will look for it in the same directory as your MDB and display it for 10 seconds.

Cheers,
Stuart

> Nope, you have to do something yourself! ... Isn't a progress bar a
> standard component of Visual Studio? Or Stuart may have a micro
> implementation using PowerBasic. 
> 

> I just got the idea as I remember someone having success playing an audio file launched by a Shell command while Access continues to run.
> 
> /gustav
> 
> 
> >>> wdhindman at dejpolsystems.com 06-04-2009 15:49 >>>
> 
> ...and you just happen to have a working sample of this? :)
> 
> William
> 
> --------------------------------------------------
> From: "Gustav Brock" <Gustav at cactus.dk>
> Sent: Monday, April 06, 2009 9:34 AM
> To: <accessd at databaseadvisors.com>
> Subject: Re: [AccessD] Queries Progress Bar
> 
> > Hi William
> >
> > #5. Launch - before you run the query - with Shell an external tiny app 
> > that runs asynchronously (in another thread) and displays the progress 
> > bar.
> > Record the time for the query to run, store that value, and use it +10% as 
> > the full time for the progress bar next time it is launched.
> >
> > /gustav