ReportToPDF - Access 2003

[nwulf]

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

 

[Stephen Lebans]

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.....


--
Albert D. Kallal (Access MVP)
Edmonton, Alberta Canada
(e-mail address removed)



--

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

 

[nwulf]

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

Nick