progress bar

[patbb]

I am searching for a particular record by passing through the table until I found the corresponding ID

While Searching,I have displayed a progress bar to show the evolution of the search.

Also, Since usually the last records in the table are the most often used, I have used the following mechanism to search:

- Check if the ID > total Number of records / 2

if yes then

-move to last record and then continuously move previous until the search id is found

else
-move first and then move next.


my problem is when I move last and then move previous, The progress bar also move backwards as I have set the max value to Total number of records and Min Value to the Search ID


So what's the solution to make the progress bar move forward even though I am moving backwards in the table?

thanks

[VictorB212]

Set the progress bar's max property to the number of records.

Increment the progress bar one for every record searched.

[Bloged]

I would use a integer that keeps the number of processed records!

So that max is still the same but everytime a record is checked the integers value = + 1 and the processbar value = the integer!

Hope you understand what I'm trying to explain

Grtz,

Bloged

[Mark Sreeves]

how are you setting the progressbar value?

if you just increment the progress bar rather than tying it to the current recordset location it won't matter if you are going forwards ofr backwards

ProgressBar1.Value = ProgressBar1.Value +1