# Timer control's interval more than 65,535 milliseconds

I want to do somethiing repeatly ... I plan to use a timer control in the VB. However, the maximum, 65,535 milliseconds, is equivalent to just over 1 minute. That's mean I can do something repeatly within 1 mins. Would somebody tells me how can I set the interval more than 1 mins ?
###### Who is Participating?
I wear a lot of hats...

"The solutions and answers provided on Experts Exchange have been extremely helpful to me over the last few years. I wear a lot of hats - Developer, Database Administrator, Help Desk, etc., so I know a lot of things but not a lot about one thing. Experts Exchange gives me answers from people who do know a lot about one thing, in a easy to use platform." -Todd S.

Commented:
u can do sumthg like this

declare a variable a
in form load a=0
in timer event
if a<10 then
a = a+1
else
a = 0
' what u want to do
end if

in this way ur timer will behave 10*timer inbterval time

do post if any doubt
Commented:
Something like:

sub timer1_timer()

static tim_count as integer

if tim_Count = 10 then
tim_count = 0
timer1.interval = 0
else
tim_count = tim_count + 1
end if

end sub
Author Commented:
Sorry The timer is not accurate enough ..... After I have set the value to a < 1000 . Would somebody pls help me ? Thanks.
Author Commented:
I want to use a timer that can input the time interval more than 1 hour.
High School Computer Science, Computer Applications, Digital Design, and Mathematics TeacherCommented:
You can use the wonderful function called DateDiff.

Here is a sample app I wrote to show how it works quite nicely.  Create a new project and place three labels and a timer control on it.  The first label will show the current time.  The second label will show total elapsed time since the program started.  The third label will show elapsed time since the last "event".

This type of scheme is not good for benchmarking apps in the millisecond range, but it works great for longer durations where that kind of accuracy doesn't matter.

The code is pretty self explanatory.  Hope it helps...and here it is:

Dim eventInterval As Long
Dim lastEventTime As Date
Dim initialTime As Date

' Set this value to the number of seconds you want inbetween your events
' It is a Long, so the max value is...
'  max val: 2,147,483,647 seconds
' or approx 35,791,394 minutes
' or approx 596,523 hours
' or approx 24,855 days
' or approx 68.10 years
eventInterval = 90

initialTime = Now()
lastEventTime = initialTime
Timer1.Interval = 250
End Sub

Private Sub Timer1_Timer()
Dim curTime As Date
Dim elapsed As Long

Dim elapsedSeconds As Long
Dim elapsedHours As Long
Dim elapsedMinutes As Long
Dim elapsedString As String

curTime = Now()

' update current time
Label1.Caption = Format(curTime, "Long Time")

' update total elapsed time
elapsed = DateDiff("s", initialTime, curTime)
' conversions to secs, mins and hrs...
elapsedSeconds = elapsed
elapsedHours = elapsedSeconds \ 3600
elapsedSeconds = elapsedSeconds - (elapsedHours * 3600)
elapsedMinutes = elapsedSeconds \ 60
elapsedSeconds = elapsedSeconds - (elapsedMinutes * 60)
elapsedString = Format(elapsedHours, "00") & ":" & _
Format(elapsedMinutes, "00") & ":" & Format(elapsedSeconds, "00")
Label2.Caption = elapsedString

' update elapsed time since last event
elapsed = DateDiff("s", lastEventTime, curTime)
' conversions to secs, mins and hrs...
elapsedSeconds = elapsed
elapsedHours = elapsedSeconds \ 3600
elapsedSeconds = elapsedSeconds - (elapsedHours * 3600)
elapsedMinutes = elapsedSeconds \ 60
elapsedSeconds = elapsedSeconds - (elapsedMinutes * 60)
elapsedString = Format(elapsedHours, "00") & ":" & _
Format(elapsedMinutes, "00") & ":" & Format(elapsedSeconds, "00")
Label3.Caption = elapsedString
If elapsed >= eventInterval Then
lastEventTime = curTime
' place a call to your "event" subroutine here
'
' <-----------------------
'
'
End If
End Sub

Commented:
Instead of taking the datediff in sec you can take it in mins or hour depending on the interval that ur looking at.....

Commented:
Use api timers.
Option Explicit

'In a module
Declare Function SetTimer Lib "user32" (ByVal hwnd As Long, ByVal nIDEvent As Long, ByVal uElapse As Long, ByVal lpTimerFunc As Long) As Long
Declare Function KillTimer Lib "user32" (ByVal hwnd As Long, ByVal nIDEvent As Long) As Long

Sub TimerProc(ByVal hwnd As Long, ByVal nIDEvent As Long, ByVal uElapse As Long, ByVal lpTimerFunc As Long)
Debug.Print "timer trigged!"
End Sub

'In a form
Option Explicit

Private Sub CmdStop_Click()
On Error Resume Next
'Kill our API-timer
KillTimer Me.hwnd, 0
End Sub

Dim mSeconds As String
mSeconds = InputBox("enter number of millisecond fro timer to trig (note: 3600000=1 hour")
If IsNumeric(mSeconds) Then
SetTimer Me.hwnd, 0, CLng(mSeconds), AddressOf TimerProc
End If
End Sub
Private Sub Form_Unload(Cancel As Integer)
On Error Resume Next
'Kill our API-timer
KillTimer Me.hwnd, 0

End Sub

Experts Exchange Solution brought to you by

Your issues matter to us.

Facing a tech roadblock? Get the help and guidance you need from experienced professionals who care. Ask your question anytime, anywhere, with no hassle.

Commented:
Commented:
A simple way of doing what you want is this:

Private Sub Pause(Duration As Long)
Dim Current As Long
Current = Timer

Do Until Timer - Current >= Duration
DoEvents
Loop
End Sub