William Hindman
wdhindman at dejpolsystems.com
Thu Jan 22 11:17:40 CST 2009
...this is getting complicated :( ...but you're right, it's needed ...one more thing for my todo list ...sigh. William -------------------------------------------------- From: "Max Wanadoo" <max.wanadoo at gmail.com> Sent: Thursday, January 22, 2009 4:14 AM To: "Access Developers discussion and problem solving" <accessd at databaseadvisors.com> Subject: Re: [AccessD] subform close ...solved > Hi William, > > If there is ever going to be a case where the subform is opened as a main > form in its own right then you might want to put a test in there to see if > there actually is a "Parent" object. In some of my cases, I have it as a > sub and a main with some me.parent code in there. > > Using Stuart's function to pass args could be utilised along with Rocky's > parsing system. > > Cool eh? > > Max > > > On Wed, Jan 21, 2009 at 11:19 PM, William Hindman < > wdhindman at dejpolsystems.com> wrote: > >> Max >> >> ...agreed ...in this specific instance I don't ...but in many instances I >> will need to ensure the form is closed in the proper manner because the >> source object can be reset at any time by the user by selecting another >> node >> in the host form's treeview ...the docmd.close in this instance serves to >> remind me that cleanup is necessary and allows consistency when >> transferring >> this into a case function in a module. >> >> ...we'll disagree on the parent argument ...jc's example did not identify >> a >> problem with using parent, only that you must understand that a tab >> control >> is the parent to subforms embedded in it ...using parent rather than the >> specific host form name allows me to substantially reduce the code >> required >> when transferring this to a module. >> >> ...I'll take a look at the args methods in a few days when I get the rest >> of >> this gui straightened out and start to do real things with it. >> >> ...tks >> >> William >> >> -------------------------------------------------- >> From: "Max Wanadoo" <max.wanadoo at gmail.com> >> Sent: Wednesday, January 21, 2009 5:03 PM >> To: "'Access Developers discussion and problem solving'" >> <accessd at databaseadvisors.com> >> Subject: Re: [AccessD] subform close ...solved >> >> > William, >> > I don't think you don't need the docmd.close line. >> > Also, if you use me.parent you cannot be absolutely sure that it is >> > pointing >> > to where you *think* it is (see JC's comment earlier). I would suggest >> > you >> > use the structure when the main form is named. >> > >> > Args can be *stored* and then read from the main form be subforms (or >> > use >> > global vars), or use a text file or use a table (access uses tables) >> > >> > Max >> > >> > >> > -----Original Message----- >> > From: accessd-bounces at databaseadvisors.com >> > [mailto:accessd-bounces at databaseadvisors.com] On Behalf Of William >> Hindman >> > Sent: 21 January 2009 21:19 >> > To: Access Developers discussion and problem solving >> > Subject: Re: [AccessD] subform close ...solved >> > >> > ..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 >> > >> >> -- >> 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 >