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

  No need to shell for that, the play sound function will allow a sound to
play asynchronously right from within VBA.  You just need to call it with
the right argument.

Jim.

-----Original Message-----
From: accessd-bounces at databaseadvisors.com
[mailto:accessd-bounces at databaseadvisors.com] On Behalf Of Gustav Brock
Sent: Monday, April 06, 2009 10:11 AM
To: accessd at databaseadvisors.com
Subject: Re: [AccessD] Queries Progress Bar

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



-- 
AccessD mailing list
AccessD at databaseadvisors.com
http://databaseadvisors.com/mailman/listinfo/accessd
Website: http://www.databaseadvisors.com