If this is your first visit, be sure to check out the FAQ by clicking the link above. You may have to register before you can post: click the register link above to proceed. To start viewing messages, select the forum that you want to visit from the selection below. |
|
|
Thread Tools | Display Modes |
#1
|
|||
|
|||
make table query
How do you suppress the action query warning message when you run make table
query and the table exists? Thanks. |
#2
|
|||
|
|||
make table query
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. |
#3
|
|||
|
|||
make table query
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] |
Thread Tools | |
Display Modes | |
|
|