On A Make Table Query Is It Possible to Surpress Prompts?

  • Thread starter Thread starter mcl
  • Start date Start date
M

mcl

The title says it all. Is it possible to have it do things without all the
warnings and prompts and just do it?
Let's see. It warns me I'm going to modify a table. Warns me and asks to
delete existing table. Warns I'm going to paste xxx number of records into a
new table. I don't want that. Just do it!
 
The title says it all. Is it possible to have it do things without all the
warnings and prompts and just do it?
Let's see. It warns me I'm going to modify a table. Warns me and asks to
delete existing table. Warns I'm going to paste xxx number of records into a
new table. I don't want that. Just do it!
Click to expand...

If you are running DoCmd.RunSQL or calling the query by code:
Docmd.SetWarnings False
DoCmd.OpenQuery "Query Name" ' or .RunSQL "Insert .. etc."
DoCmd.SetWarnings True

If you are running the Query by just clicking on the query name in the
main application folder, the only way I know to avoid the message is
to turn them all off completely in:
Tools + Options + Edit/Find
Uncheck the Action Queries box in Confirm

This will effect all messages which may not be a good idea.
 
Back
Top