[AccessD] Queries Progress Bar

Lambert

...A2K3 ...no longer shows the progress meter for the queries ...just 
"calculating..."
...and no, its not a perfect solution ...but its a damn sight better than 
anything else I've tried :)
...once I time the average query in a real world environment and set it in 
the parameters, it does what I need.
...and for my apps that run in different environments, I can auto test and 
set a global environment adjustment factor that once set, should play 
nicely.
...I'm happy, ymmv :)

...no question we'd all be happier with a progress bar running off the 
internals that MS uses for its own progress meter ...but so far I've not 
seen a hint of any such api ...in the meantime, Stu's solution is very, very 
useful in providing visual feedback in a single threaded process based on 
queries.

William

--------------------------------------------------
From: "Heenan, Lambert" <Lambert.Heenan at aiuholdings.com>
Sent: Tuesday, April 07, 2009 4:10 PM
To: "'Access Developers discussion and problem solving'" 
<accessd at databaseadvisors.com>
Subject: Re: [AccessD] Queries Progress Bar

>
> "...works perfectly Stu ...it even takes the progress meter out of the 
> status bar ...just "calculating"  "
>
> What version of Access? With A2K2 it has no effect at all on the native 
> progress bar: still shows up.
>
> But the biggest problem with this little tool is that you need to know in 
> advance how long the query will take to run before calling the progress 
> bar. Not much use IMHO. YMMV depending on network conditions etc. etc.
>
> Lambert
>
> -----Original Message-----
> From: accessd-bounces at databaseadvisors.com 
> [mailto:accessd-bounces at databaseadvisors.com] On Behalf Of William Hindman
> Sent: Tuesday, April 07, 2009 3:01 PM
> To: Access Developers discussion and problem solving
> Subject: Re: [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
> :)
>
> -- 
> AccessD mailing list
> AccessD at databaseadvisors.com
> http://databaseadvisors.com/mailman/listinfo/accessd
> Website: http://www.databaseadvisors.com
>