asked on

Progress Bar

Hi,

I am wanting to add a progress bar to a form that mimics the progress meter in the status bar - to show progress while runnning queries or generating reports. The only thing I can think of it to read the status bar progress meter from the form timer event.

Is there a better way?

Cheers

SOLUTION

Natchiket

membership

This solution is only available to members.

To access this solution, you must be a member of Experts Exchange.

Start Free Trial

WilloWomble

ASKER

Yeah, I know how to add/use the progress bar control.
I was hoping to be able to somehow hook in to the process and determine it's progress.

SOLUTION

Natchiket

membership

This solution is only available to members.

To access this solution, you must be a member of Experts Exchange.

Start Free Trial

SOLUTION

thenelson

membership

This solution is only available to members.

To access this solution, you must be a member of Experts Exchange.

Start Free Trial

puppydogbuddy

Question for Nelson,
Why couldn't you estimate, through several trial runs, how long a particular process takes and use the elapsed time as compared to total estimated time as your progress meter, or better yet, why couldn't the record count (for queries, etc) for the current record vs total records be used ?

ASKER CERTIFIED SOLUTION

thenelson

membership

This solution is only available to members.

To access this solution, you must be a member of Experts Exchange.

Start Free Trial

puppydogbuddy

Nelson,
Thanks for that excellent, detailed explanation. You must have the second fastest typing fingers on EE ...second only to Leigh Purvis..............
PDB

WilloWomble

ASKER

That's a shame, especially that VBA is suspended (I thought nothing stopped a modal form timer..obviously I was wrong)

Thanks for all your help!

Cheers :o)

thenelson

Your Welcome!
>I thought nothing stopped a modal form timer
I have found dropping a laptop will do this pretty well ;-(