Stephen Lebans has a function named ConvertReportTo PDF
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)", _
strPathandFileN ame
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.OpenRepor t 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?
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)", _
strPathandFileN ame
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.OpenRepor t 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?
Comment