[AccessD] Queries Progress Bar

William,

  I'm going to send you a progress bar form off line that I wrote.

  However unless you run the query asynchronously, which you can only do
through an ODBC Direct connection, it's not going to do you much good.  With
regular JET based queries, they run synchronously and you won't get control
back until it's finished.  

  You'd be better off with an animation as the other's have suggested.

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 3: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