Run Report 1

[yont11]

I have two reports which I want run automatically when I start my database. Once these reports are run I don't want them to run again on the same day if I exit the database and then start the database again. The code will have to be date based I believe and placed in the openform event in my start up form. Can anyone suggest some code to achieve this. Thanks.

 

[PHV]

Simply have a table storing the last date the reports are run.

Hope This Helps, PH.
Want to get great answers to your Tek-Tips questions? Have a look at FAQ219-2884 or FAQ181-2886

 

[yont11]

PHV can you point me in the right direction on the code to achieve this? Thanks.

 

[PHV]

Say you have a table (tblLastRun) with a single row and a single field (dteLastRun).
In the Open event procedure of your startup form:
If DLookUp("dteLastRun", "tblLastRun") < Date Then
DoCmd.RunSQL "UPDATE tblLastRun SET dteLastRun=Date()"
DoCmd.OpenReport ...
End If

Hope This Helps, PH.
Want to get great answers to your Tek-Tips questions? Have a look at FAQ219-2884 or FAQ181-2886

 

[yont11]

Thanks PHV.