Report As of date name

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

Guest

I would like to have the the report name with the date it was run. I know
that when you export the report it will have the name that is listed in the
properties/Format/Caption for that report. So if it is the daily report the
name of the doc will be daily report. I would like to have it add the date
that the report was run. so it would save the Doc as Daily report for 1 Jan
05.

Thanks
 
You could try change the caption of the report in the On Open event of the
report:
Me.Caption = "Daily report for " & Format(Date(),"d mmm yy")
 
Duane, it did not work. I did it as you said and the report file was Daily
Report. That is the Report name.
 
I have set up the tool bar so that the user can just click the word Icon and
it sends it to a word Doc. It is the defalt word BTN I did not do any code.
 
I'm not sure that I have a way of saving this without trying to write some
code rather than use the button.
 
Think that I'm up for it. I know that I will need some help. I use the
DoCmd.SendObj now to send some Email's from Access thru Outlook. Is that what
I'm looking at?

And thanks for sticking with me on this!!!!
 
Back
Top