how can i get a module to run automatically on a schedule?

[Nancy Drew]

hi all

i'm trying to figure out how to get a module to run automatically on a daily
basis. is it possible to have a scheduled tasks start up access and call the
module? if not, is it possible to have a visual basic app do this?

tks

 

[Guest]

One way would be to create an AutoExec macro that calls your function.
Then create a batch file something like this

Start /w C:\"Program Files"\"Microsoft Office"\Office\MSAccess.exe C:\Path
to the mdb file\myfile.mdb ( all on 1 line and include all the spaces and
put quotes around folder and file names that include spaces.)
Substitute the path to the msaccess.exe file from your PC and the actual
path to your app.
Save the file with an ".bat" extention

Use windows scheduler to start the batch when you want.
This is a crude down and dirty approach, but it works. Will work with win
98, me or XP.

Hope this helps
Rosco