Print report automatically

[ind]

How can print report automatically on the last date of the month???

 

[BattleDroid42]

Check this out:

http://www.mvps.org/access/modules/mdl0042.htm

 

[danvlas]

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 &quot;ReportName&quot;
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