Delete Query

  • Thread starter Thread starter Alain
  • Start date Start date
A

Alain

Hello,

I would like to know if it is possible to programatically
remove the warning msgbox when we are about to delete
recordset from a table, I know it is possible to set it
up in the options, but I want to turn off that option
only in 1 database program, not on all of them

Thanks
Alain
 
DoCmd.SetWarnings False
DoCmd.OpenQuery "YourDeleteQuery"
DoCmd.SetWarnings True

Alternatively, use the Execute Method like:

CurrentDB.Execute "YourDeleteQuery"
 
Back
Top