A "push" function to produce an email on an event
in [Tables]
|
Prev: help with database 2
Next: Sorting data
From: TonyWilliams via AccessMonster.com on 16 Mar 2010 08:58 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? Tony -- 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/Forums.aspx/access-tablesdbdesign/201003/1
From: Stefan Hoffmann on 16 Mar 2010 09:39 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/library/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 <--
From: TonyWilliams via AccessMonster.com on 16 Mar 2010 13:50 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/library/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/Forums.aspx/access-tablesdbdesign/201003/1
From: Stefan Hoffmann on 17 Mar 2010 06:51 hi Tony, On 16.03.2010 18:50, TonyWilliams via AccessMonster.com wrote: > 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? Take a look at the Access command-line options link. You can specify a macro to run. imho the better approach is to create an extra database (front-end) for that task. The task itself is started with the AutoExec macros Run Code action. In this called method you can now run your query to check whether you have to create E-Mails /or task items. This can be done by using Outlook automation: http://msdn.microsoft.com/en-us/library/aa209963%28office.11%29.aspx http://support.microsoft.com/kb/161088 and http://www.everythingaccess.com/tutorials.asp?ID=Outlook-Send-E-mail-Without-Security-Warning > 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? http://msdn.microsoft.com/en-us/library/aa209963%28office.11%29.aspx mfG --> stefan <--
From: TonyWilliams via AccessMonster.com on 17 Mar 2010 07:42
Thanks again Stefan, this is getting a little beyond my level of expertise so I will need some time to study the content of those links. Thanks again Cheers tony Stefan Hoffmann wrote: >hi Tony, > >> 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? >Take a look at the Access command-line options link. You can specify a >macro to run. > >imho the better approach is to create an extra database (front-end) for >that task. The task itself is started with the AutoExec macros Run Code >action. > >In this called method you can now run your query to check whether you >have to create E-Mails /or task items. This can be done by using Outlook >automation: > >http://msdn.microsoft.com/en-us/library/aa209963%28office.11%29.aspx >http://support.microsoft.com/kb/161088 > >and > >http://www.everythingaccess.com/tutorials.asp?ID=Outlook-Send-E-mail-Without-Security-Warning > >> 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? > >http://msdn.microsoft.com/en-us/library/aa209963%28office.11%29.aspx > >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/Forums.aspx/access-tablesdbdesign/201003/1 |