Tek-Tips is the largest IT community on the Internet today!

Members share and learn making Tek-Tips Forums the best source of peer-reviewed technical information on the Internet!

  • Congratulations biv343 on being selected by the Tek-Tips community for having the most helpful posts in the forums last week. Way to Go!

Print report automatically

Status
Not open for further replies.

ind

Programmer
Mar 9, 2000
121
US
How can print report automatically on the last date of the month???
 
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 [smile]

Good luck
[pipe]
Daniel Vlas
Systems Consultant
danvlas@yahoo.com
 
Status
Not open for further replies.

Part and Inventory Search

Sponsor

Back
Top