Dan Waters
dwaters at usinternet.com
Fri Jan 15 11:58:02 CST 2010
Hi Max, I do the same thing using a hidden form. But on their system, they get asked if they want to save the form BEFORE my hidden form's unload event is fired. That's why this is difficult - between the time the user pushes the red 'X' button on the Access window and when the unload event fires, Access asks if an open form's design should be changed, and there is no code I can hook into to investigate the problem. The form's design doesn't change in form view, only the underlying query for the form's data. This has the behavior of a bug in Access, but I doubt that. Dan -----Original Message----- From: accessd-bounces at databaseadvisors.com [mailto:accessd-bounces at databaseadvisors.com] On Behalf Of Max Wanadoo Sent: Friday, January 15, 2010 11:36 AM To: 'Access Developers discussion and problem solving' Subject: Re: [AccessD] Form Closing Problem - New(?) Aha! Well spotted. Bet you're an analyst.... Can probably remove that as well - actually you can. I do it all the time. On my main-menu form I prevent that from closing until you click MY button and that in turn prevents Access from closing. There we go....can't keep a good man down...LOL Max -----Original Message----- From: accessd-bounces at databaseadvisors.com [mailto:accessd-bounces at databaseadvisors.com] On Behalf Of Heenan, Lambert Sent: 15 January 2010 17:21 To: 'Access Developers discussion and problem solving' Subject: Re: [AccessD] Form Closing Problem - New(?) He said "Access window's X button", not the Forms' X. Lambert -----Original Message----- From: accessd-bounces at databaseadvisors.com [mailto:accessd-bounces at databaseadvisors.com] On Behalf Of Max Wanadoo Sent: Friday, January 15, 2010 12:15 PM To: 'Access Developers discussion and problem solving' Subject: Re: [AccessD] Form Closing Problem - New(?) Sure you can. It is one of the options if the form's properties. Max -----Original Message----- From: accessd-bounces at databaseadvisors.com [mailto:accessd-bounces at databaseadvisors.com] On Behalf Of Dan Waters Sent: 15 January 2010 16:27 To: 'Access Developers discussion and problem solving' Subject: Re: [AccessD] Form Closing Problem - New(?) I don't think that I can remove the Access window's X button. In any case, all my customers want that X button, and the problem is only happening at one customer, and not on my PC either. Dan -----Original Message----- From: accessd-bounces at databaseadvisors.com [mailto:accessd-bounces at databaseadvisors.com] On Behalf Of Max Wanadoo Sent: Friday, January 15, 2010 9:36 AM To: Access Developers discussion and problem solving Subject: Re: [AccessD] Form Closing Problem - New(?) Dan, why not remove the X and force closure from the button. Max On 15/01/2010, RANDALL R ANTHONY <RRANTHON at sentara.com> wrote: > Dan, I think you need... > > DoCmd.Close acForm, FormName, acSaveNo > >>>> On 1/15/2010 at 9:47 AM, in message >>>> <1E1D20B6B8184B2A8328033C3D0A775B at danwaters>, "Dan Waters" >>>> <dwaters at usinternet.com> wrote: > 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. > > 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'. > > 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. > > Has anyone seen this issue? How did you solve it? > > Thanks! > Dan > > > > > -- > AccessD mailing list > AccessD at databaseadvisors.com > http://databaseadvisors.com/mailman/listinfo/accessd > Website: http://www.databaseadvisors.com ( http://www.databaseadvisors.com/ > ) > -- > 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 -- 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 -- 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