Run Access Macro Automatically

[UnysonElliot]

Hello,

I have created a database that I would like to put on a schedule to send out every day without manual intervention. I have seen a lot of posts from various websites about using Windows Task Scheduler. I cannot figure out how to use the Windows Task Scheduler. I was coming here either for help with setting up Windows Task Scheduler to run this macro or if there are any other solutions that anybody knows.

Let me know if you need any info from me that I can provide to help.

 

[Norie]

Do you have a macro in the databas that sends it out?

If you do you could set things up so the macro is automatically run when the database is opened and then create a task to open the database at a specific time.

 

[Joe4]

Windows Scheduler can be involved. The way I usually do it is of open an Access database that runs automatically upon opening.
You can set an Access database to run automatically upon opening in one of two ways:
- Create a macro and name it "AutoExec". Any macro with this name will run automatically upon opening.
- Designate a form to be a Startup Form. Then, put VBA code in the Load event of this form. Thus, the VBA code will run automatically whenever the database is opened.

 

[UnysonElliot]

Windows Scheduler can be involved. The way I usually do it is of open an Access database that runs automatically upon opening.
You can set an Access database to run automatically upon opening in one of two ways:
- Create a macro and name it "AutoExec". Any macro with this name will run automatically upon opening.
- Designate a form to be a Startup Form. Then, put VBA code in the Load event of this form. Thus, the VBA code will run automatically whenever the database is opened.

So I already have a form with a button on it running the Macro. Your solution does solve the part of clicking the button. I'd rather not have to open the access database at all. I didn't know if there was code I could add to the module that I already have to make it kick off at a certain time each day. The module I have already exports my file to a location with the current date on it.

 

[Norie]

Where is the 'module' that exports the file located?

 

[UnysonElliot]

Where is the 'module' that exports the file located?

Not sure what you exactly mean but it's located inside the same database and calling the module using a RunCode action in a macro.

 

[Norie]

You can't run code that's in a database without opening the database.

What exactly does the code do?

 

[UnysonElliot]

You can't run code that's in a database without opening the database.

What exactly does the code do?

It exports a query with a dynamic title to a certain tab in an Excel file. I have two of these exporting 2 queries. The reason I had to use a module was to get the dynamic title which contains the current date so it will not override each report.

 

[Norie]

Have you considered using code in the Excel workbook to import from the database?

That code could be set to run when the workbook opens, and only to run if there isn't an existing tab for the current date.

 

[UnysonElliot]

I haven't. I don't know any VBA which is why I haven't thought about anything like that.