• 512-991-7197
  • This email address is being protected from spambots. You need JavaScript enabled to view it.
  • Always Open

Welcome to Microsoft Access Tips & Tricks

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


Star InactiveStar InactiveStar InactiveStar InactiveStar Inactive
 

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


Recommend other relevant articles:

Flex is now with 8 post formats built-in for blogging: standard, video, gallery, audio, link, quote, status and new “Custom”

 

 

© 2019 Austin Laptop [AustinLaptop.Com]. All Rights Reserved.