deactivate notification

[anzacks]

Dear all,

I create a make table query.
But every time I run the query, the notification will prompt out "are you sure....".
Is there any way to disable this notification?

Tq.

 

[boblarson]

Yes, a couple of ways.

1. Tools > Options > Edit/Find > uncheck the confirm checkboxes

2. Use SetWarnings in macros or DoCmd.SetWarnings in modules (if you use this be sure to re-enable the warnings in an error handler or you will end up with no warnings at all if it doesn't get reset)