Rocky Smolin 
      rockysmolin at bchacc.com
      
      Tue Feb 15 13:49:38 CST 2011
    
Dear List:
 
I implemented Lebans' ConvertReportToPDF and it worked really well to create
a report as a PDF.  Then I implemented in another place in the code.  And it
doesn't work.  Same Call.  Passing the same parameters.  I step through
Lebans' code line by line, watching all the variables.  When it gets to the
line 
 
    ' Export the selected Report to SnapShot format
    DoCmd.OutputTo acOutputReport, RptName, "SnapshotFormat(*.snp)", _
       strPathandFileName
 
it doesn't comes back to the next line.  And no SNP file is created.
 
The next line is:
 
    ' Make sure the process has time to complete
    DoEvents
Stepping through the code when called from the place I first used it it
steps just fine.  Does the output, creates the snp file and lights up the
DoEvents.
 
The header is to the module is:
 
Public Function ConvertReportToPDF( _
Optional RptName As String = "", _
Optional SnapshotName As String = "", _
Optional OutputPDFname As String = "", _
Optional ShowSaveFileDialog As Boolean = False, _
Optional StartPDFViewer As Boolean = True, _
Optional CompressionLevel As Long = 0, _
Optional PasswordOwner As String = "", _
Optional PasswordOpen As String = "", _
Optional PasswordRestrictions As Long = 0, _
Optional PDFNoFontEmbedding As Long = 0 _
) As Boolean
and the arguments passed to the routine are the same in both cases.
 
I am truly baffled - don't even have a clue what to test.
 
Any ideas, WAGs even, gratefully accepted. 
 
MTIA
 
Rocky Smolin
Beach Access Software
858-259-4334
Skype: rocky.smolin
www.e-z-mrp.com <http://www.e-z-mrp.com/> 
www.bchacc.com <http://www.bchacc.com/>