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 April 15th, 2009, 05:44 AM
Friend of Wrox
 
Join Date: Jun 2005
Posts: 181
Thanks: 0
Thanked 0 Times in 0 Posts
Default Reminder To Send E-Mail

Hi All
I have a database that users send templates. I now need to put some code into these templates that if the template is not sent after 15 Min when opened the user will get a message to send the e-mail immediately

Thanks
__________________
Brendan Bartley
 
Old April 15th, 2009, 01:24 PM
Friend of Wrox
 
Join Date: Mar 2004
Posts: 3,069
Thanks: 0
Thanked 10 Times in 10 Posts
Default

What do you mean by "templates?"

If they are a form, for example, then you could have a hidden form launch when the template launches, and put an On Timer event to run after a 15 minute interval to pop up a message. Then on the template send e-mail event? Close the hidden form.

Without knowing what a template is or what events are firing, it is hard to tell what to suggest.
__________________
mmcdonal

Look it up at: http://wrox.books24x7.com
 
Old April 17th, 2009, 07:56 AM
Friend of Wrox
 
Join Date: Jun 2005
Posts: 181
Thanks: 0
Thanked 0 Times in 0 Posts
Default

The Templates are forms the problem is if I put a timer event this will effect all ten users who user the database
__________________
Brendan Bartley
 
Old April 17th, 2009, 03:24 PM
Authorized User
 
Join Date: Jul 2008
Posts: 38
Thanks: 1
Thanked 2 Times in 2 Posts
Default

Quote:
Originally Posted by Brendan Bartley View Post
The Templates are forms the problem is if I put a timer event this will effect all ten users who user the database
It should not IF (and this is a big IF) you have split the database (backend with tables on the server) and a COPY of the frontend on EACH user's machine. This is the way it SHOULD be set up for multi-user use.

See here for more about that:
http://members.shaw.ca/AlbertKallal/...plit/index.htm
__________________
Thanks,

Bob Larson
Access MVP (2008-2010, 2011)
Free Access tutorials, samples, tools





Similar Threads
Thread Thread Starter Forum Replies Last Post
Send mail and attachments with PHP mail function Lofa Beginning PHP 1 June 2nd, 2008 03:24 PM
send mail chavakoti BOOK: Professional SQL Server 2005 Integration Services ISBN: 0-7645-8435-9 1 September 4th, 2007 05:03 AM
Auto Reminder Mail... anees ASP.NET 2.0 Professional 1 May 31st, 2006 02:30 AM
Send E-mail meme2002bh Access ASP 2 September 30th, 2005 12:53 AM
Not able to send a mail hums .NET Framework 2.0 5 November 16th, 2004 03:56 AM





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