filters

Hi -

If someone can help me with this, I would really appreciate it. What I want
to do is use excel to open an instance of access and export a report to my c
drive that has filters. My original code simply opens the report and prints
it out e.g.

OpenCurrentDatabase ("urizen.mdb")
DoCmd.OpenReport "Rpt1", acViewNormal, "Floor='10'"

but now i would like to just export it without printing it out, which i can
do with the following line of code:

DoCmd.OutputTo acOutputReport, "Rpt1", acFormatRTF, "c:\temp\Rpt1.rtf"

is there any way i can specify the filter using the OutputTo method?

Thanks.

You will have more luck getting this answer from the Access newsgroup
--
- K Dales


"LHaro" wrote:

> Hi -
>
> If someone can help me with this, I would really appreciate it. What I want
> to do is use excel to open an instance of access and export a report to my c
> drive that has filters. My original code simply opens the report and prints
> it out e.g.
>
> OpenCurrentDatabase ("urizen.mdb")
> DoCmd.OpenReport "Rpt1", acViewNormal, "Floor='10'"
>
> but now i would like to just export it without printing it out, which i can
> do with the following line of code:
>
> DoCmd.OutputTo acOutputReport, "Rpt1", acFormatRTF, "c:\temp\Rpt1.rtf"
>
> is there any way i can specify the filter using the OutputTo method?
>
> Thanks.
>
>