Re: Convert to PDF

Tech-Archive recommends: Repair Windows Errors & Optimize Windows Performance

Stephen's PDF solution includes the ability to merge PDF documents.

I wasn't aware of this. In fact, a week or so ago I thought someone had
tried to do this with no real look.


Indeed, the case I had in mind was through Acrobat setup as a printer rather
than the ReportToPDF modules. My apologies...

--
Jack Leach
www.tristatemachine.com

"I haven't failed, I've found ten thousand ways that don't work."
-Thomas Edison (1847-1931)



"Jack Leach" wrote:

Stephen's PDF solution includes the ability to merge PDF documents.

I wasn't aware of this. In fact, a week or so ago I thought someone had
tried to do this with no real look.

Good nice to know there is a way.

To the OP: disregard my post, apparently there is a way!
--
Jack Leach
www.tristatemachine.com

"I haven't failed, I've found ten thousand ways that don't work."
-Thomas Edison (1847-1931)



"Graham Mandeno" wrote:

Hi Jacinda

Stephen's PDF solution includes the ability to merge PDF documents. You
need to declare the following function:

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

When you process your first report (using ConvertUncompressedSnapshot),
specify the desired final PDF file as the output file.

Then, for the subsequent reports, specify a temporary file as the output
file, and then call MergePDFDocuments to append the result to the first one:

fResult = MergePDFDocuments(<final PDF name>, <temp file name>)
Kill <temp file name>

--
Good Luck :-)

Graham Mandeno [Access MVP]
Auckland, New Zealand

"Jacinda" <Jacinda@xxxxxxxxxxxxxxxxxxxxxxxxx> wrote in message
news:40B86D29-E8CE-4F72-B434-A01472F5996F@xxxxxxxxxxxxxxxx
Hi, I tried to post earlier but I don't think it went through...

I am using the following code:

http://www.lebans.com/reporttopdf.htm


it is working great, however I have a question. Is there anyway to
multi-select reports and have them run through the code via a loop or even
into one final PDF.

Any thoughts?


--
-Jacinda



.

Relevant Pages

  • Re: Convert to PDF
    ... Stephen's PDF solution includes the ability to merge PDF documents. ... specify the desired final PDF file as the output file. ... Then, for the subsequent reports, specify a temporary file as the output ...
    (microsoft.public.access.modulesdaovba)
  • RE: Print to PDF in VBA Code
    ... MM/DD/YYYY which I'm sure you're aware can't be a filename. ... "Jack Leach" wrote: ... The code prints a report, which will fire all applicable report events in ... Where do the printed PDF files go???? ...
    (microsoft.public.access.modulesdaovba)
  • Re: repeat: New version of Access doesnt support Jet
    ... you can easily right-click import Access Reports into SQL Server ... to PDF and does so without a pdf printer driver. ... I'd need PDF output from the hypothetical 'Access converted into VS ...
    (comp.databases.ms-access)
  • RE: Print to PDF in VBA Code
    ... so if I have on report load code, it will trigger prior to the ... PDF being made...cool. ... "Jack Leach" wrote: ... They should be going to the exact path you specify (actually, ...
    (microsoft.public.access.modulesdaovba)
  • Re: Attaching Embedded Objects to a Email in Access
    ... this be used for word, pdf, excel documents that are stored as objects in my ... It only works for Access reports. ... Public Function SendMail(strRecipients As String, strSubject As String, _ ... Dim strFileName As String ...
    (microsoft.public.access.formscoding)