Wrox Programmer Forums
|
Access Discussion of Microsoft Access database design and programming. See also the forums for Access ASP and Access VBA.
Welcome to the p2p.wrox.com Forums.

You are currently viewing the Access section of the Wrox Programmer to Programmer discussions. This is a community of software programmers and website developers including Wrox book authors and readers. New member registration was closed in 2019. New posts were shut off and the site was archived into this static format as of October 1, 2020. If you require technical support for a Wrox book please contact http://hub.wiley.com
 
Old August 31st, 2005, 11:51 AM
Authorized User
 
Join Date: Aug 2005
Posts: 42
Thanks: 0
Thanked 0 Times in 0 Posts
Send a message via Yahoo to Dharam80
Default E-mailing reports

Hi.
I am trying to e-mail multiple reports to the manager, but it shows all the dates report. How can I make it possible to send only reports for cetain date. And I also down't know how to add function to make button send multiple reports at the same time.

Dharmesh Bhavsar
 
Old August 31st, 2005, 12:04 PM
Friend of Wrox
 
Join Date: Oct 2004
Posts: 564
Thanks: 0
Thanked 4 Times in 4 Posts
Default

This should be fairly simple, but I think you would need to do it with VBA. Are your familiar with VBA at all?

Mike
EchoVue.com
 
Old August 31st, 2005, 12:06 PM
Friend of Wrox
 
Join Date: Oct 2004
Posts: 564
Thanks: 0
Thanked 4 Times in 4 Posts
Default

And the second question is, how are the reports defined by date? Is it a naming convention that you are using or are the reports generated based on a query where the date is a variable?

Mike
EchoVue.com
 
Old August 31st, 2005, 12:15 PM
Authorized User
 
Join Date: Aug 2005
Posts: 42
Thanks: 0
Thanked 0 Times in 0 Posts
Send a message via Yahoo to Dharam80
Default

I'm sorry but i'm really bad at VBA and I knew I had to use it to make this possible. Well here is the thing I have reports showing all the dates, but when I send it, I want it to send report just for the date I would like. I know I can do that by setting parameters in query, but I don't want it to ask for date everytime I open the report unless I can just bypass parameters and have it show all the dates when parameter is bypassed.

Thanks for reply

Dharmesh Bhavsar
 
Old August 31st, 2005, 12:20 PM
Friend of Wrox
 
Join Date: Oct 2004
Posts: 564
Thanks: 0
Thanked 4 Times in 4 Posts
Default

Just so I have this all straight.

 - You have multiple reports that need to be emailed to a recipient.
 - The reports will need to be filtered when they are sent based on a date range.
 - You would all this to be done when you click a button.

Let me know if I missed anything, and I try get a possible solution put together for you.

Mike

Mike
EchoVue.com
 
Old August 31st, 2005, 12:21 PM
Friend of Wrox
 
Join Date: Oct 2004
Posts: 564
Thanks: 0
Thanked 4 Times in 4 Posts
Default

Are you using Outlook as your email Client?

Mike
EchoVue.com
 
Old August 31st, 2005, 12:25 PM
Authorized User
 
Join Date: Aug 2005
Posts: 42
Thanks: 0
Thanked 0 Times in 0 Posts
Send a message via Yahoo to Dharam80
Default

Yes I am.

Dharmesh Bhavsar
 
Old August 31st, 2005, 12:27 PM
Authorized User
 
Join Date: Aug 2005
Posts: 42
Thanks: 0
Thanked 0 Times in 0 Posts
Send a message via Yahoo to Dharam80
Default

And yes that is exectly what I want to do.

Thanks for Help In advance

Dharmesh Bhavsar
 
Old August 31st, 2005, 12:55 PM
Friend of Wrox
 
Join Date: Oct 2004
Posts: 564
Thanks: 0
Thanked 4 Times in 4 Posts
Default

This one is turning out to be a little trickier that I had prevously thought. It appears that you cannot filter a report to send as you would a report that you are viewing. Our options are then creating a dummy report and filtering the options into that report, or adding a filtering statement in the on_open event for the report that will fire only if your "Send Email to the Boss" form is open. I think that they latter would be easier, and I'll try send you some code as soon as I have it figured out.

Mike
EchoVue.com
 
Old August 31st, 2005, 01:51 PM
Authorized User
 
Join Date: Aug 2005
Posts: 42
Thanks: 0
Thanked 0 Times in 0 Posts
Send a message via Yahoo to Dharam80
Default

Thank You for you support Mike.



Dharmesh Bhavsar





Similar Threads
Thread Thread Starter Forum Replies Last Post
About Mailing List ssomchai BOOK: ASP.NET 2.0 Website Programming Problem Design Solution ISBN: 978-0-7645-8464-0 0 May 5th, 2008 10:05 PM
mailing manish_partey ASP.NET 1.0 and 1.1 Professional 1 April 25th, 2007 08:20 AM
Mailing prashanth_kumarbv Classic ASP Basics 2 October 27th, 2006 08:40 PM
E-mailing reports Brendan Bartley Access 5 June 26th, 2006 01:37 PM
SMTP not mailing...help! c_bananas .NET Web Services 5 November 17th, 2003 01:28 PM





Powered by vBulletin®
Copyright ©2000 - 2020, Jelsoft Enterprises Ltd.
Copyright (c) 2020 John Wiley & Sons, Inc.