Timer

  • Thread starter Thread starter Luca
  • Start date Start date
L

Luca

Is there a way to set up a timer that automatically sends
a report on the 5th day of each month?
 
You can make quasi-timer.

When You open your database, you can set default prcedure to find out which day is today:
1) in AutoExec macro
2) in load procedure for form

Private Sub Form1_Load()

Select Case DatePart("d", Date)
Case 5
MsgBox "Time to send report!", vbInformation, Date
Case Else
MsgBox "Have a nice day!", vbInformation, Date
End Select

End Sub
 
Back
Top