You could create a mdb file containing only the report and the other objects for the report (queries and linked tables).
Paste this function into a module:
Function CheckThisDate
If Month(Date)<>Month(Date+1) Then
DoCmd.OpenReport "ReportName"
End If
Quit
End Function
Create a macro named AutoExec
Action: RunCode
FunctionName: CheckThisDate()
Save the macro
Close the database
Use Task Scheduler to open the database once a day.
Leave your computer on
Good luck
Daniel Vlas
Systems Consultant
danvlas@yahoo.com
This site uses cookies to help personalise content, tailor your experience and to keep you logged in if you register.
By continuing to use this site, you are consenting to our use of cookies.