how do you supress a confrimation on a query when it is giving a message of setting to null

  • Thread starter Thread starter sd
  • Start date Start date
S

sd

How do you either suppress the confirmation or automate the answer to yes
when a query has a confirmation message due to setting values to null. I
have already unchecked the confirmation boxes in options.
 
If you are NOT running the query from a macro, go to the
Access Tools menu and select Customize. Go to the
Edit/Find tab and deselect "Action Queries" (or "Record
Changes" depending on your specific situation) in the
upper right-hand pane.
 
Similarly, you can set this property in an Event Procedure
by typing
DoCmd.SetWarnings = No
-----Original Message-----
If you are running your query from a macro, you can:

Set Warnings = No (put this before the OpenQuery action)

Make sure you set your warnings back to yes at the end of
Click to expand...
your macro if you want messages to appear during your
database session.
 
Back
Top