Auto weekly and number reports

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

Guest

How do I set up a report to automatically run every Monday morning for Monday
through Sunday of each week.

Also, How do I set up a report to automatically run on the last day of each
month?
 
There really isn't a way that you can automate this to guarantee that it is
printed from Access since it doesn't have a scheduling component.

In the past, when I have had requirements where certain things needed to be
done by a certain day or time, I have written functions that check for these
requirements in the Form_Load sub of the first screen that opens (i.e. your
Main Menu/Dashboard).

You can write a function that checks for your date requirement (either the
monday morning or last day of the month) and if it returns true, then perform
a DoCmd.RunReport.

Unfortunately this requires that your users are starting the application on
these days so that the check fires in the first place.

If you decide to go this way, you can view the following reference to
determine if the current date is the last day of the month.

http://www.mvps.org/access/datetime/date0007.htm

If you want to check if the current date is a Monday you can use:

If Weekday(Date) = vbWednesday Then
MsgBox "True"
End If

Hope that helps somewhat.

Lance
 
Back
Top