Delete Query

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
 
V

Van T. Dinh

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

Alternatively, use the Execute Method like:

CurrentDB.Execute "YourDeleteQuery"
 

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Similar Threads

Office365 Family + TXT or MX Domain 0
"MSysCompactError", "System resource exceeded" & "You do not have the necessary permissions to use the...." 0
Remove Identical words 0
Excel does not accept text format! 0
ASK Field Formatting 1
Query in VBA 1
Sub projects added as read only in Master file which are saved on sharepoint 1
Trying to create a report that will list unmatched records by Ticket Primary Key 0

Top