scedule an access marco to run

[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

 

[Alex Dybenko]

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