deleting record without confirmation

  • Thread starter Thread starter Grumpy Willis
  • Start date Start date
G

Grumpy Willis

Can anyone help me?

I need to have a button on a form that deletes the record, but which doesn't
pop up the "You are about to delete 1 record(s)" confirmation dialogue box.

Can this be done?

Thanks
Rich.
 
Rich,

If you are using a macro, precede the macro action (RunQuery or RunSQL
or RunCommand/DeleteRecord presumably) with a SetWarnings,No action.

If you are using a vba procedure, similarly put
DoCmd.SetWarnings False
ahead of the delete code, and in this case you will also need to put
DoCmd.SetWarnings True
afterwards.
 

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

Confirming Delete 5
Access Dcount (multiple criteria) 3
AOL email scam 2
2007 accdr Confirm record changes doesn't go away 2
If...Then...ElseIf 8
Supress delete dialog on another Table? 2
Delete won't delete from query/form 3
delete command button 3

Back
Top