[AccessD] Queries Progress Bar

William Hindman wdhindman at dejpolsystems.com
Fri Apr 3 14:20:31 CDT 2009


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
 





More information about the AccessD mailing list