WilloWomble
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
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
membership
This solution is only available to members.
To access this solution, you must be a member of Experts Exchange.
SOLUTION
membership
This solution is only available to members.
To access this solution, you must be a member of Experts Exchange.
SOLUTION
membership
This solution is only available to members.
To access this solution, you must be a member of Experts Exchange.
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 ?
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
membership
This solution is only available to members.
To access this solution, you must be a member of Experts Exchange.
Nelson,
Thanks for that excellent, detailed explanation. You must have the second fastest typing fingers on EE ...second only to Leigh Purvis..............
PDB
Thanks for that excellent, detailed explanation. You must have the second fastest typing fingers on EE ...second only to Leigh Purvis..............
PDB
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)
Thanks for all your help!
Cheers :o)
Your Welcome!
>I thought nothing stopped a modal form timer
I have found dropping a laptop will do this pretty well ;-(
>I thought nothing stopped a modal form timer
I have found dropping a laptop will do this pretty well ;-(
ASKER
I was hoping to be able to somehow hook in to the process and determine it's progress.