Cross-Tab Query Save Layout Dialog

DNewman

Registered User.
Local time
Today, 12:06
Joined
Oct 12, 2012
Messages
60
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)
 
whenever you make any adjustment to a query, field name, width, etc. , it will ask you to save the adjustment. just say yes.
otherwise you must diable warnings, SETWARNINGS = FALSE, in a macro.
that just makes things worse.
 

Users who are viewing this thread

Back
Top Bottom