Using a Popup Form - How do I get it to pop up over other programs?

[grantwilliams]

Hi,

I'm using an idle time detection script to automatically log users out of our database after 30 minutes of inactivity. This is working fine.

I have added a form which has popup, dialog and modal properties all set to 'Yes'. This form has a command button which resets the counter if clicked. The form pops up at 25 minutes of activity and if not clicked, remains for 5 minutes at which time the database saves any changes and closes.

The problem I am having is that this popup form comes up when the database is minimised (as I want it to), but pops up UNDER any programs which have the focus. It only appears on top when the database has focus.

How do I get this popup to grab the focus and be visible to the user even when they are using another program? I am using Access 97.

Thanks!

Grant

 

[PHV]

Have you tried the AppActivate function ?

Hope This Help, PH.
Want to get great answers to your Tek-Tips questions? Have a look at FAQ219-2884 or FAQ222-2244

 

[grantwilliams]

Thanks PHV,

Worked a treat!

Grant