 |
 | Home | Contact Us | FAQ | Search & Site Map | Link to Us |
 | Sign In | Join | Other 45 Sites in Network |
MS Access Forum / General 2 / January 2008Supress "Save" prompt after resizing form by code?
I use DoCmd.MoveSize to resize my form on Form_Load and in the code of two buttons. How can I supress the "Do you want to save changes to the design?" message when I close? I tried setting Me.Dirty = False, but the code kept coming back as an invalid reference to Dirty - I finally realized that when it hit that spot, the database window was becoming the active window and the object of "Me", and probably doesn't have a Dirty property. Everywhere else I use Me to refer to the controls, it works just fine. Ed Ed, use of DoCmd.MoveSize does not usually give that message. If you don't want to save design changes you can add acSaveNo DoCmd.Close acForm, Me.Name, , acSaveNo Jeanette Cunningham >I use DoCmd.MoveSize to resize my form on Form_Load and in the code of > two buttons. How can I supress the "Do you want to save changes to [quoted text clipped - 7 lines] > > Ed Thank you for responding, Jeanette. Just realized I am forgeting to mention that I'm using Access 2003. And I'm getting this message when I'm using the X to quit the form. Would I put this in Form_Unload or Form_Close? Ed On Jan 12, 1:08 pm, "Jeanette Cunningham" <n...@discussions.microsoft.com> wrote: > Ed, > use of DoCmd.MoveSize does not usually give that message. [quoted text clipped - 16 lines] > > - Show quoted text - I would think in the form unload - if not working as you want, try the close event. Jeanette Cunningham Thank you for responding, Jeanette. Just realized I am forgeting to mention that I'm using Access 2003. And I'm getting this message when I'm using the X to quit the form. Would I put this in Form_Unload or Form_Close? Ed On Jan 12, 1:08 pm, "Jeanette Cunningham" <n...@discussions.microsoft.com> wrote: > Ed, > use of DoCmd.MoveSize does not usually give that message. [quoted text clipped - 19 lines] > > - Show quoted text - I finally resolved the issue by simply putting DoCmd.Save after each instance of resizing the form. Ed On Jan 12, 4:15 pm, "Jeanette Cunningham" <n...@discussions.microsoft.com> wrote: > I would think in the form unload - if not working as you want, try the close > event. [quoted text clipped - 38 lines] > > - Show quoted text - Glad you found a fix. Jeanette Cunningham I finally resolved the issue by simply putting DoCmd.Save after each instance of resizing the form. Ed On Jan 12, 4:15 pm, "Jeanette Cunningham" <n...@discussions.microsoft.com> wrote: > I would think in the form unload - if not working as you want, try the > close [quoted text clipped - 41 lines] > > - Show quoted text - |
Reply to this Message |
 Sign In
 Join
 My Latest Posts My Monitored Threads My Blog My Photo Gallery My Profile My Homepage Start New Thread Enable EMail Alerts Rate this Thread
|
©2008 Advenet LLC Privacy Policy - Terms of Use
This website includes both content owned or controlled by Advenet as well as content owned or controlled by third parties.