create pdf programatically

[Tony]

I am using Access 2007. I want to add new menu item so that when clicked pdf
file will be automatically created and stored in particular location, i.e.
result.pdf to be stored in c:\temp directory. I know that it could be done by
opening report, clicking on print and selecting pdf printer but I would like
to make it working invisible for user. After clicking user will just received
message advising that the pdf file was created and is ready for collection.
Can this be done ? How ?

Thanks for help.

 

[Allen Browne]

Firstly, make sure you have the PDF add-in from Microsoft for A2007:
http://www.microsoft.com/downloads/...11-3E7E-4AE6-B059-A2E79ED87041&displaylang=en

You can then code like this:
strDoc = "Report1"
strFile = "C:\temp\result.pdf"
DoCmd.OutputTo acOutputReport, strDoc, acFormatPDF, strFile, True

 

[MPG]

Is there a way to print multiple reports to one pdf file?

 

[Alex Dybenko]

Hi,
you can use this function to merge 2 PDF documents, so at the end you will
get one PDF from several:

Private Declare Function MergePDFDocuments Lib "StrStorage.dll" (ByVal
PDFMaster As String, ByVal PDFChild As String) As Long

from StrStorage.dll, which you can get here:
http://www.lebans.com/reporttopdf.htm

--
Best regards,
___________
Alex Dybenko (MVP)
http://accessblog.net
http://www.PointLtd.com