I have never heard of this issue before today. A few weeks ago I added a
Merge function to the ReportToPDF solution. During the testing phase I did
not run into any issues with the resultant merged PDF document.
I just tested merging two ReportToPDF generated PDF documents manually via
Adobe and the process worked as expected without any errors.
Can you post the code you are using to merge two PDF docs?

Signature
HTH
Stephen Lebans
http://www.lebans.com
Access Code, Tips and Tricks
Please respond only to the newsgroups so everyone can benefit.
Hi Stephen,
As I say, I works well on other computers. Its probably related to the
version of Acrobat API which is 5.0 on the one that doesn't work. It seems to
work with Acrobat 7.
In any case, I gather that you are the author of the strStorage.dll that is
included with ReportToPDF. If so, can you tell me if the value of the
ConvertUncompressedSnapshot PDFNoFontEmbedding parameter should be to fully
imbed all the fonts as Adobe suggests. Perhaps it might help. I've tried 0, 1
and -1 so far. (-1 seems to have the same effect as 1).
Here is the Acrobat merge code you requested.
Function Merge()
Dim objAcroApp As Acrobat.CAcroApp
Dim objAcroDoc As Acrobat.CAcroPDDoc
Dim objAcroDocSrc As Acrobat.CAcroPDDoc
Dim lngRetVal As Long
Dim i As Long
Dim lngPage As Long
Set objAcroApp = CreateObject("AcroExch.App")
Set objAcroDoc = CreateObject("AcroExch.PDDoc")
Set objAcroDocSrc = CreateObject("AcroExch.PDDoc")
lngRetVal = objAcroDoc.Open(colDOCS.Item(1))
lngPage = objAcroDoc.GetNumPages
For i = 2 To colDOCS.Count
lngRetVal = objAcroDocSrc.Open(colDOCS.Item(i))
Merge = objAcroDoc.InsertPages((lngPage - 1), objAcroDocSrc, 0,
objAcroDocSrc.GetNumPages, False)
lngPage = lngPage + objAcroDocSrc.GetNumPages
objAcroDocSrc.Close
Next i
objAcroDoc.CreateThumbs 0, lngPage - 1
Merge = objAcroDoc.Save(PDSaveFull, strDestination)
objAcroDoc.Close
objAcroApp.Exit
If Not objAcroApp Is Nothing Then Set objAcroApp = Nothing
If Not objAcroDoc Is Nothing Then Set objAcroDoc = Nothing
If Not objAcroDocSrc Is Nothing Then Set objAcroDocSrc = Nothing
End Function
By the way, the ReportToPDF is a great help to me and I suspect any Access
developer who needs to send a report to PDF. I thank you for that and for
your interest in this issue.

Signature
RobGMiller
> I have never heard of this issue before today. A few weeks ago I added a
> Merge function to the ReportToPDF solution. During the testing phase I did
[quoted text clipped - 45 lines]
> >
> > Thanks
Stephen Lebans - 09 May 2008 03:34 GMT
It sounds like an Adobe version issue. As for Font embedding here is a
previous post of mine on this subject:
There was a bug introduced for Font Embedding in the last release.
At the top of your modReportTOPDF module is the function signature:
Public Declare Function ConvertUncompressedSnapshot Lib "StrStorage.dll" _
(ByVal UnCompressedSnapShotName As String, _ ByVal OutputPDFname As String,
_ Optional ByVal CompressionLevel As Long = 0, _ Optional ByVal
PasswordOwner As String = "", _ Optional ByVal PasswordOpen As String = "",
_ Optional ByVal PasswordRestrictions As Long = 0, _ Optional
PDFNoFontEmbedding As Long = 0 _
) As Boolean
The very last line of the Sig is missing the ByVal declaration:
Optional PDFNoFontEmbedding As Long = 0 _
Should be changed to:
Optional ByVal PDFNoFontEmbedding As Long = 0 _

Signature
HTH
Stephen Lebans
http://www.lebans.com
Access Code, Tips and Tricks
Please respond only to the newsgroups so everyone can benefit.
> Hi Stephen,
>
[quoted text clipped - 110 lines]
>> >
>> > Thanks
RobGMiller - 09 May 2008 04:16 GMT
I did read about that and corrected it but it made no difference.
I am guessing that even though PDFNoFontEmbedding is declared as a long it
is treated as a boolean? Meaning the choices are (0) or (-1). In that case,
neither one produced a file that can consistently be merged by, (lets say
probably), Acrobat 5.
Will you be releasing the merge functionality under the same licensing
arrangement as the previous release of ReportToPDF code?
If so, I am looking forward to trying it out.
Thanks again for your help Stephan.

Signature
RobGMiller
> It sounds like an Adobe version issue. As for Font embedding here is a
> previous post of mine on this subject:
[quoted text clipped - 133 lines]
> >> >
> >> > Thanks