Thanks Stefan. I've had a look at Scheduled Tasks and it appears to run a
named application. Is it possible to create a task that runs a partricular
query in a specified database? Presumably the same would apply to using
Outlook in that Outlook would only alert that the task needs to be run but
owukdn't actually run the query?
Thanks
Tony

Stefan Hoffmann wrote:
hi Tony,

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
[quoted text clipped - 5 lines]
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 --

--
Why don't my grey cells communicate with each as fast as they used to? I hate
getting old!

Message posted via AccessMonster.com
http://www.accessmonster.com/Uwe/For...esign/201003/1