Report to PDF problem

[MF Scheetz]

I've got a form that gives users the option to select an individual report
(from a drop-down), or print all reports in one continuous report.

I'm using Sephen Lebans report to pdf code. (I love it!)

The coding I'm using is:
----------
For individual reports:
Private Sub lblCFReport_Click()
Dim blRet As Boolean
blRet = ConvertReportToPDF("rptConnFee2", vbNullString, Dist & ".pdf", False)
End Sub
-----------
For the combined reports
-----------
Private Sub cmdAllCFM_Click()
Dim blRet As Boolean
Dim blRet1 As Boolean
blRet = ConvertReportToPDF("rptConnFee-AllProp", vbNullString, "All
Districts Connection Fees.pdf", False)
blRet1 = ConvertReportToPDF("rptConnFee2-All", vbNullString, "All District
28 Connection Fees.pdf", False)
End Sub
(I have blRet and blRet1 because source data comes from different tables)
-----------

The everything worked fine until this morning. Now blRet in the combined
reports gives me the following error:
---------------
MSAccess: 2024
The report snapshot was not created because you don’t have enough free disk
space for temporary work files.
---------------
I click "ok" and blRet1 exports to PDF with no problems. I can open the
report in Access with no problems, but it won't export it to Acrobat.

The last page of the reports is a full page jpg located in an external folder.

Individual reports are either 2 or 4 pages
Combined report blRet is 48 pages
Combined report blRet1 is 8 pages

I'm using the most recent version of A2000ReportToPDF, v 2.753
(though the notes in the VB code says v 2.751)

I've got a similar report that is half as long (24 pages) as the combined
blRet, it expands on the same data and omits the jpg. This one exports to
PDF fine.

Code as follows:
-----------
Private Sub cmdAllSCM_Click()
Dim blRet As Boolean
Dim blRet1 As Boolean
blRet = ConvertReportToPDF("rptSCFee-AllProp", vbNullString, "All District
Service Charges.pdf", False)
blRet1 = ConvertReportToPDF("rptSCFee2-All", vbNullString, "All District 28
Service Charges.pdf", False)
End Sub
-----------

I've resorted to splicing the combined report into 3 separate reports and
having 3 PDFs where there used to be one. I hope to be able to make one PDF.

Any help is greatly appreciated.

-Matt

 

[Stephen Lebans]

I generally see that error message when you have illegal characters in the
path/filename.

--

HTH
Stephen Lebans
http://www.lebans.com
Access Code, Tips and Tricks
Please respond only to the newsgroups so everyone can benefit.

 

[MF Scheetz]

So you, too have no clue as to why this is happening?

As you can see, I've only got alpha numeric characters in the file names.

 

[Stephen Lebans]

Well since you are not supplying a full path I take it you are using the
current directory. Perhaps something has caused this current path to have
changed and you no longer have the necessary permissions to write to the
current folder. Supply a fully qualified path/filename to a folder you know
you have full permissions on.

--

HTH
Stephen Lebans
http://www.lebans.com
Access Code, Tips and Tricks
Please respond only to the newsgroups so everyone can benefit.