whojstall11
Registered User.
- Local time
- Today, 08:18
- Joined
- Sep 7, 2011
- Messages
- 94
I have a code that saves an report every time i click an button i have created. Can you tell me a way to have this report automatically save every 10 days. Without pressing an button.
PHP:
Dim stDocName As String
mystr = Format(Date, "dddd-mmmm-yyyy")
If Len(Dir("C:\Documents and Settings\JStallworth\Desktop\Reports" & mystr, vbDirectory)) = 0 Then MkDir "C:\Documents and Settings\JStallworth\Desktop\Reports" & mystr
stDocName = "Depreciation Report2"
DoCmd.OutputTo acOutputReport, stDocName, "RichTextFormat(*.rtf)", "C:\Documents and Settings\JStallworth\Desktop\Reports" & mystr & "\Depreciation Report2 " & Format(Now, "(hh-nn AMPM)") & ".rtf"