[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