|
|
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
|
|
0
|
|
|
|
Reply
|
 shm135
|
6/7/2010 4:17:19 PM |
|
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
|
|
|
0
|
|
|
|
Reply
|
KenSheridan
|
6/7/2010 5:34:43 PM
|
|
|
1 Replies
980 Views
(page loaded in 0.035 seconds)
Similiar Articles: Automatically name a report when exporting to PDF - microsoft ...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, ... Code to export report to PDF automatically? - microsoft.public ...What DoCmd code can I use to export a report directly to PDF, optimized for printing, and have it prompt me for a new PDF name each time? Or if that... exporting to PDF issue - microsoft.public.access.reports ...Automatically name a report when exporting to PDF - microsoft ... Code to export report to PDF automatically? - microsoft.public ... exporting report to 1 ... Print A Report Automatically - microsoft.public.access.reports ...Automatically name a report when exporting to PDF - microsoft ... Hello, I have a form with a command button that opens my report in print preview mode in Access 2007. exporting report to 1 html page - microsoft.public.access.reports ...Automatically name a report when exporting to PDF - microsoft ... How to Export an MS Access Report to HTML | eHow.com Microsoft ... report to PDF automatically ... Printing report as PDF file in Access 2000 - microsoft.public ...Automatically name a report when exporting to PDF - microsoft ... Printing report as PDF file in Access 2000 - microsoft.public ... Automatically name a report when ... How to save ms access 2003 report to pdf? - microsoft.public ...Automatically name a report when exporting to PDF - microsoft ... However, this does not transfer over when I want to save my report to pdf. ... Export MS Access report to ... microsoft.public.access.reportsAutomatically name a report when exporting to PDF shm135 1 671 Hello, I have a form with a command button that opens my report in print preview mode in Access 2007. MS ACCESS REPORT EXPORT TO TEXT FILE - microsoft.public.access ...Automatically name a report when exporting to PDF - microsoft ... How can I make it so that when I click export to pdf/xps, the default file name is named after a text ... save as pdf in access 2007 - microsoft.public.access.formscoding ...Automatically name a report when exporting to PDF - microsoft ..... that opens my report in print preview mode in Access 2007. When I click the Export to PDF/XPS ... Automatically name a report when exporting to PDF - microsoft ...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, ... How to Export a Crystal Report to a PDF File | eHow.comCrystal is a delivery platform developed by Crystal Enterprise that stores customized report templates and is essentially an infrastructure for data access. Crystal ... Export Crystal Reports to PDF file - ASP.NET Server Controls ...In this tutorial, I will be showing you how to export a report to PDF format, but it can ... Select "Crystal Report". Enter the name of the report, I used the default name ... How to Export an Access Report as a PDF File | eHow.comClick "Save as" and select "PDF or XPS." Name your ... documents and e-books, PDF or Portable Document Format is an open format created by... How to Export a Crystal Report to ... Code to export report to PDF automatically? - microsoft.public ...What DoCmd code can I use to export a report directly to PDF, optimized for printing, and have it prompt me for a new PDF name each time? Or if that... 7/23/2012 3:50:45 PM
|
|
|
|
|
|
|
|
|
Search |
Post Question |
Groups |
Stream |
About |
Register
12 followers. 