Set Focus / AppActivate to Access

travb81 · #1 12-05-2019, 01:02 AM

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!

travb81 · #2 12-12-2019, 08:53 PM

Still stuck on this one... in case anyone has any ideas? 🙏🙏🙏

macropod · #3 12-12-2019, 11:37 PM

Did you set an Outlook VBA reference to Access?

Similar Threads
Thread	Thread Starter	Forum	Replies	Last Post
Run Macro on Cell Lost Focus	hockeyman9474	Word VBA	1	04-03-2017 04:31 PM
Start macro when placeholder gets focus	PellePetimeter	Word VBA	5	03-16-2017 04:26 AM
Word Loses Focus	G&G Danny	Word	2	03-11-2014 02:17 AM
Help with forms (shifting focus)	jrh312	Word	0	11-19-2009 12:59 PM
Set focus on a textfield on a repeating table	happydigit	Misc	0	11-24-2005 04:12 AM