Hi,

I have to run few queries one after another. I created a form, so now I can run them in sequence with just 1 click of a button.
It there a way that I can start running those queries by just loading the form and not clicking any button. My main aim is to have a schedule task so Access starts at fixed time and starts running those queries

Parth

Hi,

I have to run few queries one after another. I created a form, so now I can run them in sequence with just 1 click of a button.
It there a way that I can start running those queries by just loading the form and not clicking any button. My main aim is to have a schedule task so Access starts at fixed time and starts running those queries

Parth

Yes, Put the code behind the button in the On Open event of the form. Then go to Tools>Startup Options and set that form to load as the default form. You can then use Task Scheduler to open the app and the form will load and run the code.