By using this site, you agree to our updated Privacy Policy and our Terms of Use. Manage your Cookies Settings.
454,316 Members | 2,355 Online
Bytes IT Community
+ Ask a Question
Need help? Post your question and get tips & solutions from a community of 454,316 IT Pros & Developers. It's quick & easy.

Database capability question

P: n/a
I'm not really looking for a "how to" (although if someone would like to
send directions...)
In my work I sometimes OK purchase requisitions and in some of them I
require a document for environmental impacts. What I'd like to do is set up
a database to store these reqs with an "entry date" and have the database
automatically send me
an email when the requests have gotten say 2 weeks old. Is this doable?
Thanks,
T

Nov 13 '05 #1
Share this Question
Share on Google+
3 Replies


P: n/a
When it comes to storing dates and setting reminders, Outlook has built-in
capabilities that are much easier to use than building your own in Access.

"Tim K." <ti*****@cfl.rr.com> wrote in message
news:U9******************@tornado.tampabay.rr.com. ..
I'm not really looking for a "how to" (although if someone would like to
send directions...)
In my work I sometimes OK purchase requisitions and in some of them I
require a document for environmental impacts. What I'd like to do is set up a database to store these reqs with an "entry date" and have the database
automatically send me
an email when the requests have gotten say 2 weeks old. Is this doable?
Thanks,
T

Nov 13 '05 #2

P: n/a
"Automatically send me an e-mail" won't happen from Access unless the
database is open, and databases are rarely left open all the time. On the
other hand, it would be relatively easy to run a Report whenever you open
the database, using the current data to select, and reporting all those in a
particular date range.

Larry Linson
Microsoft Access MVP

"Tim K." <ti*****@cfl.rr.com> wrote in message
news:U9******************@tornado.tampabay.rr.com. ..
I'm not really looking for a "how to" (although if someone would like to
send directions...)
In my work I sometimes OK purchase requisitions and in some of them I
require a document for environmental impacts. What I'd like to do is set up a database to store these reqs with an "entry date" and have the database
automatically send me
an email when the requests have gotten say 2 weeks old. Is this doable?
Thanks,
T

Nov 13 '05 #3

P: n/a

"Larry Linson" <bo*****@localhost.not> wrote in message
news:EuDJd.19992$c%6.19162@trnddc03...
"Automatically send me an e-mail" won't happen from Access unless the
database is open, and databases are rarely left open all the time. On the
other hand, it would be relatively easy to run a Report whenever you open
the database, using the current data to select, and reporting all those in a particular date range.


That sounds like the way to go - thanks!
Nov 13 '05 #4

This discussion thread is closed

Replies have been disabled for this discussion.