Stephan Lebans Print To Pdf - Memory Problem, Office 2000

[TimTDP]

I am using Stephan Leban's "Print To PDF" solution. www.lebans.com/reporttopdf.htm

On a form I have a list box of reports that I wish to print to PDF. The user selects the reports and the code loops through the selected reports and prints them to PDF

If the number of reports selected exceeds 600 (this figure varies and is not exact) I get memory related errors. Typically stating that there is insufficient memory to perform the operation.

How can I programatically release memory to prevent these errors? Typically after Stephan's code has generated the PDF.

Stephan refers to 2 dll files. How can I remove them from memory once I am finished with them?

 

[RuralGuy]

So you need *all* of these reports in ONE pdf file right?

 

[TimTDP]

No.
Each report will be its own. They are company invoices.
So each invoice will be its own pdf

 

[RuralGuy]

How much RAM does your machine have?

 

[TimTDP]

I think I have found the cause of the problem!

I stumbled across another forum where Stephan explains that including graphics in the report that needs to be converted to pdf can cause the memory problem.
to test this, I removed the graphic and the problem disappeared!
Although he does not state this, I think the problem occurs when generating the snapshot (which is later converted to pdf)

Stephan recommends turning off the Loading Image dialog. See www.mvps.org/access/api/api0038.htm

 

[RuralGuy]

Thanks for the update. I had not turned up anything yet in my research.

 

[Simon_MT]

The other alternative is pdf995 which creates a Printer to generate pdfs. I have used the Unpaid for version with Access 1997. The advantage is is just poke and print. There are other solutions Office 2007 comes with a downloadable version to print to PDF.

Simon