Access vba: How to turn of systems messages or prompts?

Question

Hi,

I use a form to run a few codes on a database in access. During updation or deletion access asks whether u want to update or delete. I would like to know if there is any way of turning off theses system messages or let the user choose his preference on whether he would like thoses messages to pop up or not.

Thanks tksy

Answer 1

Don't foget to turn these back on.

DoCmd.SetWarnings false
DoCmd.SetWarnings true

Application.DisplayAlerts = false
Application.DisplayAlerts = true