TImer Event not stopping

  • Thread starter Thread starter Gina
  • Start date Start date
G

Gina

I want the TimerInterval to reach 1000 (1 second), Call RefDates and then
stop. I know I'm tired so be gentle as to why this is not working.

If Me.TimerInterval = 1000 Then
Call RefDates
Else
Me.TimerInterval = 0
End If

Thanks guys!
 
Gina said:
I want the TimerInterval to reach 1000 (1 second), Call RefDates and then
stop. I know I'm tired so be gentle as to why this is not working.

If Me.TimerInterval = 1000 Then
Call RefDates
Else
Me.TimerInterval = 0
End If
Click to expand...


Just set it to 1000 and then have two lines.

Call RefDates
Me.TimerInterval = 0
 
Gina said:
Rick... not working the Call RefDates not executing. (Heh, that's 50/50 not
bad) 8-)
Click to expand...

Have you tried putting in a break-point and stepping through the code manually?
I can't see any reason why the call statement would not run.
 
My mistake it's running but too fast perhaps I should explain... the form
opens you click the tab page (by then the code has run). I guess what I
want to do is loop it and run for 1 second pause and run when the tab page
is selected again. I think I may have to revisit this tomorrow because I
know I should be to stop and start this Timer but I can either keep it
running or stop it from running. Or as your code suggestion does run it for
a short period of time.
 
Oops.. that 2 out of 2 8-)


Rick Brandt said:
Have you tried putting in a break-point and stepping through the code manually?
I can't see any reason why the call statement would not run.
Click to expand...
 
Back
Top