Scheduling a form to print

[rosn459]

I need to schedule a report to print everynight at 5:45. How would I do this? I've gotten this so far:

Dim Start!
Start! = "17:45:00"
DoEvents
PrintForm

 

[SonOfEmidec1100]

One suggestion add a timer control with an interval of say 1000 then in the Timer1_Timer event add

Dim TempDate As Date
Const Start = "17:45:00"
Static LastRunDate As Date

TempDate = Date
If LastRunDate = TempDate Then Exit Sub
If Format(Time, "HH:nn:ss&quot >= Start Then
LastRunDate = TempDate
'
PrintForm
'
End If

 

[rosn459]

Son,

Thanks for the suggestion! I will give it a try!