Solved

Progress Bar: <To Kamall>

Posted on 1998-06-02
2
193 Views
Last Modified: 2010-05-03
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
Comment
Question by:heng
2 Comments
 

Accepted Solution

by:
eyaltil earned 50 total points
Comment Utility
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
 

Author Comment

by:heng
Comment Utility
I should have thought of that! Thanks
0

Featured Post

How to run any project with ease

Manage projects of all sizes how you want. Great for personal to-do lists, project milestones, team priorities and launch plans.
- Combine task lists, docs, spreadsheets, and chat in one
- View and edit from mobile/offline
- Cut down on emails

Join & Write a Comment

I’ve seen a number of people looking for examples of how to access web services from VB6.  I’ve been using a test harness I built in VB6 (using many resources I found online) that I use for small projects to work out how to communicate with web serv…
Introduction While answering a recent question (http://www.experts-exchange.com/Q_27402310.html) in the VB classic zone, I wrote some VB code in the (Office) VBA environment, rather than fire up my older PC.  I didn't post completely correct code o…
As developers, we are not limited to the functions provided by the VBA language. In addition, we can call the functions that are part of the Windows operating system. These functions are part of the Windows API (Application Programming Interface). U…
Show developers how to use a criteria form to limit the data that appears on an Access report. It is a common requirement that users can specify the criteria for a report at runtime. The easiest way to accomplish this is using a criteria form that a…

744 members asked questions and received personalized solutions in the past 7 days.

Join the community of 500,000 technology professionals and ask your questions.

Join & Ask a Question

Need Help in Real-Time?

Connect with top rated Experts

12 Experts available now in Live!

Get 1:1 Help Now