Using OutputTo with a report that has OpenArgs

Thread view:

Enable EMail Alerts

Start New Thread

Thread rating:

ExcelMan - 24 Dec 2005 21:30 GMT

I have a report that I want to output to a Word file. I have most of
the code working fine with a small exception. I want to pass a
parameter into the report, preferably using the OpenArgs argument. But
i don't know the syntax for launching a report with OpenArgs when I am
using the DoCmd.OutputTo command to run the report and save it as a
Word (.doc) file.

Does anyone know how to do this? Or any other approach that
accomplishes the objective.

Thanks.

Reply to this Message

david@epsomdotcomdotau - 25 Dec 2005 11:04 GMT

Open the form in preview mode before using OutPutTo.
(use Echo to turn off screen updates if you really don't
want to see the preview).

Or replace the OpenArgs with a value in a table, and use
the value from the table instead of OpenArgs

Or use a global variable (for example, a database property,
or a value on a form), instead of OpenArgs.

(david)

> I have a report that I want to output to a Word file. I have most of
> the code working fine with a small exception. I want to pass a
[quoted text clipped - 7 lines]
>
> Thanks.

Reply to this Message