ReportToPDF - Access 2003

Thread view:

Enable EMail Alerts

Start New Thread

Thread rating:

nwulf@smbsc.com - 29 Sep 2006 17:46 GMT

Currently we output reports to pdf using a different product, and would
like to change it because some of the issues we are having. I came
across ReportToPDF by lebans.com and would like to try and use this
instead.

I'm using Access 2003 and some of my reports that I create require a
parameter sent to the report via OpenArgs of the docmd.openreport
event. Is it possible to send a parameter when outputting to a
snapshot file?

Looking through the help, etc, I don't see anything for this.

Some reports the users don't see a preview...it automatically outputs
to a pdf. I dont' want them to select snapshot when in preview...i
want to do it for them.

Any ideas? Thanks for the help.

Nick

Reply to this Message

Stephen Lebans - 29 Sep 2006 20:15 GMT

Albert just posted a solution to this issue:

Just open the report *first* with the restrictions...and *then* send to
pdf...

eg:

DoCmd.OpenReport strReportName, acViewPreview, , strWhere
Reports(strReportName).Visible = False

Call ConvertReportToPDF(strReportName, , strDocPDFName, False, False)

DoCmd.Close acReport, strReportName

*very* important to CLOSE the reprot after the above.....

Signature

Albert D. Kallal (Access MVP)
Edmonton, Alberta Canada
pleaseNOOSpamKallal@msn.com

--

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

> Currently we output reports to pdf using a different product, and would
> like to change it because some of the issues we are having. I came
[quoted text clipped - 15 lines]
>
> Nick

Reply to this Message

nwulf@smbsc.com - 29 Sep 2006 21:43 GMT

Very good. I will give that a try...makes perfect sense.

Nick

Reply to this Message