A Microsoft Office (Excel, Word) forum. OfficeFrustration

If this is your first visit, be sure to check out the FAQ by clicking the link above. You may have to register before you can post: click the register link above to proceed. To start viewing messages, select the forum that you want to visit from the selection below.

Go Back   Home » OfficeFrustration forum » Microsoft Access » Database Design
Site Map Home Register Authors List Search Today's Posts Mark Forums Read  

A "push" function to produce an email on an event



 
 
Thread Tools Display Modes
  #1  
Old March 16th, 2010, 01:58 PM posted to microsoft.public.access.tablesdbdesign
TonyWilliams via AccessMonster.com
external usenet poster
 
Posts: 117
Default A "push" function to produce an email on an event

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/For...esign/201003/1

  #2  
Old March 16th, 2010, 02:39 PM posted to microsoft.public.access.tablesdbdesign
Stefan Hoffmann
external usenet poster
 
Posts: 991
Default A "push" function to produce an email on an event

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 --
  #3  
Old March 16th, 2010, 06:50 PM posted to microsoft.public.access.tablesdbdesign
TonyWilliams via AccessMonster.com
external usenet poster
 
Posts: 117
Default A "push" function to produce an email on an event

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

  #4  
Old March 17th, 2010, 11:51 AM posted to microsoft.public.access.tablesdbdesign
Stefan Hoffmann
external usenet poster
 
Posts: 991
Default A "push" function to produce an email on an event

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/libr...ice.11%29.aspx
http://support.microsoft.com/kb/161088

and

http://www.everythingaccess.com/tuto...curity-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/libr...ice.11%29.aspx


mfG
-- stefan --
  #5  
Old March 17th, 2010, 12:42 PM posted to microsoft.public.access.tablesdbdesign
TonyWilliams via AccessMonster.com
external usenet poster
 
Posts: 117
Default A "push" function to produce an email on an event

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/libr...ice.11%29.aspx
http://support.microsoft.com/kb/161088

and

http://www.everythingaccess.com/tuto...curity-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/libr...ice.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/For...esign/201003/1

  #6  
Old March 30th, 2010, 11:57 AM posted to microsoft.public.access.tablesdbdesign
TonyWilliams via AccessMonster.com
external usenet poster
 
Posts: 117
Default A "push" function to produce an email on an event

At long last I've figured out the Scheduled Task procedure in Windows and now
have this as the command

"C:\Program Files\Microsoft Office\Office12\MSACCESS.EXE" "C:\Documents and
Settings\Owner\My Documents\TimeandBilling.accdb /X macinvoice"

However it doesn't work. When I look at the Scheduled Task it says Could not
start in the status.

Anyone help?
Thanks
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/libr...ice.11%29.aspx
http://support.microsoft.com/kb/161088

and

http://www.everythingaccess.com/tuto...curity-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/libr...ice.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/For...esign/201003/1

  #7  
Old March 30th, 2010, 01:02 PM posted to microsoft.public.access.tablesdbdesign
Stefan Hoffmann
external usenet poster
 
Posts: 991
Default A "push" function to produce an email on an event

hi Tony,

On 30.03.2010 12:57, TonyWilliams via AccessMonster.com wrote:
However it doesn't work. When I look at the Scheduled Task it says Could not
start in the status.

I see, you have the quotation marks wrong, it should be (without line
breaks and with correct spacing):

"C:\Program Files\Microsoft Office\Office12\MSACCESS.EXE"
"C:\Documents and Settings\Owner\My Documents\TimeandBilling.accdb"
/X macinvoice


mfG
-- stefan --
  #8  
Old March 31st, 2010, 06:58 PM posted to microsoft.public.access.tablesdbdesign
TonyWilliams via AccessMonster.com
external usenet poster
 
Posts: 117
Default A "push" function to produce an email on an event

Stefan this is what I've got now:
"C:\Program Files\Microsoft Office\Office12\MSACCESS.EXE"(space)"C:\Documents
and Settings\Owner\My Documents\TimeandBilling.mdb"(space)/X macinvoice

It's all one line with no breaks and there are spaces instead of the word
"space"

Although the Scheduled Task appears to be created I do get an error message
when I save it which says "error occured while attempting to to set task
account information specific error is 0x80070005 access is denied"

As I said the task is saved and I don't understand why I'm getting the
message because I'm logged on as the owner.

Still no joy :-(

Tony
Stefan Hoffmann wrote:
hi Tony,

However it doesn't work. When I look at the Scheduled Task it says Could not
start in the status.

I see, you have the quotation marks wrong, it should be (without line
breaks and with correct spacing):

"C:\Program Files\Microsoft Office\Office12\MSACCESS.EXE"
"C:\Documents and Settings\Owner\My Documents\TimeandBilling.accdb"
/X macinvoice

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

  #9  
Old March 31st, 2010, 07:28 PM posted to microsoft.public.access.tablesdbdesign
TonyWilliams via AccessMonster.com
external usenet poster
 
Posts: 117
Default A "push" function to produce an email on an event

Incidentally I did find a Microsft Knowledge Base article about the error
message and downloaded the hotfix but when I tried to install it I got a
message that said I didn't need it. Brick walls at every turn! LOL
Cheers
Tony

Stefan Hoffmann wrote:
hi Tony,

However it doesn't work. When I look at the Scheduled Task it says Could not
start in the status.

I see, you have the quotation marks wrong, it should be (without line
breaks and with correct spacing):

"C:\Program Files\Microsoft Office\Office12\MSACCESS.EXE"
"C:\Documents and Settings\Owner\My Documents\TimeandBilling.accdb"
/X macinvoice

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

  #10  
Old April 5th, 2010, 11:09 AM posted to microsoft.public.access.tablesdbdesign
TonyWilliams via AccessMonster.com
external usenet poster
 
Posts: 117
Default A "push" function to produce an email on an event

I solved it! There is a tick box in the Scheduled Task that says Run only if
logged on. By default this is unticked and should be ticked. I would have
thought it would have been more logical to have it the other way round?
Cheers
Tony

TonyWilliams wrote:
Incidentally I did find a Microsft Knowledge Base article about the error
message and downloaded the hotfix but when I tried to install it I got a
message that said I didn't need it. Brick walls at every turn! LOL
Cheers
Tony

hi Tony,

[quoted text clipped - 9 lines]
mfG
-- stefan --



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

Message posted via http://www.accessmonster.com

 




Thread Tools
Display Modes

Posting Rules
You may not post new threads
You may not post replies
You may not post attachments
You may not edit your posts

vB code is On
Smilies are On
[IMG] code is Off
HTML code is Off
Forum Jump


All times are GMT +1. The time now is 10:07 PM.


Powered by vBulletin® Version 3.6.4
Copyright ©2000 - 2024, Jelsoft Enterprises Ltd.
Copyright ©2004-2024 OfficeFrustration.
The comments are property of their posters.