TheCronus
The Ruler of Titans
- Local time
- Today, 11:30
- Joined
- Dec 11, 2004
- Messages
- 6
Hi,
I have a report of which record source is a query defined in my Queries.
I want to apply apply filter to the query before the command
DoCmd.OutputTo acReport, stDocName, acFormatXLS
I tried to open the report with the following command before sending the output
DoCmd.OpenReport "my_report_for_excel", acViewDesign, , , acHidden
Then wanted to modify the filter property.
But no sense...
Please show me the way...
Thx.
I have a report of which record source is a query defined in my Queries.
I want to apply apply filter to the query before the command
DoCmd.OutputTo acReport, stDocName, acFormatXLS
I tried to open the report with the following command before sending the output
DoCmd.OpenReport "my_report_for_excel", acViewDesign, , , acHidden
Then wanted to modify the filter property.
But no sense...
Please show me the way...
Thx.