make table query

How do you suppress the action query warning message when you run make table
query and the table exists? Thanks.

Does putting:
DoCmd.SetWarnings False
before the make table query work?


00KobeBrian wrote:

How do you suppress the action query warning message when you run make table
query and the table exists? Thanks.

On Mon, 4 Sep 2006 15:33:06 +0800, "00KobeBrian" wrote:

How do you suppress the action query warning message when you run make table
query and the table exists? Thanks.


Note that MakeTable queries are VERY rarely actually needed. Some
folks assume (perhaps based on experience with other programs) that
you need to create a new table in order to report or export the data;
neither is true, you can do so from a Query.

That said - what do you want to happen? Do you want to always
overwrite the existing table? If so, consider deleting the table as
part of the macro or VBA procedure which runs the queries. You can use
the SetWarnings action to turn off warning messages:

DoCmd.SetWarnings False

in VBA. Be sure to SetWarnings True afterward or you'll turn off ALL
warning messages!

John W. Vinson[MVP]