Delete Query Message.

[Mark121]

Sorry if there is already a post on this(I cant seem to find it).

Is it possible to remove the confirmation message when running a delete query? i know you can remove all the other query confirmations through tools>options etc but i cant seem to get rid of this one.

Thanks

Mark

 

[Ecron]

in (edit)your run query button put this in:
DoCmd.SetWarnings(0)
before opening the query

 

[Mark121]

Fantastic, thanks for your help.

Mark

 

[meloncolly]

I'd strongly advise you to switch them back on afterwards too. DoCmd.SetWarnings True

Whilst they can be annoying, messages are useful. If they are switched off using the code here and not switched on, there's a possibility you'll do something you didn't mean to do, and not be asked to confirm without ever knowing about (until you try to query those 50,000 records you just deleted...)

 

[Ecron]

that's a good point, but i guess that's what the message is there for anyway?

hah.

also, even if they are switched off here if there's something wrong with the delete you could easily needed recoreds without noticing!

i guess. be careful, regardless.

 

[voslica]

in (edit)your run query button put this in:
DoCmd.SetWarnings(0)
before opening the query

I am very novice with visual basic. Where do I put this code? or is there a way to put this step into a macro?

 

[Mark121]

You dont need to put it in the VB you can put it in a macro.
If you create a macro theres a function called runCode select this and in the input box at the bottom put the code in.

Hope this helps