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