Avoiding 'Delete Table' Warning in Make-Table Query

[bbatson]

Hello,

Does anyone know how to avoid the 'delete table' warning that comes with a make-table query?

As an example, I am referring to this message box:



Thank you!

[Scott Price]

In VBA code you can (assuming you are calling the make-table query from a command button) place this code before the code that calls the query:

DoCmd.SetWarnings False

Don't forget to turn them back on before leaving the subroutine by using this code:

DoCmd.SetWarnings True

Regards,
Scott

[bbatson]

Works perfectly - many thanks.

[Scott Price]

You're welcome! Glad it works for you.

Regards,
Scott