progress bar ?

[ooops]

Hello all,

I need your help in making my progress bar work. I have no idea how. The status bar doesn't have to show real percentage of task completed. I just want the have the bar there with color flashing or running until the task is done. Thanks in advance.

PS: this is not for retrieving data from the database so I can't not use this
progressBar.Value = rsRecorset.PercentPosition

Please show me other ways. Thanks Sincerely,
Bao Nghi

 

[cdidion]

Here's an idea:

Put a timer on your form and set the interval to the flash interval you want.

In the timer_OnTimer event switch the progress bar's value from min to max and back again:

with prgBar
if .value = .max then
.value = .min
else
.value = .max
end if
end with

If it has problems flashing, then you'll propbably want to put a DoEvent() right after you change its value. This gives the program a chance to do stuff if it is otherwise locked up doing other things.

Hope that helped. -Chris Didion
Matrix Automation, MCP

 

[Guest_imported]

Hi

Thanks so much for your promt response. I think it's exactly what i need. However i'm still unable to make it work, and this is probably the most stupid question you've ever got but since i don't know i have to ask anyway. How do I initialize the timer to work with the progress bar ?
Again, thank you.

 

[75cl]

Set Progressbar to max value at beginning of the code that you want to execute
for example:
Public Sub Main()
progressbar1.value = 100
Connectiontodatabase
progressbar1.value = 30
call calculateinterestrate
progressbar1.value = 50
Call Outstandingbalance
progressbar1.value = 100
end sub

I hope this help
Chris Le

 

[gun123rt]

can you help me write a short program to find the difference between two times. that is time1-time2
thank

 

[cdidion]

Look-up the DateDiff function - it can return the difference in times that you specify. (Minutes, Hours, Seconds, Days, etc.) -Chris Didion
Matrix Automation, MCP