Solved

Timer control's interval more than 65,535 milliseconds

Posted on 2003-10-26
10
1,394 Views
Last Modified: 2008-02-01
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 ?
0
Comment
Question by:mikekwok
  • 2
  • 2
  • 2
  • +4
10 Comments
 
LVL 3

Expert Comment

by:pg_india
Comment Utility
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
0
 
LVL 7

Expert Comment

by:_agj_
Comment Utility
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
0
 

Author Comment

by:mikekwok
Comment Utility
Sorry The timer is not accurate enough ..... After I have set the value to a < 1000 . Would somebody pls help me ? Thanks.
0
 

Author Comment

by:mikekwok
Comment Utility
I want to use a timer that can input the time interval more than 1 hour.
0
 
LVL 85

Expert Comment

by:Mike Tomlinson
Comment Utility
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

Private Sub Form_Load()
    ' 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
 
0
How to run any project with ease

Manage projects of all sizes how you want. Great for personal to-do lists, project milestones, team priorities and launch plans.
- Combine task lists, docs, spreadsheets, and chat in one
- View and edit from mobile/offline
- Cut down on emails

 
LVL 3

Expert Comment

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

0
 
LVL 5

Accepted Solution

by:
Cimperiali earned 50 total points
Comment Utility
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


Private Sub Form_Load()
    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


0
 
LVL 9

Expert Comment

by:Dang123
Comment Utility
0
 

Expert Comment

by:vbwizardxxx
Comment Utility
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

Private Sub Form_Load()
' will pause x milliseconds
Pause(x)
End Sub
0
 

Expert Comment

by:vbwizardxxx
Comment Utility
sorry, Pause(x) will pause x seconds :P
0

Featured Post

What Should I Do With This Threat Intelligence?

Are you wondering if you actually need threat intelligence? The answer is yes. We explain the basics for creating useful threat intelligence.

Join & Write a Comment

The debugging module of the VB 6 IDE can be accessed by way of the Debug menu item. That menu item can normally be found in the IDE's main menu line as shown in this picture.   There is also a companion Debug Toolbar that looks like the followin…
Background What I'm presenting in this article is the result of 2 conditions in my work area: We have a SQL Server production environment but no development or test environment; andWe have an MS Access front end using tables in SQL Server but we a…
Get people started with the process of using Access VBA to control Outlook using automation, Microsoft Access can control other applications. An example is the ability to programmatically talk to Microsoft Outlook. Using automation, an Access applic…
This lesson covers basic error handling code in Microsoft Excel using VBA. This is the first lesson in a 3-part series that uses code to loop through an Excel spreadsheet in VBA and then fix errors, taking advantage of error handling code. This l…

744 members asked questions and received personalized solutions in the past 7 days.

Join the community of 500,000 technology professionals and ask your questions.

Join & Ask a Question

Need Help in Real-Time?

Connect with top rated Experts

16 Experts available now in Live!

Get 1:1 Help Now