Share via

run access macros in the background

Anonymous
2016-11-06T22:21:14+00:00

How do I run a macro in the background without clicking ok after each query

Microsoft 365 and Office | Access | For home | Windows

Locked Question. This question was migrated from the Microsoft Support Community. You can vote on whether it's helpful, but you can't add comments or replies or follow the question.

0 comments

1 answer

Sort by: Most helpful
Most helpful Newest Oldest
  1. HansV 462.6K Reputation points MVP Volunteer Moderator
    2016-11-06T22:34:42+00:00

    Open the macro in design view.

    Click to highlight Show All Actions in the Show/Hide group of the Design tab of the ribbon.

    (This button is only enabled if the folder containing the database is a trusted location for Access)

    Insert a SetWarnings action at the beginning of the macro, with the 'Warnings On' argument set to No.

    Insert another SetWarnings action at the end of the macro, with 'Warnings On' set to Yes.

    2 people found this answer helpful.
    0 comments