#1
|
|||
|
|||
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! |
#2
|
|||
|
|||
Still stuck on this one... in case anyone has any ideas? 🙏🙏🙏
|
#3
|
||||
|
||||
Did you set an Outlook VBA reference to Access?
__________________
Cheers, Paul Edstein [Fmr MS MVP - Word] |
Thread Tools | |
Display Modes | |
|
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 |