[AccessD] Queries Progress Bar

And... it does not display progress of a single query.

John W. Colby
www.ColbyConsulting.com


Hewson, Jim wrote:
> 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
>  
> 
>