[AccessD] Send filtered report

Stuart McLachlan stuart at lexacorp.com.pg
Fri Apr 25 08:10:20 CDT 2003


]How about basng the query underlying the report on the form 
parameters rather than filtering at the report level.


On 25 Apr 2003 at 6:57, Nancy Lytle wrote:

> I am using a form that lets users pick how to filter a report.  As it
> is now the user can preview the report or print it, but I would like
> to add the ability to email the filtered report.  However instead of
> sending the filtered report it sends the whole thing.
> 
> DoCmd.OpenReport strReportName, , , strWhere
> is what is used to open the report
> and
> DoCmd.SendObject acReport, strReportName, acFormatRTF,
> "nancy.lytle at auatac.com", , -1, "Weekly En Route Rpt"
> is used to send it.
> 
> So what I would like is similiar to:
> 
> DoCmd.SendObject acReport, strReportName(strWhere), acFormatRTF,
> "nancy.lytle at auatac.com", , -1, "Weekly En Route Rpt"
> 
> Any ideas how to accomplish this?
> 
> N Lytle
> 
> _______________________________________________
> AccessD mailing list
> AccessD at databaseadvisors.com
> http://databaseadvisors.com/mailman/listinfo/accessd
> Website: http://www.databaseadvisors.com


-- 
Lexacorp Ltd
http://www.lexacorp.com.pg
Information Technology Consultancy, Software Development,System 
Support.





More information about the AccessD mailing list