[AccessD] Update or CancelUpdate Without Addnew or Edit

Max Wanadoo max.wanadoo at gmail.com
Mon Sep 21 15:18:41 CDT 2009


Oh, and using individual sub forms allows you to encapsulate "stuff" for
each subform away from all the rest. Much easier to maintain.

You can make them  look just like tabs to the user.  User clicks a tab and
the subform loads with the relevant data.

Max


-----Original Message-----
From: accessd-bounces at databaseadvisors.com
[mailto:accessd-bounces at databaseadvisors.com] On Behalf Of Charlotte Foust
Sent: 21 September 2009 20:57
To: Access Developers discussion and problem solving
Subject: Re: [AccessD] Update or CancelUpdate Without Addnew or Edit

>Best of all, drop the multi-tab subform and replace with buttons.  Must
faster and easier to maintain.

NOT!

Charlotte 

-----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