Percent completed

#1 11-09-2008, 07:33 PM

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.

#2 11-09-2008, 09:19 PM

Dear Stephen:

The following link provides lots of information on progress bars:

http://www.accessmvp.com/JConrad/acc...gressbars.html

HTH
--
Fred Boer - Amateur Access Enthusiast
Interests: Library software / Z39.50 / Web Services
Freeware Small Library Application available here:
http://www3.sympatico.ca/lornarourke/

"SJW_OST" <SJWOST@discussions.microsoft.com> wrote in message
news:8AED2100-3867-42CE-A6BF-EEBEF5E1CF6A@microsoft.com...
>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.

#3 11-09-2008, 09:26 PM

On Nov 9, 6:33*pm, SJW_OST <SJW...@discussions.microsoft.com> wrote:
> 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.

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.

Thread Tools
Show Printable Version Email this Page
Display Modes
Linear Mode Switch to Hybrid Mode Switch to Threaded Mode