If this is your first visit, be sure to check out the FAQ by clicking the link above. You may have to register before you can post: click the register link above to proceed. To start viewing messages, select the forum that you want to visit from the selection below. |
|
|
Thread Tools | Display Modes |
#1
|
|||
|
|||
Automatically name a report when exporting to PDF
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 |
#2
|
|||
|
|||
Automatically name a report when exporting to PDF
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 |
Thread Tools | |
Display Modes | |
|
|