Supress Append Query Error Message

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

Guest

Is there a way to stop the message saying that records will not be appended
from showing? I'm getting this message because I have set up the table with
unique values to stop duplicate records from being added, so as the message
is only confirming that the query is running correctly I would like it just
to skip this message. I cant find where it comes from. I've tried error
trapping in the procedure that executes the query and the forms on error
event, but it still appears.
 
If you use the .execute method to run the query, you won't get any warning
messages. Alternatively, you can turn warnings off immediately prior to
running the query as long as you remember to turn them back on immediately
after the query.
 
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 I answered your question, please mark it as an answer. That way, it will
stay saved for a longer time, so other can benifit from it.

Good luck
 
Back
Top