Prevent Confirm Delete Query msgbox from showing?

[PeasNCarrots]

I have unchecked all the confirm boxed under options menu. Do I have to do this in code? How?

Also, I dont want the msgbox asking if I still want to append data even though x# of records contain null values
to be displayed. I want the query to be executed without interruptions, completely automatic.

Thanks.

 

[GIJoeFigure]

The Delete Confirm dialog box isn't displayed if you clear the check in the Record Changes check box under Confirm on the Edit/Find tab of the Options dialog box, available by clicking Options on the Tools menu.


J. Handfield
Interning Scientist
Eastman Kodak Research Labs
Rochester, NY 14650

 

[PHV]

You may also consider the DoCmd.SetWarnings method

Hope This Helps, PH.
Want to get great answers to your Tek-Tips questions? Have a look at FAQ219-2884 or FAQ222-2244

 

[PeasNCarrots]

I have cleared all the check boxes. I am deleted an object(table) because I am running a make table query.