[AccessD] Re: Alternatives to docmd.outputto

John,

Use a 2 query system.

Query_01  has your basic SQL Statement without the WHERE clause.
Query_02 is the one you replace the SQL Statement in with one you build.

The report is based on the Query_02.

This will work very fast.

Robert

At 10:29 PM 12/4/2003 -0600, you wrote:
>Date: Thu, 4 Dec 2003 23:06:16 -0500
>From: "John W. Colby" <jcolby at colbyconsulting.com>
>Subject: [AccessD] Alternatives to docmd.outputto
>To: "AccessD" <AccessD at databaseadvisors.com>
>Message-ID: <DCEFJAOENMNENLAAOFGPMEGGFPAA.jcolby at colbyconsulting.com>
>Content-Type: text/plain;       charset="iso-8859-1"
>
>I just noticed that this method of creating a file from a report doesn't
>have a property for filters for the report.  I have a reporting system that
>builds up a complex filter then opens the report and applies the filter.
>Obviously I can't do this with the docmd.outputto.  Any alternatives that
>will allow me to (for example) output a normal report (with the filter
>applied) to a rtf/snapshot/excel file etc.?
>
>John W. Colby
>www.ColbyConsulting.com