[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.