macro

  • Thread starter Thread starter Joel Allen
  • Start date Start date
J

Joel Allen

Hello,

I need to run a macro every hour but don't know how. My goal is to just
have this macro run every hour, but not have to have the database open. If
I have to have it open, then fine, but I'd rather not.

Thanks for your help,
Joel
 
Joel,

If the application is open, you can have a form (hidden, perhaps), whose
Timer Interval property is set to 3600000 (milliseconds in an hour).
Then you can assign the macro on the Timer event of the form.

If the application is not open, you will need to use Windows Task
Manager, or some third-party scheduling utility, to run a scheduled
task. The Command Line of the scheduler will proabably look like this...
"C:\Program Files\Miscrosoft Office\Msaccess.exe"
"C:\YourFolder\YourDb.mdb" /x NameOfMacro
 
Thanks. When I go to Windows Task Magager, I don't see any options for
scheduling tasks like that or a Command Line. Can you please help me just a
little further?

Thanks,
Joel
 
Joel,

With Windows XP Pro, you can do like this...

1. Start=>All Programs=>Accessories=>System Tools=>Scheduled Tasks
2. Right-Click=>New=>Scheduled Task
3. Double-Click 'New Task', and set properties as required - Command
Line as mentioned before goes in "Run" box.
 
I put this line in ther and it said it could not run it. Do you see
aproblem with the syntax perhaps?

"C:\Documents and Settings\All Users\Start Menu\Programs\Microsoft
Office\Microsoft Office Access 2003.lnk""W:\Company Documents-Public\PM
Department\PMTool Web Link\PMTool_Web_Access.mdb\MakeTable"

Thanks again,
Joel
 
Joel,

Yes, there are a numberr of problems here...

As per my original example:
1. The application has to point to the Access executable, not a
shortcut icon, which is what you appear to have done.
2. There has to be a space between the two components of the command line.
3. You need to use the /x switch to indicate the macro.

So, something like this...
"C:\Program Files\Microsoft Office\Office11\Msaccess.exe" "W:\Company
Documents-Public\PM Department\PMTool Web Link\PMTool_Web_Access.mdb" /x
MakeTable
 
Back
Top