[AccessD] Queries Progress Bar

I think it's a great idea.  
I have tried several times to do what you describe - I have never been
successful.
What I learned is that any progress bar you make will ultimately be a
something you have crafted with two labels and code to make progress
after each process completes.  That means after each query runs...
I have used the FMS add-in and it does work, but it takes up more
clock-time to run than it's worth.
I hope someone can give you help on this.

Jim


-----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
################################################################################
If you have received this message in error, please contact the sender
immediately and be aware that the use, copying, or dissemination of 
this information is prohibited. This email transmission contains 
information from NCI Information Systems, Inc. that may be considered 
privileged or confidential and is intended solely for the named 
recipient.
################################################################################