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 30 Mar 2010 06:57 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/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
From: Stefan Hoffmann on 30 Mar 2010 08:02 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 <--
From: TonyWilliams via AccessMonster.com on 31 Mar 2010 13:58 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/Forums.aspx/access-tablesdbdesign/201003/1
From: TonyWilliams via AccessMonster.com on 31 Mar 2010 14:28 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/Forums.aspx/access-tablesdbdesign/201003/1
From: TonyWilliams via AccessMonster.com on 5 Apr 2010 06:09
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 |