Schedule a Task in Access

Thread view:

Enable EMail Alerts

Start New Thread

Thread rating:

Eric - 02 Mar 2006 17:01 GMT

Hello everyone, I did not know where to post this, so I apologize if it is in
the wrong form.

I am trying to schedule a task in Access 97/Win XP to be able to send a
email in Lotus Notes. I have the code for the Lotus Notes, but I am having a
hard time getting the Windows Scheduler to run a macro. I tried using the
path to my MDB plus x/ "macSendMail", but all it does is opens the database
and never fires the macro. Can anyone tell me what I am doing wrong?

Reply to this Message

Douglas J Steele - 02 Mar 2006 17:59 GMT

You need to include the path to msaccess.exe, not just the mdb and /x
switch.

The switch is actually for the executable, not the database. Unless you've
modified the default file association, switches get ignored when all you
have is the file in the shortcut.

Don't forget to put quotes around the full path to msaccess.exe, since it's
almost certainly going to have spaces in it (C:\Program Files\....)

Signature

Doug Steele, Microsoft Access MVP
http://I.Am/DougSteele
(no e-mails, please!)

> Hello everyone, I did not know where to post this, so I apologize if it is in
> the wrong form.
[quoted text clipped - 4 lines]
> path to my MDB plus x/ "macSendMail", but all it does is opens the database
> and never fires the macro. Can anyone tell me what I am doing wrong?

Reply to this Message