Discussion Locked

How to Use Scheduler to Run an Access Re

0 helpful
1 reply
Closed to new repliesThis discussion is closed. It stays readable, but it takes no new replies.

I am trying to use Scheduler to run an Access Report. It does a nice job of opening up Access on a schedule, but I don't know how to use it to run a report.

I tried exporting a macro (*.bas) but it won't open. Help was no help. My knowledge ofVBA is very limited. Ideas?

1 reply

by karpi

Hello,

try starting access with the /x-Switch and a macro-name.

C:\...\MSACCESS.EXE MyDatabase.mdb /X MyMacro

when Access starts it will execute the Makro beside the other Start-Options.

HTH
Karpi

This discussion is closed to new replies.