Running a Program

[softlad]

Hi

I want to write a program that will run over night using
VBA in Access. I don't need any Forms.
I know VBA quite well. I've written code that is executed
when a button is clicked!

How do I go about starting and when I have written it then how do I Call the
Program.

Ta in Advance and any info much appreciated.

Paul

 

[jebry]

Hi Paul!

What you can do is write the code in a public function in a module. You can then make a macro called autoexec and use the RunCode action to call your function(or functions). If you have a scheduling utility(like what comes with Windows 2K), you can schedule the database to open anytime you want it to and the autoexec macro will run which will run your code. The last thing that the database should do is close itself down again.

hth Jeff Bridgham
bridgham@purdue.edu