Want to protect your cyber security and still get fast solutions? Ask a secure question today.Go Premium

x
  • Status: Solved
  • Priority: Medium
  • Security: Public
  • Views: 207
  • Last Modified:

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?
0
heng
Asked:
heng
1 Solution
 
eyaltilCommented:
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

Featured Post

Concerto's Cloud Advisory Services

Want to avoid the missteps to gaining all the benefits of the cloud? Learn more about the different assessment options from our Cloud Advisory team.

Tackle projects and never again get stuck behind a technical roadblock.
Join Now