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)
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.
Problem: My ProgressBar will always reach the end before my Do loop ends. Could you Please advise?