Automatically name a report when exporting to PDF
in [Reports]
|
Prev: stLinkcriteria no longer working (since 2007 upgrade)
Next: Crosstab Graph Report not showing Parameters in text box
From: shm135 on 7 Jun 2010 12:17 Hello, I have a form with a command button that opens my report in print preview mode in Access 2007. When I click the Export to PDF/XPS button, the default file name is the name of the actual report within Access. I've used VBA to change the report caption to match a field on my form called PROGRAM. However, this does not transfer over when I want to save my report to pdf. How can I make it so that when I click export to pdf/xps, the default file name is named after a text box called PROGRAM? Please let me know. Thanks
From: KenSheridan via AccessMonster.com on 7 Jun 2010 13:34
I think you'd have to code a command button to do it, using the OutPutTo method of the DoCmd object. Check out the method in Help for more details. Ken Sheridan Stafford, England shm135 wrote: >Hello, > >I have a form with a command button that opens my report in print >preview mode in Access 2007. When I click the Export to PDF/XPS >button, the default file name is the name of the actual report within >Access. I've used VBA to change the report caption to match a field on >my form called PROGRAM. However, this does not transfer over when I >want to save my report to pdf. > >How can I make it so that when I click export to pdf/xps, the default >file name is named after a text box called PROGRAM? > >Please let me know. > >Thanks -- Message posted via http://www.accessmonster.com |