Max Wanadoo
max.wanadoo at gmail.com
Fri Jan 15 16:55:35 CST 2010
Dan, Did you try my suggestion? Create another form. Open both in design view. Ctrl-A and Ctrl-C to copy all objects from Bad Form to New Form. Repeat for code. Max -----Original Message----- From: accessd-bounces at databaseadvisors.com [mailto:accessd-bounces at databaseadvisors.com] On Behalf Of Dan Waters Sent: 15 January 2010 22:14 To: 'Access Developers discussion and problem solving' Subject: Re: [AccessD] Form Closing Problem - New(?) Max & Robert, Not a runtime. This form only reads data - Me.Dirty will always be false. I haven't rebuilt the form - this one is quite complex and would take at least a full day. I have been working on this most of today - what I found so far is that if I don't set Me.OrderBy to any value, then the problem goes away. To substitute, when the user clicks a header label to sort by that column, I am requerying with a change to the query to recognize a specific 'ORDER BY' string. Previously I was changing the Me.OrderBy property in code. So it looks like leaving the OrderBy property blank and not trying to reset it in code may solve the problem. I did a quick test at my customer's site to see if this would work, and it did. Next I'm going to copy the modified form to their system and see if it still works. I'll report back. Dan -----Original Message----- From: accessd-bounces at databaseadvisors.com [mailto:accessd-bounces at databaseadvisors.com] On Behalf Of Robert Sent: Friday, January 15, 2010 3:31 PM To: 'Access Developers discussion and problem solving' Subject: Re: [AccessD] Form Closing Problem - New(?) Ok so lets break this down...... >At only one customer, they are experiencing a problem when closing forms. >For example, I can open a form in Form View add a new record. If I then close Access with the X button in the >upper right corner of the Access Window, Access now asks if they would like to save the changes to the form. >This happens with forms after the recordset has been modified. I don't see why Access would ask to save form changes if only the record is being modified. I don't believe that I have seen this before in my own dev. Work... ;-) .. I know helpful right... :-) >If I close the form with a button that uses DoCmd.Close acForm, Me.Name, then no problem. If I leave the form >open, then push a button on the main screen to use Application.Quit, then no problem. But if I've opened a >form in form view, changed the recordset, then close with the upper right X button of the Access window, I get >the question 'do I want to save changes'. Ok so this is not in a runtime environment?, and Dirty = True is permitted when leaving the form focus? Application.Quit is a pretty strong way of closing the program, so all bets are off there... ;-) How much code are you running when creating or "changing" the recordset?? I'm guessing that something (your code) is utilizing the forms objects. Example: Me.LName = !LastName....?? >I've decompiled/compiled, compacted/repaired, and rebuilt the Access files by importing all objects into a new >Access .mdb file. But that doesn't help. Have you attempted to completely rebuild the form? >Has anyone seen this issue? How did you solve it? >Thanks! >Dan WBR Robert -----Original Message----- From: accessd-bounces at databaseadvisors.com [mailto:accessd-bounces at databaseadvisors.com] On Behalf Of Dan Waters Sent: Friday, January 15, 2010 3:55 PM To: 'Access Developers discussion and problem solving' Subject: Re: [AccessD] Form Closing Problem - New(?) Hi Robert, WXP SP3, Access 2003 SP3. Customer uses the same. I don't know all the differences between their PC's and my PC - I have asked them to let me know of any changes they've made in the last couple of days. Dan SNIP -- AccessD mailing list AccessD at databaseadvisors.com http://databaseadvisors.com/mailman/listinfo/accessd Website: http://www.databaseadvisors.com -- AccessD mailing list AccessD at databaseadvisors.com http://databaseadvisors.com/mailman/listinfo/accessd Website: http://www.databaseadvisors.com