[AccessD] Wake up Call Program

In the ontimer event for an open form, have some code that checks the 
current time against your trigger time. If it's not past that time, exit the 
timer event. Something like this;

    If Now() < dtNextUpdate Then
        Me!txtMessage = "Next automatic update will be attempted in " & 
DateDiff("n", Now(), dtNextUpdate) & " minutes at " & Format(dtNextUpdate, 
"h:nn:ss")
        Me.Repaint
        GoTo Exit_Form_Timer
    End If

After this If statment, put your code to make the call.  And you may also 
want to calculate the next trigger time and store that someplace so you 
don't keep calling over and over.

And just don't call ME with it!

Gary Kjos
garykjos at hotmail.com





>From: Ariel Computer <arielcom at indosat.net.id>
>Reply-To: Access Developers discussion and problem 
>solving<accessd at databaseadvisors.com>
>To: accessd at databaseadvisors.com
>Subject: [AccessD] Wake up Call Program
>Date: Sat, 17 Jan 2004 01:02:28 +0800
>
>Dear Friends,
>
>I really need some help for my problem :-(
>
>I want to create a small application that will dial a phone and play wav
>file to make a wake up call. I already found windows TAPI OCX to do this
>things. My problem just in timer event. Let say i have tblPhoneCall with
>this field :
>
>Date            Time        Extention
>01/01/04    14:00       100
>01/01/04    14:05       120
>
>How can i use ontimer event or other trick so when the current time equal 
>to
>tblphonecall.time the program will run phone dial function ?  Please help.
>
>Thank you very much !
>
>Hengky
>
>_______________________________________________
>AccessD mailing list
>AccessD at databaseadvisors.com
>http://databaseadvisors.com/mailman/listinfo/accessd
>Website: http://www.databaseadvisors.com

_________________________________________________________________
Get a FREE online virus check for your PC here, from McAfee. 
http://clinic.mcafee.com/clinic/ibuy/campaign.asp?cid=3963