Shamil Salakhetdinov
shamil at smsconsulting.spb.ru
Sat Aug 23 17:34:25 CDT 2008
OK. -----Original Message----- From: accessd-bounces at databaseadvisors.com [mailto:accessd-bounces at databaseadvisors.com] On Behalf Of Rocky Smolin at Beach Access Software Sent: Sunday, August 24, 2008 1:20 AM To: 'Access Developers discussion and problem solving' Subject: Re: [AccessD] Forcing Save from on one form from another form Shamil: I got it to work by taking a page from raising kids - I just tried one thing and another until I got the behavior I wanted. But your .Dirty = False definitely worked and it's in the code now. 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 Shamil Salakhetdinov Sent: Saturday, August 23, 2008 11:22 AM To: 'Access Developers discussion and problem solving' Subject: Re: [AccessD] Forcing Save from on one form from another form Rocky, So, .Dirty = True worked or not? I re-tested to make sure - it works when used from outer form etc. You might have some tricky coding (that's usual for VBA), when an event is (indirectly) chaining a set of other events, which in turn (indirectly) chaining other events... Access developers are always told that MS Access VBA is single-threaded but when events "chain-reaction" is getting activated with maybe Timer event(s) processed somewhere in the same time then MS Access VBA interpreter goes really "crazy", and side effects could be many and unexpected including GPF-ing... Check what happens in your case by using tracing debug.print or writing to a log file, and use (static) flags to prevent unexpected/undesired code execution sequence... Maybe I'm exaggerating - could you describe what code flow you have?: - what control makes subform's field's value changed and subform Dirty, and how and in what part of you code you're trying to save subform's edits by using .Dirty = False or calling subform's .requery method?... Thank you. -- Shamil -----Original Message----- From: accessd-bounces at databaseadvisors.com [mailto:accessd-bounces at databaseadvisors.com] On Behalf Of Rocky Smolin at Beach Access Software Sent: Saturday, August 23, 2008 9:46 PM To: 'Access Developers discussion and problem solving' Subject: Re: [AccessD] Forcing Save from on one form from another form Saving the subform record is no problem. It's reaching over from the sub-form into another unrelated form and saving the record there which has had one of its bound fields changed by the sub-form. I tried requrying the form but I get that 'Write Conflict' message. 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 Shamil Salakhetdinov Sent: Saturday, August 23, 2008 9:59 AM To: 'Access Developers discussion and problem solving' Subject: Re: [AccessD] Forcing Save from on one form from another form Yes, and additionally another trick (used starting MS Access 2.0 as the latter didn't have .Dirty property), which could be useful if your subform has just one record - your can .Requery it to save current edits. If your subform has several records this trick will also work but then you will have to set the proper subform's record position - here .RecordsetClone and .Bookmark were usually used... == Shamil -----Original Message----- From: accessd-bounces at databaseadvisors.com [mailto:accessd-bounces at databaseadvisors.com] On Behalf Of Rocky Smolin at Beach Access Software Sent: Saturday, August 23, 2008 7:28 PM To: 'Access Developers discussion and problem solving' Subject: Re: [AccessD] Forcing Save from on one form from another form Shamil: So setting .Dirty = False saves the record? TIA 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 Shamil Salakhetdinov Sent: Saturday, August 23, 2008 7:38 AM To: 'Access Developers discussion and problem solving' Subject: Re: [AccessD] Forcing Save from on one form from another form Hi Rocky, AFAIKR you can just use: Access.Application.Forms.mySecondFormName.mySubFormControlName.Form.Dirty = False or if you have an object reference (let's call it subFormControlObjectRef) of the second form's subform control then you can use: subFormControlObjectRef.Form.Dirty = False -- Shamil -----Original Message----- From: accessd-bounces at databaseadvisors.com [mailto:accessd-bounces at databaseadvisors.com] On Behalf Of Rocky Smolin at Beach Access Software Sent: Saturday, August 23, 2008 6:15 PM To: 'Access Developers discussion and problem solving' Subject: [AccessD] Forcing Save from on one form from another form Dear List: In a sub-form of a second form I am changing the value of a record on a third form which is loaded and open. That form is now dirty and I'd like to save the record on that third form from the sub-form. How can I force a save on one form from another form? 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 -- 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