468,770 Members | 2,143 Online
Bytes | Developer Community
New Post

Home Posts Topics Members FAQ

Post your question to a community of 468,770 developers. It's quick & easy.

Emulate 4th argument of OpenReport method in OutputTo method?

MLH
Stephen Lebans has a function named ConvertReportToPDF
that I use from time to time. It's quite handy, actually. In that
FN is a line that reads as follows:

DoCmd.OutputTo acOutputReport, RptName, "SnapshotFormat(*.snp)", _
strPathandFileName

I would like to use the OutputTo method in a way that might emulate
the OpenReport method's syntax - in particular, the 4th argument:

DoCmd.OpenReport reportname[, view][, filtername][, wherecondition]

"wherecondition" is a string expression - a valid
SQL WHERE clause without the word WHERE.

Is it remotely possible to feed a criteria something like the
OpenReport method's 4th argument supplies so I can
narrow down my report a bit?
Mar 26 '08 #1
1 1390
MLH
Thanks, Allen. Your solution worked
perfectly.
Mar 29 '08 #2

This discussion thread is closed

Replies have been disabled for this discussion.

Similar topics

42 posts views Thread by WindAndWaves | last post: by
1 post views Thread by paul.hanti | last post: by
14 posts views Thread by Eugeny Myunster | last post: by
1 post views Thread by CARIGAR | last post: by
1 post views Thread by Marin | last post: by
By using this site, you agree to our Privacy Policy and Terms of Use.