Can MsgBox automated by system be avoided?

[Doraemon]

I have created a "Delete" button, in which when clicked, will delete all the records in a specified table.

However, a message box which is popped up by the system will result for the confirmation of deletion.

I would like to ask is there any method for avoid the message box, so that the deletion will be carried out directly without confirmation from users?

 

[KenReay]

Hi

In the BeforeDelete event of the Form

Response = acDataErrContinue

Regards

Ken Reay
Freelance Solutions Developer
Boldon Information Systems Ltd
Website needs upgrading, but for now -

http://www.kenneth.reay.btinternet.co.uk

UK

 

[SgtJarrow]

Or in the code for the button itself, put:

DoCmd.SetWarnings False

before the deletion code and

DoCmd.SetWarnings True

after the code...

****************************
Only two things are infinite, the universe and human stupidity,
and I'm not sure about the former. (Albert Einstein)

Robert L. Johnson III
MCSA, CNA, Net+, A+
w: rljohnso@stewart.com
h: wildmage@tampabay.rr.com

 

[Doraemon]

I can now avoid those msgbox through your help.
Really thanks!

 

[SgtJarrow]

Doraemon,

It is good practice in these forums to be a bit more specific as to who helped you and what exactly worked for you....

This allows for others to read the threads and find their solutions easier and quicker...

Just an FYI...We are always here to help...

****************************
Only two things are infinite, the universe and human stupidity,
and I'm not sure about the former. (Albert Einstein)

Robert L. Johnson III
MCSA, CNA, Net+, A+
w: rljohnso@stewart.com
h: wildmage@tampabay.rr.com