Activate window / focus over other apps

[wheeledgoat]

Howdy you Access experts,

I'm having a devil of a time googling for this solution, I think because the terms are so mushy (or maybe I don't know the right term to use).

If code (ran on a timer) finds new records on the backend db, I want to give focus to the frontend Access Form
-the form will be in popup mode
-the rest of Access will be minimized - the user will only see their popup form

I understand how the .setfocus works WITHIN access - but I need this form to take focus on the computer, popping up above other applications and programs outside of Access.

Is this possible with VBA from within Access? I'm pretty sure IT will not appreciate me breaking out autohotkey scripts...

 

[isladogs]

Have a look at various solutions shown in my example database https://www.access-programmers.co.uk/forums/showthread.php?t=293584
Hopefully you will find what you are looking for.

 

[wheeledgoat]

Thanks isladogs - but I wasn't even sure WHAT I was looking for. I could be looking right at what I need and not know it. That's a very nicely polished demo db you have there, though! I can see why you're so quick to share it. Thanks!

I found a specifically helpful answer here:
access-programmers.co.uk/forums/showthread.php?t=52635

But that opened a can of worms that is the AppTitle property, that is apparently not available by default with newer versions of Access and has to be manually added before it can be used. Found help with that here:
utteraccess.com/forum/index.php?showtopic=2040994&st=0&gopid=2711675&#entry2711675

But ultimately all that added more complexity than it was worth. A simple

AppActivate "frmFormName"

was all I needed to get the functionality I was looking for.

 

[isladogs]

Hi
Glad you have a simple solution
TBH I wasn't sure what you wanted to do either

For info I edited your post & 'activated' your links to assist others.
You'll be able to provide working links yourself after 10 posts