Switch Between Open Applications Using AppActivate in Microsoft Access VBA

[@dwightdonahue2233]

Ive had great success connecting Access to Photoshop, and getting Access to help automate the generation of product images. Thank you for your great videos.

[@599CD]

Welcome

[@ngvancuong88]

Thank you for the excellent video. Rost, Richard I can do my automation tasks by switching between two window applications with the strick using short tille such as AppActivate "Excel"; AppActivate "Word"; AppActivate "D-Geo Stability".

[@CollDott]

Thank you for confirming and shed some much needed sunshine Chief!! The id way doesnt work no matter how have tried and resourced and tried!! 😅 But there is this vid showcasing the appactivate and in it, it worked!! Baffled and popped the question the owner i guessed busy!!

[@599CD]

No doubt!

[@ryeaton]

Yes, more of this type of stuff! I love it.

[@599CD]

Thanks

[@bgroves816]

Great Video. How do you close a program (such as File Explorer) with VBA?

[@bumpersmith]

Yes, I would like to learn more about this stuff. I can see where this could be extremely Useful

[@599CD]

Roger that

[@mitchell2769]

Great video! I’m interested in programatically activating Access windows, like forms and tables, and forms and tables that aren’t open. Could you do a video on that?

[@599CD]

That's just a matter of DoCmd.OpenForm, etc. if it's INSIDE Access

[@changseokkang6252]

It is a great lesson. I have a question on the send keys to invoke MS snipping tool ( "Shift+Win+S"). Is there any way to switch another app and copy some of the screen and switch to another app and paste the copied one? Thanks.

[@599CD]

599cd.com/ask

[@gregoryjeffries8475]

Cool, would like to see more.

[@599CD]

Roger that

[@imadabiakl1258]

i am using appactivate and sndkeys to send messages via WhatsApp to clients, the issue is that i have to go through the webbrowser in order to jump into the WhatsApp application and directly to the contact, is there a way to skip passing to through the web browser?

[@599CD]

Not if it's a website. You kinda need a browser unless they support direct API calls.

[@boerinbeton7052]

Great video as always, show as more

[@599CD]

Thanks

[@trevollpereira2706]

Because the variable was set, the variable should be set as long to accommodate larger ID numbers

[@giovannibortolotti6686]

Thanks Richard!!!

[@599CD]

welcome

[@June-tr8hg]

Interesting. Can I open a form from a different database ( in the same file location)

[@599CD]

599cd.com/QQ

[@19chade]

Thank you

[@599CD]

Welcome

[@diegomarino25]

HI, i'd like to know the bank stuff, how to put values in textbox in a web page

[@599CD]

K. I think I'm going to wait until MS releases the NEW webbrowser control for Access.

[@diegomarino25]

@@599CD thanks, didn't know they are to release a new web browser

[@dbdata9836]

thanks

[@599CD]

Welcome

[@robertodc62]

richard something about execute some windows api's

[@599CD]

Huh?

[@robertodc62]

@@599CD sorry for my english for example shut down the computer feom access or call the windows explorer well that i see it i call the exe but something like the shut down the computer

[@robertstoner6200]

After you do the addition on the calculator it changes the Task Id.

[@599CD]

Yeah, I never trusted those IDs.

[@gonefishing2006]

I have done the following with Notepad and got the same error as the Calc.exe. It works fine with Word. Dim MyAppID MyAppID = Shell("C:\Windows\System32 otepad.exe", vbNormalFocus) AppActivate MyAppID ' Activate Microsoft Notepad Regardless I get error 5 What gives and if I don't hear anything I'll be sending everybody Tribbles for Christmas....

[@599CD]

Well I didn't get my Tribble... soooo......

[@gonefishing2006]

@@599CD I trouble shooted. Shot my computer. Brought it back to life and viola darned thing worked .... finally.