[AccessD] Queries Progress Bar

 > 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.

Oh that would be cool!  Play a clip of the sound from Jaws... du-dum.  du-dum du-dum du-dum... as 
your query progressed.  Freak your users right out!

;)

John W. Colby
www.ColbyConsulting.com


Gustav Brock wrote:
> Hi William
> 
> 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
> 
> 
>