make table query

  • Thread starter Thread starter 00KobeBrian
  • Start date Start date
0

00KobeBrian

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

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]
 
Back
Top