Turning off the confirmation messages

[Guest]

How can I turn off ALL of the confirmation messages when doing a make table
query? I have end-users who are terrified when they see the confirmation
messages when they run a report macro. They think if they click on yes or
no, they'll break something. I know how to turn off the messages by going to
the "Edit/Find" tab under "Options". But doing this process doesn't turn off
all of the confirmation. Is there another step I should be doing?

Thanks,
Maria

 

[Douglas J. Steele]

How are you running the query? If you're using RunSQL, put a
DoCmd.SetWarnings False before you run it, and DoCmd.SetWarnings True
afterwards.

Better, though, is to use the Execute method of the CurrentDb object,
because, in addition to not requiring confirmation, it'll raise a trappable
error if the query is unsuccessful:

CurrentDb().Execute strSQL, dbFailOnError

 

[Guest]

Thanks for responding, Douglas. I'm not using RunSQL -- just the typical
make table query. I'm not that advance in Access, so I'm not sure how I can
implement your suggestion.

Thanks,
MK

 

[Douglas J. Steele]

If you're running it simply by double-clicking on the query, you'll have a
bit of problems. If you're using a macro to run the query, put SetWarnings
False before and SetWarnings True after running it.

 

[Guest]

Thank you, Douglas! I will try that.

Maria

If you're running it simply by double-clicking on the query, you'll have a
bit of problems. If you're using a macro to run the query, put SetWarnings
False before and SetWarnings True after running it.