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. |
|
|
Thread Tools | Display Modes |
#1
|
|||
|
|||
Schedule a Task in Access
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? |
#2
|
|||
|
|||
Schedule a Task in Access
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\....) -- Doug Steele, Microsoft Access MVP http://I.Am/DougSteele (no e-mails, please!) "Eric" wrote in message ... 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? |
Thread Tools | |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Thread Starter | Forum | Replies | Last Post |
Access 2002 vs. 2003 | Neil | General Discussion | 52 | February 16th, 2006 10:18 PM |
Can we import an Excel sheet to use as base for report? | StargateFan | New Users | 9 | November 4th, 2005 07:32 PM |
Encrypt AccesS File? | milest | General Discussion | 2 | February 9th, 2005 07:58 PM |
is Access 2003 any better than XP? | Gorb | General Discussion | 4 | November 11th, 2004 09:44 PM |
is Access 2003 any better than XP? | Gorb | Using Forms | 2 | November 11th, 2004 09:20 AM |