[AccessD] Data Has Been Changed

Rocky Smolin at Beach Access Software rockysmolin at bchacc.com
Tue Jul 29 17:59:44 CDT 2008


Ooh. Tricky.  I'll try it. 


Rocky Smolin
Beach Access Software
858-259-4334
www.e-z-mrp.com
www.bchacc.com
 
 

-----Original Message-----
From: accessd-bounces at databaseadvisors.com
[mailto:accessd-bounces at databaseadvisors.com] On Behalf Of Robert
Sent: Tuesday, July 29, 2008 3:54 PM
To: 'Access Developers discussion and problem solving'
Subject: Re: [AccessD] Data Has Been Changed

Rocky
 Try

  Form_Matters.MatterActionsSubform.Form.Dirty = False


WBR
 ~ Robert


-----Original Message-----
From: accessd-bounces at databaseadvisors.com
[mailto:accessd-bounces at databaseadvisors.com] On Behalf Of Rocky Smolin at
Beach Access Software
Sent: Tuesday, July 29, 2008 6:31 PM
To: 'Access Developers discussion and problem solving'
Subject: Re: [AccessD] Data Has Been Changed

It gets a little more complicated here.  The field I changed in Form A is
also bound in Form B.  So I need to save the record in form B from Form A.
Don't know how to do that.  DoCmd.RunCommand acSaveRecord only works for the
form it's in.  I suppose I could put the DoCmd into a module in Form B and
call it from Form A.  But that seems a little kludgey.

I worked around it by doing a Requery from A to B but that's not a good
solution. (I don't even know why it worked.)

Rocky Smolin
Beach Access Software
858-259-4334
www.e-z-mrp.com
www.bchacc.com
 
 

-----Original Message-----
From: accessd-bounces at databaseadvisors.com
[mailto:accessd-bounces at databaseadvisors.com] On Behalf Of Robert
Sent: Tuesday, July 29, 2008 2:21 PM
To: 'Access Developers discussion and problem solving'
Subject: Re: [AccessD] Data Has Been Changed

Rocky,
 Does saving (.Dirty = False) the record before updating work?


WBR
~Robert


-----Original Message-----
From: accessd-bounces at databaseadvisors.com
[mailto:accessd-bounces at databaseadvisors.com] On Behalf Of Rocky Smolin at
Beach Access Software
Sent: Tuesday, July 29, 2008 3:46 PM
To: 'Access Developers discussion and problem solving'
Subject: [AccessD] Data Has Been Changed

Dear List:
 
 
I'm updating a field on different form that the one I'm on using:        
 
Forms!Matters!MatterActionsSubform!DueDate = Me.ActionDate

and I get an error 7878 Data has been changed.  If I debug and hit F5 it
carries on OK and updates the field in the target form.
 
But I can't find much about this 7878 or how to work around the problem.
 
Does anyone have any experience with this error?
 
MTIA
 


 	
	
 

Rocky Smolin

Beach Access Software

858-259-4334

www.e-z-mrp.com <http://www.e-z-mrp.com/> 

www.bchacc.com <http://www.bchacc.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