[AccessD] Queries Progress Bar

William Hindman wdhindman at dejpolsystems.com
Mon Apr 6 08:22:40 CDT 2009


...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
> The information contained in this transmission is intended only for the 
> person or entity to which it is addressed and may contain II-VI 
> Proprietary and/or II-VI Business Sensitive material. If you are not the 
> intended recipient, please contact the sender immediately and destroy the 
> material in its entirety, whether electronic or hard copy. You are 
> notified that any review, retransmission, copying, disclosure, 
> dissemination, or other use of, or taking of any action in reliance upon 
> this information by persons or entities other than the intended recipient 
> is prohibited.
>
>
> -- 
> AccessD mailing list
> AccessD at databaseadvisors.com
> http://databaseadvisors.com/mailman/listinfo/accessd
> Website: http://www.databaseadvisors.com
> 




More information about the AccessD mailing list