[AccessD] Send Filtered Report

Use a hidden form to hold the parameters and pass them to the report.

Doris Manning
Database Administrator
Hargrove Inc.
www.hargroveinc.com



-----Original Message-----
From: accessd-bounces at databaseadvisors.com
[mailto:accessd-bounces at databaseadvisors.com] On Behalf Of Anna Hopkins
Sent: Friday, January 07, 2005 7:40 PM
To: accessd at databaseadvisors.com
Subject: [AccessD] Send Filtered Report


I have spent too much time trying to learn how to send a filtered report.

I searched the archives and found an e-mail from someone who had the exact 
same problem...  But the solution does not work for me.  Here is the 
original stuff...


...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,
"<http://databaseadvisors.com/mailman/listinfo/accessd>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,
"<http://databaseadvisors.com/mailman/listinfo/accessd>nancy.lytle at 
auatac.com", , -1, "Weekly En Route Rpt"

Any ideas how to accomplish this?

N Lytle

The solution to Nancy's problem seemed to come from from Stuart McLachlan

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

..........................................................
Ok back to me...

The problem is that I open/print/would love to e-mail this report from 
several forms.

I tried to set the "On Open" Property of the report to a variable but can't 
seem to get that to work

I would like my employees to be able to click a button and e-mail a 
proposal or invoice.  This seems like it would be a very common need for 
people--any ideas?????  What am I missing?


-- 
AccessD mailing list
AccessD at databaseadvisors.com
http://databaseadvisors.com/mailman/listinfo/accessd
Website: http://www.databaseadvisors.com