It requires you to manually turn off warnings using DoCmd.SetWarnings False .
To run an , Append , or Delete query without showing anything to the user, use the .Execute method. This is the "professional" way to handle data. Access Vb Code For Calling Queries
While you might see DoCmd.RunSQL in older tutorials, it is generally discouraged because: It requires you to manually turn off warnings using DoCmd
If your query has parameters (e.g., [Enter Start Date] ), calling it directly via .Execute will fail with a "Too few parameters" error. You must use a QueryDef to provide the values. While you might see DoCmd
Dim db As DAO.Database Set db = CurrentDb ' Runs "qryUpdatePrices" and stops if there is an error db.Execute "qryUpdatePrices", dbFailOnError ' Check how many rows were changed MsgBox db.RecordsAffected & " records updated." Use code with caution. Copied to clipboard
If your code crashes before you turn warnings back on, your Access environment will stay "silent" for everything.
If you want to pop open a datasheet (like double-clicking it in the Navigation Pane), use DoCmd.OpenQuery .