DoCmd,SendObj As of Date

  • Thread starter Thread starter Guest
  • Start date Start date
G

Guest

I have a report that the user sends in daily. I would like to put a time
stamp on the Report file name. I know that if I put a name in the Caption
section I get the file name from that. I tried to put in the following. =
Daily Report & [Date] but it did not work. Any help would be great!

Thanks
 
Save file "test" with todays date in name
="C:\test" & Format(Date(),"mmddyy") & ".xls"

Chris
 
You need to call code from your macro.
This will create a copy your original report and name it with the date
included in the new name.


Place this code in a new or existing module.

Public Function CopyAndRenameTheReport()

DoCmd.CopyObject "", "Daily Report For " & Date, acReport, "Daily
Report"

End Function


Macro
Action: RunCode
Function Name: CopyAndRenameTheReport()


Mike Schlosser
 
Back
Top