Force focus away from a tab page on the hour

[dcdimon]

I have a tab control with eight pages - 1 for each hour of an eight hour shift - and I'd like to force the focus away from an hour and to another as the clock hour changes. Thus, if you're on hour 2 tab when the clock hour went from 2 to 3 you'd be moved to the hour 3 tab.



I have this working with a time interval and a set focus event on the form's On Timer event with the interval set at 5 minutes. However, what I'd like to be able to do is set the interval dynamically, depending on when they opened that current hour's tab.

Something like CurrentTime - Next Whole hour = minutes until next hour. That way I'd only be cycling one per hour and eliminating the screen flash I get now every 15 minutes. It'd also make sure that my setfocus would happen on the hour instead of some time after.

Any ideas? Has this already been discussed somewhere? If so let me know.

Thanks,

DD

[robrich22]

Just off the top of my head... Try the minute function. 1 hr = 60 minutes.. So 60 - Minute(Now()) would give you the minutes until the next hour and then set Form.TimerInterval = x mins * 60 seconds * 1000 milliseconds.. Timer Interval works on milli seconds.

[dcdimon]

That looks like it'll work.....thanks.

[dcdimon]

robrich22:

That worked perfectly. I totally blanked on how to determine the minutes left in the hour - I had been thinking about it for so long that your simply solution totally fell off my radar.

Thanks!