Access Macro Scheduler

-->

The RunMacro method carries out the RunMacro action in Visual Basic.

If you have macros in Microsoft Word, Excel or Access they will be written in VBA - Visual Basic for Applications. If you wish to use this code inside Macro Scheduler you can convert this code to VBScript.

Syntax

Launch Access and run your macro which can do things like print reports, download data, export information, and run your custom VBA code Create a copy of your critical data for all or specified tables in your database when you don't want or need to copy the entire database Define Your Own Schedules. When the system interprets a job's JCL statements, it obtains information about the job's data sets. It stores this information in the scheduler work area (SWA). When the job runs, the system develops additional information about the job's data sets, which it also stores in the SWA. Some of this information is in the following SWA blocks.

expression.RunMacro (MacroName, RepeatCount, RepeatExpression)

expression A variable that represents a DoCmd object.

Parameters

NameRequired/OptionalData typeDescription
MacroNameRequiredVariantA string expression that's the valid name of a macro in the current database. If you run Visual Basic code containing the RunMacro method in a library database, Microsoft Access looks for the macro with this name in the library database and doesn't look for it in the current database.
RepeatCountOptionalVariantA numeric expression that evaluates to an integer, which is the number of times the macro will run.
RepeatExpressionOptionalVariantA numeric expression that's evaluated each time the macro runs. When it evaluates to False (0), the macro stops running.

Run Access Macro Task Scheduler

Remarks

You can use the RunMacro method to run a macro.

Access

You can use MacroGroupName.MacroName syntax for the MacroName argument to run a particular macro in a macro group.

If you specify the RepeatExpression argument and leave the RepeatCount argument blank, you must include the RepeatCount argument's comma. If you leave a trailing argument blank, don't use a comma following the last argument that you specify.

Example

The following example runs the macro Print Sales that will print the sales report twice.

Support and feedback

Have questions or feedback about Office VBA or this documentation? Please see Office VBA support and feedback for guidance about the ways you can receive support and provide feedback.

When you want to Schedule a Macro Script to run at a Later Date Time 1 time or at recurring time intervals, you can use Windows Task Scheduler and Automate Script Execution. This post provides basic tutorial on how to use Windows Task Scheduler to create Basic Task, Test Run the Script Execution and even schedule it to run as and when required. All you need to do is create a Macro Script which ensures that the Graphical User Interface Elements on Desktop remain are at appropriate locations for Mouse Automation.

Schedule Script Execution With Windows Task Scheduler

Once you have created the required Script, you can use Windows Task Scheduler to Schedule Script Execution with steps outlined below. Do make sure to run the Task in Windows Task Scheduler and ensure that the script execution will run fine with desired results. Do make sure that there are no errors in Script Execution.

  1. Create a Macro Script and Save it on your Windows Computer.
  2. Invoke System Tray Menu by doing a Left Mouse Click on the top left corner of this Windows Automation Software as displayed in the Screenshot below.

    System Tray Menu with Task Scheduler Menu Selected

    This Action allows you to Copy required data for Windows Task Scheduler to be copied by this Software onto Clipboard.

  3. Launch Windows Task Scheduler and create a basic Task, specify Name of the new Task and provide Description (optional).
  4. On the Second Screen of Creating Basic Windows Task, select frequency of this new Task Execution from available options including Daily, Weekly, Monthly, One Time, When the Computer Starts, When I Log on, or when a Specific Event is triggered.
  5. Depending on the Frequency Selection, you will be presented to select appropriate Date, Time, Event, etc for the New Task in Windows Task Scheduler.
  6. Once you have specified the required parameters, move on to the next tab and select the Action as Start a Program and move to the next screen.
  7. Now you need to specify Application File Path and Script File Path in Arguments as displayed in the Screenshot below.

    Basic Task for Macro Script Execution with Windows Task Scheduler

    Note that in the Arguments field, an extra option <SystemTray> Pdf editor download free for mac or windows. has been specified to mark the Script for Execution. Without <SystemTray>, the Script will be opened for Editing Only and the Script will not be Executed.

  8. Finally Click on the Next Button review all the information and click on Finish to create a basic Windows Task to Execute the Macro Script at configured frequency with the help of Windows Task Scheduler.
  9. The Last and Final Step required for smooth execution of Macro Script with Windows Task Scheduler is to enable the option titled Execute with highest privileges as displayed in the screenshot below.

    Enable the Checkbox titled Run with Highest Privileges for the newly Create Task in Windows Task Scheduler

Once you have completed, the above steps do make sure to test run the Script Execution so that you are 100% sure that the Windows Task Scheduler will be able to execute the Macro Script without errors at a later Date / Time or depending on specific event. As you can run this Windows Automation Software with or without Admin Privileges, you need to ensure that Windows Task Scheduler can indeed run your Script taking into consideration the current Settings of AMC Version Selector.

AMC Version Selector Setting to Avoid 0x800702e4 Error in Windows Task Scheduler

Ms Access Schedule Macro

When the AMC Version Selector has been configured to use Auto Mouse Click Application in Default Version for Games or Apps which require Admin Access, the Windows Task Scheduler can error 0x800702e4 and a quick way to resolve this is to run AMC without Admin Access. You can also use Startup Parameters of Macro Script to execute Macro Script at a Later Date Time without handling the complexity of Windows Task Scheduler. Yes the Windows Task Scheduler offers more configurable options to schedule Script Execution and can even be used on Unattended Computers.