Rocky Smolin
rockysmolin at bchacc.com
Tue Feb 15 15:01:18 CST 2011
Dan: I changed Call ConvertReportToPDF("rptRentalAgreement", , strRAPDFName, , False) To Set db = CurrentDb Set rstQ = db.OpenRecordset("Select * FROM tblUser") Call ConvertReportToPDF("rptRentalAgreement", , strRAPDFName, , False) rstQ.Close Set rstQ = Nothing But to no avail. I do get the flash on the screen that says the snp is being created, then...nothing. It should create the PDF and then fall through to a message box that says "Rental Agreements exported." bit it doesn't. R -----Original Message----- From: accessd-bounces at databaseadvisors.com [mailto:accessd-bounces at databaseadvisors.com] On Behalf Of Dan Waters Sent: Tuesday, February 15, 2011 12:21 PM To: 'Access Developers discussion and problem solving' Subject: Re: [AccessD] Convert To PDF Problem Hi Rocky, For one place in my code where I use DoCmd.OutputTo I had to open some software object or the database window first. I opened a simple select query - then OutputTo did work. Then I closed the select query. This is a bug and is (or was) documented in KB244695, although it's hard to figure that out when you read it. HTH! Dan -----Original Message----- From: accessd-bounces at databaseadvisors.com [mailto:accessd-bounces at databaseadvisors.com] On Behalf Of Rocky Smolin Sent: Tuesday, February 15, 2011 1:50 PM To: 'Access Developers discussion and problem solving' Subject: [AccessD] Convert To PDF Problem 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/> -- AccessD mailing list AccessD at databaseadvisors.com http://databaseadvisors.com/mailman/listinfo/accessd Website: http://www.databaseadvisors.com -- AccessD mailing list AccessD at databaseadvisors.com http://databaseadvisors.com/mailman/listinfo/accessd Website: http://www.databaseadvisors.com