Access 2010 on Windows 10
Using VBA my application creates a Cross-Tab Query to display the total number of Appointments booked by Site and Month.
I have manipulated the column headers and the column widths to give an aesthetic display. When the displayed query is closed a dialog box pops up asking if I want to save the layout of the query. I don't actually want to save anything(!) so this is an annoyance.
Is there anyway that I can suppress this dialog box?
(bracketing the doCmd.OpenQuery with doCmd.SetWarnings False and True does not help)
Using VBA my application creates a Cross-Tab Query to display the total number of Appointments booked by Site and Month.
I have manipulated the column headers and the column widths to give an aesthetic display. When the displayed query is closed a dialog box pops up asking if I want to save the layout of the query. I don't actually want to save anything(!) so this is an annoyance.
Is there anyway that I can suppress this dialog box?
(bracketing the doCmd.OpenQuery with doCmd.SetWarnings False and True does not help)