[AccessD] Form Closing Problem - New(?)

Max Wanadoo max.wanadoo at gmail.com
Fri Jan 15 11:35:48 CST 2010


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




More information about the AccessD mailing list