PC Review


Reply
Thread Tools Rate Thread

Automatically name a report when exporting to PDF

 
 
shm135
Guest
Posts: n/a
 
      7th Jun 2010
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
 
Reply With Quote
 
 
 
Reply

Thread Tools
Rate This Thread
Rate This Thread:

Posting Rules
You may not post new threads
You may not post replies
You may not post attachments
You may not edit your posts

BB code is On
Smilies are On
[IMG] code is On
HTML code is Off
Trackbacks are On
Pingbacks are On
Refbacks are Off


Similar Threads
Thread Thread Starter Forum Replies Last Post
Report exporting different data from what is on the report sk Microsoft Access Reports 1 29th Apr 2010 07:02 PM
Exporting a report with group to excel same as Crystal Report. Marjaneh Microsoft Access Reports 1 29th Dec 2007 06:14 AM
Exporting VB Forms Automatically aVBgrad Microsoft Excel Programming 2 14th Dec 2005 04:52 PM
Automatically Exporting Public Folders to PST Dan L Microsoft Outlook VBA Programming 0 18th Aug 2004 02:41 AM
Exporting Automatically Paul Kaye Microsoft Outlook VBA Programming 1 28th May 2004 03:36 PM


Features
 

Advertising
 

Newsgroups
 


All times are GMT +1. The time now is 11:20 PM.