Shamil Salakhetdinov
shamil at smsconsulting.spb.ru
Sat Aug 23 17:34:25 CDT 2008
<<< If you catch my meaning here... :o) >>> Yes, I think I do catch your meaning here - I clearly remember the watches on the wall in an hotel in Hamburg I used to stay in 1998-1997 - they had a plastic fly behind the arrows and a multi-meaning title "Time flies..." - I feel that was like yesterday, and it's already 12 years have flied away as speedy as lighting... -- 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: Sunday, August 24, 2008 1:23 AM To: 'Access Developers discussion and problem solving' Subject: Re: [AccessD] Forcing Save from on one form from another form Shamil: For debugging I'm in the habit of setting a break point and then using the F8 key to follow the execution. As you know, in break mode, hovering the cursor over any variable pops up the current value of the variable. I find that to be the most effective way to trace what's happening in a program. As far as describing the code flow - I'll be 60 in December and well...time is getting shorter for me. If you catch my meaning here... :o) (IOW, it's a bit of a mess). 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