Save as PDF

[Chris641]

G'day,

I was just wondering if there was a way to code a command button to save a
form/report as a PDF file?

Thanks in advance,

Chris

 

[Allen Browne]

I was just wondering if there was a way to code a command button to
save a form/report as a PDF file?

In Access 2007, you can download this add-in from Microsoft:
http://www.microsoft.com/downloads/...11-3E7E-4AE6-B059-A2E79ED87041&displaylang=en

For previous versions, use this one created by Stephen Lebans:
http://www.lebans.com/reporttopdf.htm

 

[Chris641]

Thanks Allen,

Would there be any way to perform the save via a command button though? Or
would it just have to be done manually through the Access menu?

Cheers

 

[Arvin Meyer [MVP]]

You could save a PDF printer as the specific printer for that report. Then
when the button was pushed that report would be created as a PDF. At one
time I experimented with changing printers in code, in response to an option
group, then changing it back to the default. I had it partially working, but
then the client started paying slowly, and I went on to other pursuits.

One other possibility is Steve Arbaugh's PDF and Mail Class, which can be
used to print or email PDFs:

http://www.groupacg.com/

 

[a a r o n . k e m p f]

SQL Server Reporting Services supports this.
and it's free.

 

[Bob Quintal]

Thanks Allen,

Would there be any way to perform the save via a command button
though? Or would it just have to be done manually through the
Access menu?

Cheers

Stephen Lebans' ReportToPDF utility can be called from a command
button with no problem.

Q

 

[Tony Toews [MVP]]

SQL Server Reporting Services supports this.
and it's free.

Note that Aaron's answer to just about every question is SQL Server
and ADPs. No matter how appropriate his answer.

Tony
--
Tony Toews, Microsoft Access MVP
Please respond only in the newsgroups so that others can
read the entire thread of messages.
Microsoft Access Links, Hints, Tips & Accounting Systems at
http://www.granite.ab.ca/accsmstr.htm
Tony's Microsoft Access Blog - http://msmvps.com/blogs/access/

 

[Chris641]

I've downloaded Lebans' ReportToPDF system, how do I use this from within my
own database?

 

[Bob Quintal]

I've downloaded Lebans' ReportToPDF system, how do I use this from
within my own database?

Extract the files from the .zip into a directory.
double-click the .mdb file to open it.
double-click the READMEFIRST form and read that,
then double-click the HowToUse form to open that and read what it
says about how to use.........

Q

 

[Chris641]

Done all that but its still not working for me... keeps saying that the
ConvertReportToPDF function is not defined, but i copied the code straight
from Lebans' system so I cant see what the difference is.