timer to start running module

[JNS]

I need to have a timer on a form so that a module runs every 24 hours to
retrieve new data.

 

[Albert D. Kallal]

I need to have a timer on a form so that a module runs every 24 hours to
retrieve new data.

The above means that your application would have to be loaded, and running
all the time. That takes up memory, resources, and furthermore, you have to
remember to keep the appcation loaded....even after reboots of the machines
etc.

A MUCH better approach would be to create a windows script that you place
into the windows scheduler and set that script to run once every 24 hours.

I explain here how to make a simple windows script that can call module code
of your choice.....
http://www.members.shaw.ca/AlbertKallal//BatchJobs/Index.html

The above windows scripts work well when run by the windows scheduler....

 

[JNS]

Thanks, this works great. I have another question. How do I open access and
then open an access form and run a command button click event on the form
using the vbscript method instead of a opening access and running a module?