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/>