2008-05-15, 15:35 #1
- Join Date
- Jan 2001
- Thanked 0 Times in 0 Posts
send object question (access 2003)
I use the command below to created a report based on a query using the strwhere statement. This works great to filter ther report in line 1 but I want to send the same report filtered in an emai using sendobject. Is there a way I can filter the attached report using my strwhere statement? Thanks...
DoCmd.OpenReport "NSReschedules", acViewPreview, , strwhere, acNormal
DoCmd.SendObject acReport, "NSReschedules", , , , , , "test", "test2:", False, ""
Get our unique weekly Newsletter with tips and techniques, how to's and critical updates on Windows 7, Windows 8, Windows XP, Firefox, Internet Explorer, Google, etc. Join our 480,000 subscribers!
+ Get this BONUS — free!
Get the most of Excel! Learn about new features, basics of creating a new spreadsheet and using the infamous Ribbon in the first chapter of Excel 2013: The Missing Manual - Subscribe and download Chapter 1 for free!
2008-05-15, 16:09 #2
- Join Date
- Mar 2002
- Thanked 16 Times in 16 Posts
Re: send object question (access 2003)
You'll have to change the report's record source. You'll find some sample code in <post:=275,460>post 275,460</post:> that could be adapted for your purpose.
PS It would be nice if you acknowledged the replies to your questions, so that others know whether they were helpful.