[AccessD] How to start a form in acDialog mode

You're welcome.

> **********************************************************************
> * The SOLUTION transmitted is intended solely for the individual or 
> entity or lifebeing to which it is addressed and may contain 
> confidential and/or non-privileged [ref] material. Any review, 
> retransmission, infection dissemination, description, declination, 
> delineation, or disinfection, artificial insemination whether by 
> natural or other means, use of, misuse of, abuse of, de-abuse of, 
> square root of, cube root of, or taking action or not taking action, 
> or being inactive or not being inactive or even leaving that cake out 
> in the rain, should not be, shall not be, did not be in no way be 
> based on reliance and or non-reliance upon this information by persons 
> or entities or lifebeings other than the intended recipient.  Use of 
> this here postscript and entirely ripped orf material is prohibited,
prehibited, postscripted and pre-empted.
> If you have received this email in error please contact reality,  or 
> the sender and  hehehhaahahhha ....
> delete the material from any computer, e-mail server, isp or any other 
> means, forms, materials, MacDonalds wrappers, back of menus, bar 
> coasters, etc etc etc. As a recipient of this email, you are 
> responsible for screening its contents and the contents of any 
> attachments for the presence of viruses, biochemicals, viagra, 
> violins, vichy sous, voule e' vents(sp?), venting of spleens, splints, 
> sphinx(es, sphinctres, septicemia, spelling mistakes, sophistry, and 
> above all siblings. No liability is accepted for, or from, or to, or 
> above, or beside any damages caused by any virus, worm, fish, 
> pterodactyl, micro or macrobiotic entity transmitted by this email (or any
other, so there!).

The above disclaimer is perfectly legal and enforceable by and within the
galaxy Milky way, Solar system, Planet Earth, Country USA, State North
Carolina.



John W. Colby
Colby Consulting
www.ColbyConsulting.com 
-----Original Message-----
From: accessd-bounces at databaseadvisors.com
[mailto:accessd-bounces at databaseadvisors.com] On Behalf Of philippe pons
Sent: Thursday, June 28, 2007 11:29 AM
To: Access Developers discussion and problem solving
Subject: Re: [AccessD] How to start a form in acDialog mode

It works ok!
Thanks to you, I can go on this way...

<Disclaimer>
The code above is now adopted!!
</Disclaimer>

Philippe

2007/6/28, jwcolby <jwcolby at colbyconsulting.com>:
>
> To my knowledge it is not possible.  You can simulate that by putting 
> a loop immediately AFTER the line that opens the form.  Something 
> like:
>
>
> blnOtherFormClosed = false
> Do
>         DoEvents
> While not blnOtherFormClosed
>
> blnOtherFormClosed will be a global variable.
>
> Then as the other form closes, in it's OnClose event will SET 
> blnOtherFormClosed to true.  This will allow the calling form to exit 
> the loop and continue processing.
>
> Crude but it should work.
>
> <Disclaimer>
> The code above was air compiled
> </Disclaimer>
>
> John W. Colby
> Colby Consulting
> www.ColbyConsulting.com
> -----Original Message-----
> From: accessd-bounces at databaseadvisors.com
> [mailto:accessd-bounces at databaseadvisors.com] On Behalf Of philippe 
> pons
> Sent: Thursday, June 28, 2007 8:46 AM
> To: accessd at databaseadvisors.com
> Subject: [AccessD] How to start a form in acDialog mode
>
> Hi all,
>
> I have a form, say myForm, and another one, say mySisterForm, that 
> just show a combo box to the user.
>
> At one point, the vba code behind myForm will start mySisterForm to 
> allow the user toselected a value from the combo.
>
> The the code behind myForm has to start mySisterForm, and wait until 
> mySisterForm closes, and grab the selected value(put in a global
> variable!)
>
> This is well known, and I know how to do that using DoCmd acForm, 
> mySisterForm .name, , , , acDialog.
>
> But the point is I want to open mySisterForm in a different way!!
>
> Dim frm as Form
> Set frm As New Form_mySisterForm
>
> frm.visible=True
>
> is the way I want to go...but there, the code will not wait until 
> mySisterForm  closes!!!
>
> Even if I set: frm.Modal = True
>
> How would you do that, unless it is not possible?
>
> TIA,
>
> Philippe
> --
> 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