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

Thread view:

Enable EMail Alerts

Start New Thread

Thread rating:

Tom E Jensen - 06 Jul 2006 22:45 GMT

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 !

Reply to this Message

Marshall Barton - 06 Jul 2006 23:26 GMT

>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.

Signature

Marsh
MVP [MS Access]

Reply to this Message

Allen Browne - 07 Jul 2006 03:09 GMT

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.

Signature

Allen Browne - Microsoft MVP. Perth, Western Australia.
Tips for Access users - http://allenbrowne.com/tips.html
Reply to group, rather than allenbrowne at mvps dot org.

>>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.

Reply to this Message