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

  • Thread starter Thread starter Tom E Jensen
  • Start date Start date
T

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 !
 
Tom said:
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 ?
Click to expand...


Use the Execute method in a VBA procedure, probably in a
form button's Click event procedure.
 
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.
 
Back
Top