By using this site, you agree to our updated Privacy Policy and our Terms of Use. Manage your Cookies Settings.
455,663 Members | 1,827 Online
Bytes IT Community
+ Ask a Question
Need help? Post your question and get tips & solutions from a community of 455,663 IT Pros & Developers. It's quick & easy.

Suppress 'Save changes to layout of query...'?

P: n/a
DFS
I'm using a query as the SourceObject for a subform. When I change any of
the column widths and try to close the form I'm prompted to save changes to
the layout.

Anyone know how to suppress this prompt?

I tried SetWarnings False. Didn't work.

I tried saving the query (DoCmd.Save acQuery, ... ) but Access reports that
it's not open.

I tried DoCmd.RunCommand (acCmdSave). Didn't work.

I tried DoCmd.RunCommand (acCmdSaveLayout). Didn't work (says 'SaveLayout
is not available now')
Any ideas?

Thanks

Nov 13 '05 #1
Share this Question
Share on Google+
1 Reply


P: n/a
DFS
Never mind. Figured it out.

I had to SetWarnings False when opening the form, then SetWarnings True when
closing it.

(and what's actually safer is to SetWarnings when activating/deactivating
the particular form - from which no data can be deleted - in case someone
wants to use other parts of the system from which they can delete data).

DFS wrote:
I'm using a query as the SourceObject for a subform. When I change
any of the column widths and try to close the form I'm prompted to
save changes to the layout.

Anyone know how to suppress this prompt?

I tried SetWarnings False. Didn't work.

I tried saving the query (DoCmd.Save acQuery, ... ) but Access
reports that it's not open.

I tried DoCmd.RunCommand (acCmdSave). Didn't work.

I tried DoCmd.RunCommand (acCmdSaveLayout). Didn't work (says
'SaveLayout is not available now')
Any ideas?

Thanks

Nov 13 '05 #2

This discussion thread is closed

Replies have been disabled for this discussion.