It requires you to manually turn off warnings using DoCmd.SetWarnings False .
' Opens the query "qryMonthlySales" in a read-only datasheet DoCmd.OpenQuery "qryMonthlySales", acViewNormal, acReadOnly Use code with caution. Copied to clipboard Easy to use; supports standard Access prompts. Cons: Not ideal for "behind-the-scenes" data updates. ⚙️ 2. Executing Action Queries (Hidden) Access Vb Code For Calling Queries
If your code crashes before you turn warnings back on, your Access environment will stay "silent" for everything. It requires you to manually turn off warnings using DoCmd
To "look" at the data returned by a Select query inside your code, open it as a Recordset. open it as a Recordset.