[AccessD] Queries Progress Bar

Stu

...works perfectly Stu ...it even takes the progress meter out of the status 
bar ...just "calculating" :)
...looks like this is a "plug-in" solution useful in a number of scenarios.
...of course I'd like to be able to match the gui with my own and perhaps 
add a cancel option and a caption :)
...so, how was this done and is the source available? ...never hurts to ask 
:)

...gustav ...tks for your help as well in getting Stu going.

...there simply is NO place on the web like AccessD :)

William

--------------------------------------------------
From: "William Hindman" <wdhindman at dejpolsystems.com>
Sent: Tuesday, April 07, 2009 2:09 PM
To: "Access Developers discussion and problem solving" 
<accessd at databaseadvisors.com>
Subject: Re: [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
>>
>
> -- 
> AccessD mailing list
> AccessD at databaseadvisors.com
> http://databaseadvisors.com/mailman/listinfo/accessd
> Website: http://www.databaseadvisors.com
>