[AccessD] Queries Progress Bar

...I knew that there just HAD to be a way to do this ...now to test it in a 
runtime ...tks :)

William

--------------------------------------------------
From: "Gustav Brock" <Gustav at cactus.dk>
Sent: Tuesday, April 07, 2009 4:53 AM
To: <accessd at databaseadvisors.com>
Subject: Re: [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
>
>
>
> -- 
> AccessD mailing list
> AccessD at databaseadvisors.com
> http://databaseadvisors.com/mailman/listinfo/accessd
> Website: http://www.databaseadvisors.com
>