[AccessD] Send filtered report

Nancy,

I was going to suggest you write some code behind the E-Mail button to
run and save the filtered report by a different name and then e-mail
that report.  However, Stuart's suggestion is much simpler.

Charles Wortz
Software Development Division
Texas Education Agency
1701 N. Congress Ave
Austin, TX 78701-1494
512-463-9493
CWortz at tea.state.tx.us

-----Original Message-----
From: Stuart McLachlan [mailto:stuart at lexacorp.com.pg] 
Sent: Friday 2003 Apr 25 08:10
To: Nancy Lytle; accessd at databaseadvisors.com
Subject: Re: [AccessD] Send filtered report

]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