 |
| 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
|
|
|
|
August 31st, 2005, 11:51 AM
|
|
Authorized User
|
|
Join Date: Aug 2005
Posts: 42
Thanks: 0
Thanked 0 Times in 0 Posts
|
|
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
|
|
August 31st, 2005, 12:04 PM
|
|
Friend of Wrox
|
|
Join Date: Oct 2004
Posts: 564
Thanks: 0
Thanked 4 Times in 4 Posts
|
|
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
|
|
August 31st, 2005, 12:06 PM
|
|
Friend of Wrox
|
|
Join Date: Oct 2004
Posts: 564
Thanks: 0
Thanked 4 Times in 4 Posts
|
|
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
|
|
August 31st, 2005, 12:15 PM
|
|
Authorized User
|
|
Join Date: Aug 2005
Posts: 42
Thanks: 0
Thanked 0 Times in 0 Posts
|
|
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
|
|
August 31st, 2005, 12:20 PM
|
|
Friend of Wrox
|
|
Join Date: Oct 2004
Posts: 564
Thanks: 0
Thanked 4 Times in 4 Posts
|
|
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
|
|
August 31st, 2005, 12:21 PM
|
|
Friend of Wrox
|
|
Join Date: Oct 2004
Posts: 564
Thanks: 0
Thanked 4 Times in 4 Posts
|
|
Are you using Outlook as your email Client?
Mike
EchoVue.com
|
|
August 31st, 2005, 12:25 PM
|
|
Authorized User
|
|
Join Date: Aug 2005
Posts: 42
Thanks: 0
Thanked 0 Times in 0 Posts
|
|
Yes I am.
Dharmesh Bhavsar
|
|
August 31st, 2005, 12:27 PM
|
|
Authorized User
|
|
Join Date: Aug 2005
Posts: 42
Thanks: 0
Thanked 0 Times in 0 Posts
|
|
And yes that is exectly what I want to do.
Thanks for Help In advance
Dharmesh Bhavsar
|
|
August 31st, 2005, 12:55 PM
|
|
Friend of Wrox
|
|
Join Date: Oct 2004
Posts: 564
Thanks: 0
Thanked 4 Times in 4 Posts
|
|
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
|
|
August 31st, 2005, 01:51 PM
|
|
Authorized User
|
|
Join Date: Aug 2005
Posts: 42
Thanks: 0
Thanked 0 Times in 0 Posts
|
|
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 |
|
|
