[AccessD] Convert To PDF Problem

Rocky,

Converting the same report or different one?  If different maybe this
report has no data or an error so can't export?

Rusty 

-----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
**********************************************************************
WARNING: All e-mail sent to and from this address will be received,
scanned or otherwise recorded by the CPI Qualified Plan Consultants, Inc.
corporate e-mail system and is subject to archival, monitoring or review 
by, and/or disclosure to, someone other than the recipient.
**********************************************************************