Exporting a report to a .pdf file????

[djmurphy58]

Is it possible to export a report to a .pdf file? I have a report that has some color in it. These color features do not show up when I export them using anyone of the file formats that Microsoft makes available. So I thought they'd probably show up if I can get them in a .pdf file.

Plus, I want to be able to email the reports to people......pdf files are easily opened from email.

Thanks

 

[SgtJarrow]

see faq703-2533

but pay heed to the notes about having to have adobe WRITER...

****************************
People think it must be fun to be a super genius, but they don't realize how hard it is to put up with all the idiots in the world. (Calvin from Calvin And Hobbs)

Robert L. Johnson III
MCSA, CNA, Net+, A+
w: rljohnso@stewart.com
h: wildmage@tampabay.rr.com

 

[djmurphy58]

Thanks for the info............what a great help.

But another question: What do I do with:


Anywhere you want to save a report, you will use:

Call SaveReportAsPDF("Name of Report", "Save Location&quot


I am a beginner Access user, so I do no know what I do with the "Call SaveReportAsPDF" statement. Where do I type this?

 

[SgtJarrow]

Create a command button. If you use the wizard pick anything. Click the button and find the OnClick property. Click the build button (ellipse) at the end of the line. Remove the code found in the button if you used the wizard. Add the line above.

Your code for any command button should be:



Private Sub cmdButton_OnClick()

Call SaveReportAsPDF("ReportName", "SaveLocation&quot

End Sub

****************************
People think it must be fun to be a super genius, but they don't realize how hard it is to put up with all the idiots in the world. (Calvin from Calvin And Hobbs)

Robert L. Johnson III
MCSA, CNA, Net+, A+
w: rljohnso@stewart.com
h: wildmage@tampabay.rr.com