hi Tony,

On 16.03.2010 13:58, TonyWilliams via AccessMonster.com wrote:
Someone has asked me to create a database and include what they call a "push"
function that will automatically create an email to warn that a contract
renewal date is imminent. I believe that this can't be done in a desktop
application because although I can see how I can create the alert by running
a query against date parametrs, it still needs a trigger which I'm assuming
would be someone clicking a control button to run the query. I'm assuming
that what they want could only be achieved by creating the database on a
server and running a task say over night. I suppose one way would be to run
a query when the the Access application is opened? Am I right?
Partially. Basically you can do it all in Access. And you need the
correct 'trigger'. You can use the Scheduled Tasks to run Access at a
give time every day to do this.

http://technet.microsoft.com/en-us/l.../bb726974.aspx
http://support.microsoft.com/kb/209207

But sending E-Mail in such an task may be diffcult as it depends on your
mail system how to do it. It's not an beginner or intermediate task at all.


The better approach may be: Use Outlook and create calender/to-do
entries for these contracts to review.

mfG
-- stefan --