Save as PDF

  • Thread starter Thread starter Chris641
  • Start date Start date
C

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
 
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
 
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/
 
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
Click to expand...

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

Q
 
SQL Server Reporting Services supports this.
and it's free.
Click to expand...

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/
 
I've downloaded Lebans' ReportToPDF system, how do I use this from within my
own database?
 
I've downloaded Lebans' ReportToPDF system, how do I use this from
within my own database?
Click to expand...
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
 
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.
 
Back
Top