How to turn off warning message to confirm when doing update, insert, delete in MS Access

When you are doing DML query in MS Access, you will normally get the confirmation message. If you don't want this message to pop up, here is the way to do it by executing these code.

Application.SetOption "Confirm Action Queries", 0
Application.SetOption "Confirm Document Deletions", 0
Application.SetOption "Confirm Record Changes", 0

And when you want to turn it back on just replace 0 with 1. This will enable the confirmation warning message.

Application.SetOption "Confirm Action Queries", 1
Application.SetOption "Confirm Document Deletions", 1
Application.SetOption "Confirm Record Changes", 1