Run report just once a month

[Humberto]

Hello, I'm trying to run a report once a day every first of the month when ever the database is open. My problem is that the database is opened more than once a day. How can I make the report just run once every month? Also, is there any way to export the report to a folder with the name of today's date?

any help will be appreciated.

 

[Brian900]

cant help with your first question but i'll try the second one. try this code behind a commandbutton on your form.

Private Sub CommandButton1_Click()

ToSave = Date

Docmd.OutputTo acReport, "YourReportName", "MicrosoftEcel(*.xls)", "C:\Windows\Desktop\" & ToSave &".xls

ToSave will equal the Current Date. Your result should be: 10-10-02.xls

Good Luck!

 

[NShafranski]

You could create a report log table that everytime the report has been printed logs the date with the report name to this folder. Then when everytime you open the DB it checks this log and if there's been one already printed for this month it will not print.