OnClick_Btn to Macro for Windows Scheduler

[meg9222]

I inherited some MS Apps, that have a 'Run" button to manually run them. My job is to automate them. Im thinking of using Windows Scheduler which can "kick off" macros/modules. My question is how to convert a OnClick_btn to a macro.

Any help? Am I approaching this wrong? I've been trying to make Public Subs, Public Functions under the Module and Class Module, but not working yet. I'm in 2003 MS Access. Does the .SetFocus and .GetControl commands work here..?

Thank you so much (I'm a novice to this, obviously)!!!

[pbaldy]

Probably depends on the process, but what I do is create a public function in a standard module, and use the RunCode argument in a macro named autoexec to call it. If your existing process uses "Me." to refer to a form, that won't work in a standard module. You'd need the full form reference.