Macro to run the query and close the access

[kowol]

I'd like to run the make table query daily at night and close the access after finish it.
I've found some instruction to run the Macro to do it but I also need a macro to clear all the warning message.

Thanks

 

[GohDiamond]

Macro: Action=SetWarrnings>Warnings On=No (VBA: DoCmd.SetWarnings False)

That will ignore the warning messages and complete the action without the user havning to interact.

Macro: Action=QUIT Options=SaveALL (VBA: DoCmd.Quit acQuitSaveAll)

That will save all the changes in all open objects then quit the application.

-Goh

 

[kowol]

But I don't know how to enter your code in Macro.
It doesn't have SetWarrnings in the Action list

 

[GohDiamond]

What version of MS Access are you using?
-Goh

 

[GohDiamond]

When you are creating the Macro in Versions higher then 2003 you have an extra step. While in the macro editor you will see a button in the ribbon in the SHOW/HIDE section. Click on the Show All Actions Button and then check the dropdown Action menu. you will find "SetWarnings".
-Goh

 

[kowol]

It works!
Thanks