Popup form on timer

[kathywebster]

I'm sorry if I'm doing this the wrong way. I posted this in FORMS, but got no reply:

I have a form on a timer. It pops up if certain conditions are met. I'd like it to pop up regardless of what windows program I currently have open. I know I have to have msaccess at least open and minimized, that's not a problem. The problem is that I don't see the form until I happen to switch focus back to msaccess.

Thanks!

 

[John Big Booty]

Perhaps this link will give you some pointers.

 

[kathywebster]

I forgot to mention I am a novice at VBA...will this be something I will likely be able to accomplish, or will someone be able to hold my hand?

 

[John Big Booty]

In that case, possibly this will be a bridge too far

 

[emanuelfulghum]

I will likely be able to accomplish

 

[vbaInet]

You're talking about API programming... that's advanced.

There's an API called SetForegroundWindow. Here's the link:

http://allapi.mentalis.org/apilist/SetForegroundWindow.shtml

 

[kathywebster]

Wow, that looks pretty exciting. I'm game to give it a try...
Since we have different OS's here, will it work on Win XP and Win7, knowing that the msaccess.mdb is ultimately going to be distributed at our office as an Access 2002 mde file?

 

[vbaInet]

WinXP most likely. Win7, I don't know.