Query Defaults

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

Guest

I have created a rather large database. In this database I have created Queries and Macros that run th
queries. When I execute one of these macros, and the queries start I have to answer many questions, do I want to delete
do I want to change etc. I have found that I can change the database options to not show these messages. However, it seems that some of my queries instead of defaulting to "Yes" are defaulting to "no" or bypassing
Where can I change this in my queries or database

Thank you
 
I have created a rather large database. In this database I have created Queries and Macros that run the
queries. When I execute one of these macros, and the queries start I have to answer many questions, do I want to delete,
do I want to change etc. I have found that I can change the database options to not show these messages. However, it seems that some of my queries instead of defaulting to "Yes" are defaulting to "no" or bypassing.
Where can I change this in my queries or database?

Thank you.
Click to expand...

I'd suggest leaving the notifications settings alone - if you set it
to suppress all error or warning messages you will miss some messages
you really want to see!

Instead, in your Macro put a line

SetWarnings False

before the query; this will suppress messages for that event only. BE
SURE to put

SetWarnings True

after the query, or it will turn off all messages for the remainder of
the session.
 
Back
Top