[AccessD] BringToFront

Drew Wutka DWUTKA at marlow.com
Thu Feb 1 11:33:12 CST 2007


I hear ya.  I think it should work too, but I've done enough playing around
with the windows in Access to know that there's a chance it won't.

Drew

-----Original Message-----
From: JWColby [mailto:jwcolby at colbyconsulting.com] 
Sent: Thursday, February 01, 2007 11:27 AM
To: 'Access Developers discussion and problem solving'
Subject: Re: [AccessD] BringToFront

It should work.  When I open the form, the class grabs a pointer to the
form.  So while it Me. Refers to the form class, mfrm. Refers to the form
and I can (and have) grabbed a pointer to the form window that way. 

I am attempting to use a similar set of API calls to reposition the window.
Haven't got that code straightened out yet either though.  Other fires to
put out, you know.

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 Drew Wutka
Sent: Thursday, February 01, 2007 12:05 PM
To: Access Developers discussion and problem solving
Subject: Re: [AccessD] BringToFront

Ah, asked again in a different thread.  Let me know, I'm curious, with how
you are opening those forms.

Drew

-----Original Message-----
From: JWColby [mailto:jwcolby at colbyconsulting.com]
Sent: Thursday, February 01, 2007 11:00 AM
To: 'Access Developers discussion and problem solving'
Subject: Re: [AccessD] BringToFront

I haven't tested it yet.  Other fires to put out, you know how that is. 


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 Drew Wutka
Sent: Thursday, February 01, 2007 11:15 AM
To: Access Developers discussion and problem solving
Subject: Re: [AccessD] BringToFront

Well, did it do the trick?

Drew

-----Original Message-----
From: JWColby [mailto:jwcolby at colbyconsulting.com]
Sent: Wednesday, January 31, 2007 4:10 PM
To: 'Access Developers discussion and problem solving'
Subject: Re: [AccessD] BringToFront

What do you mean it doesn't stick.  Will it stick long enough for the user
to click the button and cause that form to close? 


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 Drew Wutka
Sent: Wednesday, January 31, 2007 5:00 PM
To: Access Developers discussion and problem solving
Subject: Re: [AccessD] BringToFront

Private Declare Function SetWindowPos Lib "user32" (ByVal hwnd As Long, _
ByVal hWndInsertAfter As Long, ByVal x As Long, ByVal y As Long, ByVal _ cx
As Long, ByVal cy As Long, ByVal wFlags As Long) As Long Private Const
SWP_NOMOVE = &H2 Private Const SWP_NOSIZE = &H1 Private Const HWND_TOPMOST =
-1 Private Sub PutMeOnTop()
    SetWindowPos Me.Hwnd, HWND_TOPMOST, 0, 0, 0, 0, _
    SWP_NOMOVE Or SWP_NOSIZE
End Sub

This will put the form in front of everything.  It doesn't 'stick' though.
Access forms are subclassed windows, so to put it truly always on top is a
little trickier.

Drew

-----Original Message-----
From: JWColby [mailto:jwcolby at colbyconsulting.com]
Sent: Wednesday, January 31, 2007 3:41 PM
To: 'Access Developers discussion and problem solving'
Subject: [AccessD] BringToFront

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

--
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



More information about the AccessD mailing list