Getting rid of Warnings

[Joey4Js]

Hi Everyone,

My six month project is nearly complete. The last thing (maybe) I need help with is getting rid of the automatic warnings that come up when I enter this code:

DoCmd.RunSQL "DELETE * FROM NewTable;"

Is there any way of getting around this?

Thanks,

Joe

 

[KenReay]

Hi

DoCmd.SetWArnings False
DoCmd.RunSQL "DELETE * FROM NewTable;"
DoCmd.SetWarnings True

will do it Regards

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

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

UK