Microsoft Office Forums

Go Back   Microsoft Office Forums > >

 
 
Thread Tools Display Modes
Prev Previous Post   Next Post Next
  #1  
Old 12-05-2019, 01:02 AM
travb81 travb81 is offline Set Focus / AppActivate to Access Windows 10 Set Focus / AppActivate to Access Office 2016
Novice
Set Focus / AppActivate to Access
 
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
 



Similar Threads
Thread Thread Starter Forum Replies Last Post
Set Focus / AppActivate to Access Run Macro on Cell Lost Focus hockeyman9474 Word VBA 1 04-03-2017 04:31 PM
Set Focus / AppActivate to Access Start macro when placeholder gets focus PellePetimeter Word VBA 5 03-16-2017 04:26 AM
Set Focus / AppActivate to Access 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

Other Forums: Access Forums

All times are GMT -7. The time now is 12:41 AM.


Powered by vBulletin® Version 3.8.11
Copyright ©2000 - 2025, vBulletin Solutions Inc.
Search Engine Optimisation provided by DragonByte SEO (Lite) - vBulletin Mods & Addons Copyright © 2025 DragonByte Technologies Ltd.
MSOfficeForums.com is not affiliated with Microsoft