open Form ontopmost of all windows

[perryche]

First, I want to thank all that had help in my previous posts, but I
still got 2 questions:

1. How to force a form to open from Access to popup ontop of all other
applications? Is this possible?

"Yes, this is possible. For example the Task Manager form does this. I
inspected it, and it appears it's due to the WS_EX_TOPMOST extended
window style, which you
can set with the SetWindowPos API. " (From Tom)

I am little slow in programming VB, can someone help how to code this
under OnOpenEvent ?

2. If Access is closed, because I kicked users out to do a maintenance
on the DB, then, how may I let them know once the update is complete?
(Now Access is not running, no IM program. I guess Task Manager with
a trigger may work, but how to define that trigger? What exactly is
Task Manager Form anyway, how do one create one?)

Thanks in advance,
Perry

[paii, Ron]

<pe******@yahoo.comwrote in message
news:11*********************@o61g2000hsh.googlegro ups.com...

First, I want to thank all that had help in my previous posts, but I
still got 2 questions:

1. How to force a form to open from Access to popup ontop of all other
applications? Is this possible?

"Yes, this is possible. For example the Task Manager form does this. I
inspected it, and it appears it's due to the WS_EX_TOPMOST extended
window style, which you
can set with the SetWindowPos API. " (From Tom)

I am little slow in programming VB, can someone help how to code this
under OnOpenEvent ?

2. If Access is closed, because I kicked users out to do a maintenance
on the DB, then, how may I let them know once the update is complete?
(Now Access is not running, no IM program. I guess Task Manager with
a trigger may work, but how to define that trigger? What exactly is
Task Manager Form anyway, how do one create one?)

Thanks in advance,
Perry

The NET SEND command can be used to send a message to any or all window
users.

NET SEND WindowsUserID "Test Message"

Check windows help or type NET SEND at the command prompt for help. You will
need to know the network login name or domain name.

[perryche]

So, the NET SEND command is executing thru the command prompt? How
about sending to multiple people?

Thanks for getting me a head start, I will search more info on this.

Perry