Rocky Smolin
rockysmolin at bchacc.com
Mon Sep 21 19:01:35 CDT 2009
Usually when I 'fix' something I stop looking. I told the client - who is short of funds - that the fix really didn't solve the problem but works around it. Given the complexity of the form, I'm not sure that figuring out where the problem is would result in a better solution than I already implemented. And might take a couple of hours. Or more. Good for me. Fun. But uneconomical. Rocky -----Original Message----- From: accessd-bounces at databaseadvisors.com [mailto:accessd-bounces at databaseadvisors.com] On Behalf Of Max Wanadoo Sent: Monday, September 21, 2009 3:49 PM To: 'Access Developers discussion and problem solving' Subject: Re: [AccessD] Update or CancelUpdate Without Addnew or Edit So, that seems to imply that a record has been made "dirty" by code. Can you find out where that is happening and then you can solve the issue properly, otherwise it may bite again. Max -----Original Message----- From: accessd-bounces at databaseadvisors.com [mailto:accessd-bounces at databaseadvisors.com] On Behalf Of Rocky Smolin Sent: 21 September 2009 23:45 To: 'Access Developers discussion and problem solving' Subject: Re: [AccessD] Update or CancelUpdate Without Addnew or Edit Me.Refresh seemed to work on my Vista/07 machine. I could not reproduce the error on my XP/03 machine although the client could. So I sent it off to him for testing. That's really where it has to work. Rocky -----Original Message----- From: accessd-bounces at databaseadvisors.com [mailto:accessd-bounces at databaseadvisors.com] On Behalf Of Max Wanadoo Sent: Monday, September 21, 2009 1:13 PM To: 'Access Developers discussion and problem solving' Subject: Re: [AccessD] Update or CancelUpdate Without Addnew or Edit Try opening it normally and see if the error is still there. Max -----Original Message----- From: accessd-bounces at databaseadvisors.com [mailto:accessd-bounces at databaseadvisors.com] On Behalf Of Rocky Smolin Sent: 21 September 2009 21:05 To: 'Access Developers discussion and problem solving' Subject: Re: [AccessD] Update or CancelUpdate Without Addnew or Edit Because the form opens slowly, I open it when launching the app and invisiblize it until needed. I put a Me.Refresh into the Activate event and will send for testing. Me.Dirty = False would probably do the same thing? Rocky -----Original Message----- From: accessd-bounces at databaseadvisors.com [mailto:accessd-bounces at databaseadvisors.com] On Behalf Of Max Wanadoo Sent: Monday, September 21, 2009 12:51 PM To: 'Access Developers discussion and problem solving' Subject: Re: [AccessD] Update or CancelUpdate Without Addnew or Edit If this has just happened on a form which hitherto was working ok, then do a rebuild. If you have added any code to make changes to the data on the form (either directly or via a Query) then put a me.dirty=false to ensure the change is written away immediately. Best of all, drop the multi-tab subform and replace with buttons. Must faster and easier to maintain. Max -----Original Message----- From: accessd-bounces at databaseadvisors.com [mailto:accessd-bounces at databaseadvisors.com] On Behalf Of Rocky Smolin Sent: 21 September 2009 20:03 To: 'Access Developers discussion and problem solving' Subject: [AccessD] Update or CancelUpdate Without Addnew or Edit Dear List: I have a rather complex form with a multi-page tab. Some of the tabs have subforms When I open the form and click in an empty space on the subform I get the message "Update or CancelUpdate Without Addnew or Edit". If I go to any other tab page with a subform and click anywhere on the subform I get the message. One of the tab pages generates the message without even clicking. I can click on any tab page which does not have a subform with no problem. I get this problem in 2007 but not 2003. My client has it in 2007 and 2003. But not on all machines. I'm stumped. Any ideas welcome. MTIA Rocky -- 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