William Hindman
wdhindman at dejpolsystems.com
Fri Jan 23 01:22:21 CST 2009
...just a brief follow-up ...I've now tested all of the subform events after setting the parent subform sourceobject to "" and they work as expected with or without the docmd.close ...anything I put in the subform unload event ran before the subform closed even when I set the sourceobject to another subform. ...setting the subform sourceobject from the parent resulted in the same behavior. William -------------------------------------------------- From: "William Hindman" <wdhindman at dejpolsystems.com> Sent: Wednesday, January 21, 2009 4:56 PM To: "Access Developers discussion and problem solving" <accessd at databaseadvisors.com> Subject: Re: [AccessD] subform close ...solved > ...form closes ...depends on what you have in that line as to what happens > before you close ...I've not tested the events like unload yet to see what > the full sequence is ...one thing at a time ...its all us old geezers can > manage these days :) > > William > > -------------------------------------------------- > From: "jwcolby" <jwcolby at colbyconsulting.com> > Sent: Wednesday, January 21, 2009 4:30 PM > To: "Access Developers discussion and problem solving" > <accessd at databaseadvisors.com> > Subject: Re: [AccessD] subform close ...solved > >> William, >> >> What happens if you just remove the first line? >> >> John W. Colby >> www.ColbyConsulting.com >> >> >> William Hindman wrote: >>> ..just to finalize this thread, the following code works totally from >>> within >>> the subform ...don't have to move focus or use the host ...click on the >>> cmd >>> button and the first line works to cleanup the subform itself ...then >>> the >>> second line removes the form from the parent subform control and >>> replaces >>> it >>> with my "big ugly blank" ...or anything you want >>> >>> Private Sub cmdClose_Click() >>> On Error GoTo Err_cmdClose_Click >>> >>> >>> DoCmd.Close acForm, "frm_SystemColors_sub", acSaveNo >>> Me.Parent!Switchboard_Subform.SourceObject = "frm_Main_sub" >>> >>> Exit_cmdClose_Click: >>> Exit Sub >>> >>> Err_cmdClose_Click: >>> MsgBox Err.Description >>> Resume Exit_cmdClose_Click >>> >>> End Sub >>> >>> ...next is figuring out how to pass openargs from subform to subform >>> when >>> necessary. >>> >>> ...thanks to all who responded. >>> >>> >>> William >>> >>> -------------------------------------------------- >>> From: "Max Wanadoo" <max.wanadoo at gmail.com> >>> Sent: Wednesday, January 21, 2009 2:11 PM >>> To: "'Access Developers discussion and problem solving'" >>> <accessd at databaseadvisors.com> >>> Subject: Re: [AccessD] subform close >>> >>>> Or just load it directly with this.... >>>> >>>> [Forms]![MyMainFormName]![MyHostCotainerOnMainFormName].SourceObject = >>>> "myDefaultBlankForm" >>>> >>>> Max >>>> >>>> >>>> -----Original Message----- >>>> From: accessd-bounces at databaseadvisors.com >>>> [mailto:accessd-bounces at databaseadvisors.com] On Behalf Of William >>>> Hindman >>>> Sent: 21 January 2009 19:01 >>>> To: Access Developers discussion and problem solving >>>> Subject: Re: [AccessD] subform close >>>> >>>> JC/max >>>> >>>> ...thanks ...that works for now ...I was close but my syntax wasn't >>>> getting >>>> it done. >>>> ...as for the "big ugly blank" concern I have a default form that >>>> automatically loads whenever the subform control is empty. >>>> >>>> William >>>> >>>> -------------------------------------------------- >>>> From: "Max Wanadoo" <max.wanadoo at gmail.com> >>>> Sent: Wednesday, January 21, 2009 12:49 PM >>>> To: "'Access Developers discussion and problem solving'" >>>> <accessd at databaseadvisors.com> >>>> Subject: Re: [AccessD] subform close >>>> >>>>> This will do what you require William. >>>>> >>>>> [Forms]![MyMainFormName]![MyHostCotainerOnMainFormName].SourceObject = >>>>> "" >>>>> >>>>> Ie, on my system this translates into >>>>> >>>>> [Forms]![MCM_Peoplemainform]![PeoplePopSub2].SourceObject = "" >>>>> >>>>> I would normally have a series of buttons on the main form and when >>>>> clicked >>>>> the sourceobject is changed to the name of the form I want to appear, >>>>> but >>>>> setting it to "" works even when invoked from the sub form itself. >>>>> >>>>> >>>>> Max >>>>> >>>>> -----Original Message----- >>>>> From: accessd-bounces at databaseadvisors.com >>>>> [mailto:accessd-bounces at databaseadvisors.com] On Behalf Of William >>>>> Hindman >>>>> Sent: 21 January 2009 17:36 >>>>> To: Access Developers discussion and problem solving >>>>> Subject: Re: [AccessD] subform close >>>>> >>>>> ...why does anyone? ...like all programmers I'm a masochist at heart >>>>> :) >>>>> >>>>> ...experimenting with a new gui ...need to work out the kinks :) >>>>> >>>>> ...and I'm working on just that approach :) >>>>> >>>>> William >>>>> >>>>> -------------------------------------------------- >>>>> From: "Gustav Brock" <Gustav at cactus.dk> >>>>> Sent: Wednesday, January 21, 2009 4:33 AM >>>>> To: <accessd at databaseadvisors.com> >>>>> Subject: Re: [AccessD] subform close >>>>> >>>>>> Hi William >>>>>> >>>>>> Why are you doing this to yourself? >>>>>> >>>>>> That said, you may have to move the focus off the button as the first >>>>>> thing. >>>>>> Then, shouldn't this work? Haven't tried myself though: >>>>>> >>>>>> Me.Parent!NameOfSubformControl.Value = strNameOfNewSubform >>>>>> >>>>>> or >>>>>> >>>>>> Me.Parent!NameOfSubformControl.Value = Null >>>>>> >>>>>> You may need to move the code to the main form and call it from the >>>>>> subform to not let the subform kick the feet of itself away. >>>>>> >>>>>> /gustav >>>>>> >>>>>> >>>>>>>>> wdhindman at dejpolsystems.com 21-01-2009 08:26 >>> >>>>>> ...closes host and sub :( >>>>>> >>>>>> ...naming the sub instead doesn't change what I see ...the acSaveAll >>>>>> works, >>>>>> the form just doesn't disappear from the subform control >>>>>> >>>>>> ...if I change the mainform subform sourceobject from the host form, >>>>>> the >>>>>> form is either replaced by the new sourceobject or the subform goes >>>>>> blank >>>>>> if >>>>>> I set it to "" >>>>>> >>>>>> ...but that leaves me vulnerable to users closing an open subform >>>>>> from >>>>>> the >>>>>> host form without a proper close >>>>>> >>>>>> ...trying to workout the semantics for setting the mainform subform >>>>>> sourceobject from the subform ...this should be simple but I'm >>>>>> missing >>>>>> something. >>>>>> >>>>>> William >>>>>> >>>>>> -------------------------------------------------- >>>>>> From: "Rocky Smolin at Beach Access Software" >>>>>> <rockysmolin at bchacc.com> >>>>>> Sent: Wednesday, January 21, 2009 12:08 AM >>>>>> To: "'Access Developers discussion and problem solving'" >>>>>> <accessd at databaseadvisors.com> >>>>>> Subject: Re: [AccessD] subform close >>>>>> >>>>>>> Wait, I see. I think you have to specify the form name of the host >>>>>>> form: >>>>>>> DoCmd.Close acForm, ObjectName >>>>>>> >>>>>>> >>>>>>> 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 William >>>>>>> Hindman >>>>>>> Sent: Tuesday, January 20, 2009 8:47 PM >>>>>>> To: Access Developers discussion and problem solving >>>>>>> Subject: [AccessD] subform close >>>>>>> >>>>>>> ...subform hosted on non-linked main form >>>>>>> >>>>>>> ...command button on subform >>>>>>> >>>>>>> DoCmd.Close ...button animates but form doesn't close >>>>>>> >>>>>>> ...thinking that I'm probably going to have to set the mainform >>>>>>> subform >>>>>>> sourceobject to "" or another object and clean up anything on the >>>>>>> open >>>>>>> subform such as dirty data before I do it. >>>>>>> >>>>>>> ...anyone done this and have tested code or suggestions? >>>>>>> >>>>>>> William >>>>>> >>>>>> -- >>>>>> 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 >