scedule an access marco to run

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

Guest

Hi,

I am looking to schedule MSAccess to run a macro either by MSAccess itself
via VBA(preffered option) or via an external app.

Note the following;

1. MSAccess will already be running (so I don't want task schedular to run
msaccess.exe and call the AUTOEXEC macro to kick off a second macro).

2. I want to schedule MSAccess macro to run a macro (let's say myMacro) at
various times of the day. i.e. 10am, 11am and 12pm etc.

Any help appreciated.

Bruce
 
Hi,
you can either use windows task scheduler to start msaccess.exe my.mdb /x
mymacro

or, if application already running - use a hidden form with timer property
set to 60000 (one minute) and in timer event you check for current time and
run whatever you need

--
Best regards,
___________
Alex Dybenko (MVP)
http://alexdyb.blogspot.com
http://www.PointLtd.com
 
Back
Top