0
00KobeBrian
How do you suppress the action query warning message when you run make table
query and the table exists? Thanks.
query and the table exists? Thanks.
You are using an out of date browser. It may not display this or other websites correctly.
You should upgrade or use an alternative browser.
You should upgrade or use an alternative browser.
J
JustinP
Does putting:
DoCmd.SetWarnings False
before the make table query work?
DoCmd.SetWarnings False
before the make table query work?
J
John Vinson
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]