[AccessD] Queries Progress Bar

...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
>
>
>>>> wdhindman at dejpolsystems.com 06-04-2009 15:22 >>>
> ...you call these OPTIONS? ...would you rather swallow rat poison or 
> Clorox eh? :)
> ...tks, its a decent summary of one of Access's limitations that there 
> just is no decent work around for.
>
> William
>
> --------------------------------------------------
> From: "Drew Wutka" <DWUTKA at marlow.com>
> Sent: Sunday, April 05, 2009 5:13 AM
> To: "Access Developers discussion and problem solving"
> <accessd at databaseadvisors.com>
> Subject: Re: [AccessD] Queries Progress Bar
>
>> I'd say you have the following options:
>>
>> #1. Put in an animation (.avi file).  This would have no accuracy at
>> all.
>>
>> Nothing in Access is going to work while a query is running, because VBA
>> is single threaded, so when you run the query, no other code in your
>> project will run.
>>
>> #2.  Break the query down into steps you run manually in code, and thus
>> can provide status points to display a progress.
>>
>> #3.  Run the query outside of Jet, I believe ADO (or maybe it's
>> something else) will provide a progress.
>>
>> Both 2 and 3 are going to slow things down, because Jet is going to run
>> optimized on it's own, these options are going to take longer.
>>
>> #4.  Jet is reporting the progress to the status bar.  In theory, you
>> could create an ActiveX progress bar that would monitor and redisplay
>> the progress from the status bar itself.  That's completely theoretical.
>> I haven't looked into the logistics.  The key component would be whether
>> the activeX would keep running on it's own, outside of the VBA thread.
>>
>> Drew
>>
>> -----Original Message-----
>> From: accessd-bounces at databaseadvisors.com
>> [mailto:accessd-bounces at databaseadvisors.com] On Behalf Of William
>> Hindman
>> Sent: Friday, April 03, 2009 2:21 PM
>> To: Access Developers discussion and problem solving
>> Subject: [AccessD] Queries Progress Bar
>>
>> Group
>>
>> ...I have the following in the FormLoad event:
>>
>>    DoCmd.SetWarnings False
>>    tblExhibitorWebClear
>>    DoCmd.OpenQuery "qryExhByShowCurrentAppend"
>>    DoCmd.OpenQuery "qryExhByShowPastAppend"
>>    DoCmd.SetWarnings True
>>
>> ...that all happens in the background
>> ...in the foreground I want to display a progress bar that shows the user 
>> the progress during the entire process which can take a couple of 
>> minutes.
>> ...don't want to use the vb ocx if possible, but would if necessary.
>> ...don't want to use the progress meter in the status bar
>> ...accuracy isn't necessary ...just a reasonable approximation.
>> ...tried using a timer and labels but the queries always run before the 
>> timer starts
>> ...any ideas or samples much appreciated
>>
>> William
>
>
> -- 
> AccessD mailing list
> AccessD at databaseadvisors.com
> http://databaseadvisors.com/mailman/listinfo/accessd
> Website: http://www.databaseadvisors.com
>