suppress append query message

  • Thread starter Thread starter Guest
  • Start date Start date
G

Guest

When I run an append query or make table query the system tells me that I
will add records and so on... is there any way to suppress these messages? thx
 
Steve,

If you are running these queries via a macro, you can put a
SetWarnings/No action before the OpenQuery action.

If you are doing it in a VBA procedure, similarly put a line of code
like this...
DoCmd.SetWarnings False
.... ahead of the code that runs the append or make-table, and in this
case you need to also put
DoCmd.SetWarnings False
afterwards.
 
If you want to remove the messages for all queries, without using the set
warnings, then in the menu bar select
Tools > Options > Edit/Search (Tab) > Confirm Action Queries (remove the
selection)

But you have to know that it will never prompt with the message event when
you are using the queries dirrectly
==================================
if you don't want to use this method, then after you run the update query
you need to set the warnings back to true

Docmd.SetWarnings False
Docmd.OpenQuery "QueryName"
Docmd.SetWarnings True
 
Steve,

I should have also mentioned that if you use this method in your code...
CurrentDb.Execute "YourQuery"
.... then the action query confirmation messages do not happen.
 
Ofer said:
If you want to remove the messages for all queries, without using the set
warnings, then in the menu bar select
Tools > Options > Edit/Search (Tab) > Confirm Action Queries (remove the
selection)
Click to expand...

I would not recommend this approach.
 
Back
Top