[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