how can I run set up the macro to run overnight by itself.

  • Thread starter Thread starter Guest
  • Start date Start date
G

Guest

I have created a report.
Data becomes available on the server too late 10 PM.
I need to set up the macro, so it would run overnight by itself.

!
 
Hi,
you can set windows task scheduler to run msaccess.exe your.mdb /x yourmacro
at certain time.

yourmacro should run your report or whatever you need to run
 
Alex said:
Hi,
you can set windows task scheduler to run msaccess.exe your.mdb /x yourmacro
at certain time.

yourmacro should run your report or whatever you need to run
Click to expand...

Alex has provided you with the most common method; use the Windows Scheduler to start
Access using the command line option /x to run a macro that you name. That macro can, for
example, open a report and print it. However, if your printer is on a network you may need
to specify a user account with sufficient privileges to print.
 
Back
Top