CODEWITHSUNDEEP
ms-access
tksy
tksy

Reputation: 3529

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

I use a form to run a few codes on a database in Access. During update or deletion Access asks whether you want to update or delete.

I would like to know if there is any way of turning off these system messages or let the user choose his preference on whether he would like thoses messages to pop up or not.

Upvotes: 13

Views: 76392

Answers (1)

LeppyR64
LeppyR64

Reputation: 5359

Don't foget to turn these back on.

DoCmd.SetWarnings false
DoCmd.SetWarnings true

Application.DisplayAlerts = false
Application.DisplayAlerts = true

Upvotes: 21

Related Questions