Percent completed

  • Thread starter Thread starter SJW_OST
  • Start date Start date
S

SJW_OST

I have code which runs various queries in a specific order. Due to the length
of time it takes for the queries to run, I would like to have some sort of
progress indicator. The queries are being called using, of course, DoCmd. How
can I produce a progress indicator, either a procress bar or just a %
complete box, to show progress as each DoCmd is completed? I would not want
to click OK at any point of the progress indicator, I want it to just flow as
the code run the various DoCmd's.

Any help is greatly appreciated.
Stephen.
 
I have code which runs various queries in a specific order. Due to the length
of time it takes for the queries to run, I would like to have some sort of
progress indicator. The queries are being called using, of course, DoCmd.How
can I produce a progress indicator, either a procress bar or just a %
complete box, to show progress as each DoCmd is completed? I would not want
to click OK at any point of the progress indicator, I want it to just flow as
the code run the various DoCmd's.

Any help is greatly appreciated.
Stephen.
Click to expand...

you can use a progress bar on your form and do something like this:


'--update the progress bar on your form
DoCmd.OpenQuery "Query1"
Me.ProgressBar0.Value = Me.ProgressBar0.Value + cPERCENT
Me.ProgressBar0.Requery

If you put the queries in an array, you could loop through the array
and increment the progressbar by 100\ubound(array)+1 each time you go
through the processing loop.
 
Back
Top