Avoid Save dialog after query format changes

[ReluctantDataGuy]

Is there a way to prevent MS Access from displaying the Save dialog after a user makes formatting changes - such as column widths - to a query?

Note that I use "DoCmd.OpenQuery QryName, acViewNormal, acReadOnly" but it only prevents data changes - still allows formatting changes and displays the Save dialog.

I want users to be able to make formatting changes. I just don't want Access to ask them if they want to save the changes.

Thanks in advance for any help.

BobK

 

[jadams0173]

You may try this. But it turns off all warnings until you turn it back on.

DOCMD.SETWARNINGS FALSE