It's the ONLY form that is throwing the 'do you want to save?' message. I have a nav form, grandchild subform in datasheet view.
#Stop annoying pop ups in word save tracked changes code#
I have the same exact issue, but unfortunately toggeling the warnings didn't work for me. The save message still appeared, even with wiring up the code to other form events. Since my application is designed to be used at runtime by multiple people I needed to have it open consistently every time. What I want basically undoing what I couldn't prevent being saved. I need to set the filter and order by parameters back to My idea with this is that since I've turned off the warnings when a tab is clicked any changes that a user has made via a filter or sort will be saved without the "Do you want to save" prompt. Private Sub Navigation_Service_Main_Enter() In addition to setting warnings to true on the On Load events on the datasheet subforms I've also set the default filter and order by parameters via VBA so my On Load events for these forms would look like this.Īll of the On Enter events of the Navigation Form tabs have the warnings set to False
This is what I've done using what saberman had posted with aĪll of my form On Load events have the warnings set to True I ended up realizing today that I needed to modify the filter and order by on the on load event of the datasheet subform. Times and trying to modify the filters with vba.
I've tried numerous attempts at a solution over the past week with turning on an off warnings and different Bad idea to modify the Table Design for Users in Navigation Forms!įrom what I have been able to read the "Do you want to save" message is a bug with the Navigation Forms that have datasheets as subforms. So, the conclusions below is still valid for Filtering records. If you filter the Table and filter the Form, it will prompt you to save the Form and Table. However, if the steps involve only Forms it does not prompt the message. No, the prompt says "Do you want to save changes to the design of table 'myTable'?". If you answer yes, close the Navigation form and look at the properties of the datasheet form you will see that the Order By property has been changed.
The form is actually being modified - not the table. I thought that also but turning off the option to modify table layouts in datasheet view does not solve the problem - or at least it didn't when I tried it. The downside is that you are allowing the user to make changes to the datasheet form which are saved. Open of the form on the tab getting control turns warnings on Form on tab losing control closes and saves changes.ģ. When you switch tabs the On Enter event of the tab getting control is triggered before the form on the tab losing control is closed. What will happen is when the Navigation form is opened the form on the default tab will turn warnings on. Add "DoCmd.SetWarnings False" to the On Enter event of the tabs on the Navigaition control. Add "DoCmd.SetWarnings True" to the Open event of all of the forms on the Navigation control.Ģ. Unfortunately, the popup occurs before the Unload and Close events so you cannot turn warnings off there. Access 2007 does not warn about changes to a datasheet form. It then asks if you want to save the changedįorm. When you switch tabs Access closes the form on the tab being switched away from. The source of the problem is that sorting the datasheet changes the form's design by changing the Order By Property. I also can't set warnings off on opening the datasheet and turn it back on on closing it because the form has links to various other forms (though, now that I think about it I may just turn off warnings all together though I'd rather not).Īny other solutions you guys can come up with would be great! "Set the form to 'don't allow layout view'" (this would prevent the users from sorting and filter - so what's the point) "Don't use a datasheet - use a continuous form" "Don't use navigation controls, they are new and we never needed them in Access 97" Replies that would not be helpful include: You get a message saying "do you want to save changes to the design." Got to a different tab in the Nav controlĦ. Display the navigation form and goto to the datsheetĥ. Add the dataview as a tab on a navigation form (one that has other tabs showing other forms)ģ. Create a datasheet view based on a tableĢ. This only applied to Access 2010, and, AFAIK, only applies when using DataSheets as subforms of Navigation Controls.ġ.
0 kommentar(er)
