How to get around the dialogboxes when a delete query is launched

[Tom E Jensen]

Hi
When I launch a delete query, i always must klikk 3 times yes, yes , yes to
get it done. What shall i do to get none ?

Thanks for all answers !

 

[Marshall Barton]

When I launch a delete query, i always must klikk 3 times yes, yes , yes to
get it done. What shall i do to get none ?

Use the Execute method in a VBA procedure, probably in a
form button's Click event procedure.

 

[Allen Browne]

For more detail on what Marsh is suggesting, see:
Action queries: suppressing dialogs, while knowing results
at:
http://allenbrowne.com/ser-60.html

The article walks you through the differences between Execute and
RunSQL/OpenQuery, and discusses how to handle any parameters.