[AccessD] Queries Progress Bar

Hi Lambert

You are correct, but that seems to be how close we can get.

> 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


>>> Lambert.Heenan at aiuholdings.com 07-04-2009 22:10 >>>

 "...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
:)