Thread: Set Focus / AppActivate to Access
View Single Post
 
Old 12-05-2019, 01:02 AM
travb81 travb81 is offline Windows 10 Office 2016
Novice
  
Join Date: Aug 2017
Posts: 11
travb81 is on a distinguished road
Default Set Focus / AppActivate to Access
I've got some code, which grabs the open Access.Application object.
It run's some code in the Access application, which is pretty cool.

But i'm having problems setting the focus / activating the Access window.

AppActivate works great in other Office applications, but does NOT seem to exist in Outlook?

Code:
    Dim appAccess As Access.Application
    Set appAccess = GetObject(, "Access.Application")
    appAccess.Run "openjobdetailsform", GetJobID(strJobNumber)

   'Set the focus somehow!
Reply With Quote