Running "update query" automatically

[dargo72]

I have an update query that works fine. I would like to have the query run on database open. I already have an "autoexec" macro that takes people to a main menu when the databse opens. I looked at adding an "open query" to the macro, but I want the macro to simply run, rather than be opened. Suggestions/Comments?

Also, I would like it to run without any user intervention/prompting.

Thank you,

[JoeM]

Using the "OpenQuery" Macro action on an Update Query will actually run it, not open it (try it and see!).
So, in your AutoExec macro, if you put that command first, and then the Main Menu Open Form command second, I think that should suit your needs.

[dargo72]

Using the "OpenQuery" Macro action on an Update Query will actually run it, not open it (try it and see!).
So, in your AutoExec macro, if you put that command first, and then the Main Menu Open Form command second, I think that should suit your needs.

That works, thank you. Is there a way to disable to "macro warning" that pops up and the notification that your changing x number of records?

[JoeM]

Yes there is. Before the query action, add a SetWarnings action, and choose the value "No".
Then after the query action, add another SetWarnings action turning it back on with a value of "Yes".

[dargo72]

Yes there is. Before the query action, add a SetWarnings action, and choose the value "No".
Then after the query action, add another SetWarnings action turning it back on with a value of "Yes".

In the macro builder, I do not see a "SetWarnings" option in the dropdown list.

[JoeM]

Some of the actions are hidden, by default, in Access 2007 and higher.
From the Show/Hide menu, select "Show All Actions" and then you will be able to see it.

[dargo72]

Some of the actions are hidden, by default, in Access 2007 and higher.
From the Show/Hide menu, select "Show All Actions" and then you will be able to see it.

Perfect, Thank you!