Lebans ReportToPDF ADP Usage

[eagles_losers]

Has anyone attempted to use the code from Lebans ReportToPDF within an
Access ADP file?

I tried:
- Moved Lebans functions and modules / classes into my ADP
- Changed the CurrenDB to CurrentConnection

Result:
- The PDF was created, but the annoying SaveAs Dialog box appears
now.

Has anyone successfully used Lebans ReportToPDF code within a an
Access ADP?

 

[Stephen Lebans]

I'm surprised it worked as it was not designed for this use.
I don't see how moving to ADP would cause the SaveAs Dialog window to
appear. YOu control whether this appears or not with a function parameter.
Step through the code and see why the Dialog is appearing.

--

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

 

[eagles_losers]

Hi Mr. Lebans,

Thank you so much for your reply. I promise to go through the steps
and test different scenarios thoroughly.

In my original posting above, I mistakenly said that I changed the
CurrentDB to CurrentConnection. What I meant to say was that I change
the "CurrentDB.name" to "CurrentProject.name". Sorry for that
misinformation.

I'll reply soon. Thanks again!

 

[krissco]

Hi Mr. Lebans,

Thank you so much for your reply. I promise to go through the steps
and test different scenarios thoroughly.

In my original posting above, I mistakenly said that I changed the
CurrentDB to CurrentConnection. What I meant to say was that I change
the "CurrentDB.name" to "CurrentProject.name". Sorry for that
misinformation.

I'll reply soon. Thanks again!

It sounds like the common dialog is being invoked. Try searching for
"clsCommonDialog" and debugging where it is used.

-Kris