[AccessD] BringToFront

It is except that it probably won't work because of the way I open the form
- see the discussion the other day about opening a form by opening it's
class.  When you do that the form isn't "visible" to Access, essentially all
of the forms have the same "name" and since Access uses collections to store
the pointers to the forms, keyed on the form name, it just doesn't work to
store the same class more than one time using a given form name.  

Doing what I do, I am on my own for referencing the forms etc.

IOW, your method works, but only if you open it in the normal way, which I
don't. 


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 Mark A Matte
Sent: Wednesday, January 31, 2007 5:02 PM
To: accessd at databaseadvisors.com
Subject: Re: [AccessD] BringToFront

OK...I am not really sure why this works...but it may give you a solution.

I found that if you have a modal form (frmModal1) and you have non-modal
form(frmNoModal2)...and you have frmModal1 open frmNoModal2, both will have
the modal properties but you can toggle between the 2 and not any other form
open.  I then used DoCmd.SelectObject acForm, "frmNoModal2" (or
frmModal1...depending on which form) on each form to bring the other to the
front.

Is this what you are looking for?...

Mark A. Matte


>From: "JWColby" <jwcolby at colbyconsulting.com>
>Reply-To: Access Developers discussion and problem 
>solving<accessd at databaseadvisors.com>
>To: "'Access Developers discussion and problem 
>solving'"<accessd at databaseadvisors.com>
>Subject: [AccessD] BringToFront
>Date: Wed, 31 Jan 2007 16:41:10 -0500
>
>Is there a Bring To Front for a FORM?  I may have a series of progress 
>meters, which open modal, and as it happens centered and right on top 
>of each other.  I have devised a way to display an OK button which I 
>display the very last line as that process finishes IF I want the user 
>to know that a specific process finished.  The problem is that things 
>being the way they are, the one that is finishing may be physically 
>hidden by another progress meter on top.  I need to cause the progress 
>meter that is displaying the "OK to continue" to pop in front of 
>anything else that may be currently displayed.
>
>John W. Colby
>Colby Consulting
>www.ColbyConsulting.com
>


>--
>AccessD mailing list
>AccessD at databaseadvisors.com
>http://databaseadvisors.com/mailman/listinfo/accessd
>Website: http://www.databaseadvisors.com

_________________________________________________________________
Turn searches into helpful donations. Make your search count. 
http://click4thecause.live.com/search/charity/default.aspx?source=hmemtaglin
e_donation&FORM=WLMTAG

--
AccessD mailing list
AccessD at databaseadvisors.com
http://databaseadvisors.com/mailman/listinfo/accessd
Website: http://www.databaseadvisors.com