[AccessD] Update or CancelUpdate Without Addnew or Edit

Max Wanadoo max.wanadoo at gmail.com
Mon Sep 21 15:13:27 CDT 2009


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




More information about the AccessD mailing list