Auto Running a module !?

[uk]

I am trying to automate my access database to run first thing in the morning so it is has finished running by the time I get to work, I have set up a module -modRUN that runs all the queries and updates all the tables, the only problem is getting this module to run at the time I want.

I have figured two possible ways to do this, either

1] Create another module that will prompt the modRun to run at a certain time- I have no idea how to do this!

2] To use the Shedule task wizard - but this will only open the databse, it wont get the module to run!

Anybody got a solution?[/b]

 

[Joe4]

2] To use the Shedule task wizard - but this will only open the databse, it wont get the module to run!

You are on the right track and are very close! I have done something like this, using method 2 you described above. Here are the key steps you are missing that will allow you to do it:

1. Set up your database to open a form automatically upon start-up.. Do this by going to Tools | Startup and select your form under the Display Form/Page textbox.

2. Call your macro in the Form_Load event of the form you are opening upon start-up.

Now, when the database is opened, it will automatically open the form you specified, and the Form_Load event will automatically call and run your code.

 

[Philem]

Hullo. Alternately, you can modify the line to launch the database used in your Scheduled job, to run a given macro, by putting /X MacroName at the end.

HTH

P

 

[Joe4]

Hullo. Alternately, you can modify the line to launch the database used in your Scheduled job, to run a given macro, by putting /X MacroName at the end.

Philem, that's cool, I didn't know that. Does that just work with Macros, or can you call VBA code (Sub procedures stored in Modules) also?

 

[uk]

um, how do you make the macro that will run the module?

 

[uk]

Apparently our IT Dep have decided not to allow us to use task shceduler !!!

Any one have a work around idea?


1] Create another module that will prompt the modRun to run at a certain time- I have no idea how to do this!

 

[bat17]

you can use the timer event of a form to run your code for you. Check out "Event Timer" in help

Peter

 

[CT Witter]

To run code at the startup of the database, you can also use a macro titled "AutoExec" . Within this macro you can place any number of arguments (Open Form, RunCode, RunSQl,etc.)

HTH,
CT

 

[CT Witter]

Philem, that's cool, I didn't know that. Does that just work with Macros, or can you call VBA code (Sub procedures stored in Modules) also?

Check out this knowledge base article (105128) about all the command line options
http://support.microsoft.com/default.aspx?scid=kb;en-us;105128&Product=acc

CT