Reminder for every sunday and every last of the month

  • Thread starter Thread starter Guest
  • Start date Start date
G

Guest

Hi, need help on the following subject:
I have a for for the users to generate repots daily, weekly and monthly,
unfortunately users seem to forget to generate the weekly reports, so I
thought about creating a reminder that would remind users to generate the
weekly a reports every sunday, and to generate the monthly report every last
of the month.
I was thinking of putting some code behind the daily report button, that
would check to see if its is sunday and alerts the user to generate the
weekly report, and that checks to see if it is the last day of the month and
alerts the user to generate the monthly report.
Thaks for the help.
 
Hi,
on the on close event of your daily report you can add this code

if weekday(now())= vbsunday then ' today is sunday
msgbox "Remember to print also the weekly report",48,"The title of the
msgbox"
end if
if day(now()+1)= 1 then ' today is the last day of the month
msgbox "Remember to print also the monthly report",48,"The title of the
msgbox"
end if

HTH Paolo
 
Back
Top