Progress Bar: <To Kamall>

Hi Kamall,
   Need your advice on progress bar again. The codes that you have provided works perfectly fine. But If i were to apply it into a do while loop. What would be the codes I need to modify in order to capture the processing accurately that means when my loop ends, my progress bar should end too. (Worst still is that I can only get the maximum value when my do while loop end.)Thus I was thinking how I could assign a value to progressbar1.max=value at the begining which we have been doing in a for loop.

Below are my codes:

Do while not EOF(1)
ProgressBar1.visible=true
ProgressBar1.Max=int_progress
......

record=record+1    //this is the place which my counter increase
........          //and only loop end then would I be able to
........         //know the no of records being processed.


ProgressBar1.Value=int_progress
int_progress=int_progress+1

Loop
ProgressBar1.visble=False

Problem: My ProgressBar will always reach the end before my Do loop ends. Could you Please advise?
hengAsked:
Who is Participating?
 
eyaltilConnect With a Mentor Commented:
hi,
i had the same problem a week ago.

solution:
open the file twice.
the first one, for calculating the records number (so u would now the progressbar1.max.
the second one, for doing what u want.

it is not an elegant way but it works
0
 
hengAuthor Commented:
I should have thought of that! Thanks
0
Question has a verified solution.

Are you are experiencing a similar issue? Get a personalized answer when you ask a related question.

Have a better answer? Share it in a comment.

All Courses

From novice to tech pro — start learning today.