AppActivate with Current Database name

[Matthew Pfluger]

I have a database app that calls other applications through COM. One of
these applications steals focus, and I want to restore focus to the Access
application. The Access application has a Database name, and that seems to
cause the AppActivate command to not function correctly. Can anyone explain
how to set focus back to the Access database if it has its own Application
Title?

Thanks,
Matthew Pfluger

 

[Clifford Bass]

Hi Matthew,

Try this:

AppActivate CurrentDb.Properties("AppTitle").Value

Clifford Bass