Saphirah
Active member
- Local time
- Today, 11:10
- Joined
- Apr 5, 2020
- Messages
- 163
Hello everyone,
i am currently creating a vba solution for outlook to communicate with my access application.
I created a custom Button in the Outlook Header Bar, that calls access to open a form. So far so good.
Now i want vba to set the focus from outlook to access, so that i can immediately start writing, without having to click the access window first.
For this i used
for ProjectName being the name that is displayed on top of the access application.
But the focus remains on outlook.
Maybe this happens because i am pressing the outlook button, so the code is running while the button is pressed. Maybe outlook takes back the focus once the code is finished and the button "released".
Is there maybe another way to do this? Am i doing something wrong?
Thank you very much for your help!
i am currently creating a vba solution for outlook to communicate with my access application.
I created a custom Button in the Outlook Header Bar, that calls access to open a form. So far so good.
Now i want vba to set the focus from outlook to access, so that i can immediately start writing, without having to click the access window first.
For this i used
Code:
AppActivate ProjectName
But the focus remains on outlook.
Maybe this happens because i am pressing the outlook button, so the code is running while the button is pressed. Maybe outlook takes back the focus once the code is finished and the button "released".
Is there maybe another way to do this? Am i doing something wrong?
Thank you very much for your help!