Switch Between Open Applications Using AppActivate in Microsoft Access VBA

  Рет қаралды 6,148

Computer Learning Zone

Computer Learning Zone

Күн бұрын

Пікірлер: 41
@dwightdonahue2233
@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
@599CD Жыл бұрын
Welcome
@ngvancuong88
@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
@CollDott 10 ай бұрын
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
@599CD 9 ай бұрын
No doubt!
@ryeaton
@ryeaton Жыл бұрын
Yes, more of this type of stuff! I love it.
@599CD
@599CD Жыл бұрын
Thanks
@bgroves816
@bgroves816 Жыл бұрын
Great Video. How do you close a program (such as File Explorer) with VBA?
@bumpersmith
@bumpersmith Жыл бұрын
Yes, I would like to learn more about this stuff. I can see where this could be extremely Useful
@599CD
@599CD Жыл бұрын
Roger that
@mitchell2769
@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
@599CD Жыл бұрын
That's just a matter of DoCmd.OpenForm, etc. if it's INSIDE Access
@changseokkang6252
@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 Жыл бұрын
599cd.com/ask
@gregoryjeffries8475
@gregoryjeffries8475 Жыл бұрын
Cool, would like to see more.
@599CD
@599CD Жыл бұрын
Roger that
@imadabiakl1258
@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
@599CD Жыл бұрын
Not if it's a website. You kinda need a browser unless they support direct API calls.
@boerinbeton7052
@boerinbeton7052 Жыл бұрын
Great video as always, show as more
@599CD
@599CD Жыл бұрын
Thanks
@trevollpereira2706
@trevollpereira2706 Ай бұрын
Because the variable was set, the variable should be set as long to accommodate larger ID numbers
@giovannibortolotti6686
@giovannibortolotti6686 Жыл бұрын
Thanks Richard!!!
@599CD
@599CD Жыл бұрын
welcome
@June-tr8hg
@June-tr8hg Жыл бұрын
Interesting. Can I open a form from a different database ( in the same file location)
@599CD
@599CD Жыл бұрын
599cd.com/QQ
@19chade
@19chade Жыл бұрын
Thank you
@599CD
@599CD Жыл бұрын
Welcome
@diegomarino25
@diegomarino25 Жыл бұрын
HI, i'd like to know the bank stuff, how to put values in textbox in a web page
@599CD
@599CD Жыл бұрын
K. I think I'm going to wait until MS releases the NEW webbrowser control for Access.
@diegomarino25
@diegomarino25 Жыл бұрын
@@599CD thanks, didn't know they are to release a new web browser
@dbdata9836
@dbdata9836 Жыл бұрын
thanks
@599CD
@599CD Жыл бұрын
Welcome
@robertodc62
@robertodc62 Жыл бұрын
richard something about execute some windows api's
@599CD
@599CD Жыл бұрын
Huh?
@robertodc62
@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
@robertstoner6200 Жыл бұрын
After you do the addition on the calculator it changes the Task Id.
@599CD
@599CD Жыл бұрын
Yeah, I never trusted those IDs.
@gonefishing2006
@gonefishing2006 10 ай бұрын
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
@599CD 10 ай бұрын
Well I didn't get my Tribble... soooo......
@gonefishing2006
@gonefishing2006 10 ай бұрын
@@599CD I trouble shooted. Shot my computer. Brought it back to life and viola darned thing worked .... finally.
Why Use Random AutoNumbers in Microsoft Access
7:38
Computer Learning Zone
Рет қаралды 2,1 М.
Cool Parenting Gadget Against Mosquitos! 🦟👶 #gen
00:21
TheSoul Music Family
Рет қаралды 33 МЛН
А что бы ты сделал? @LimbLossBoss
00:17
История одного вокалиста
Рет қаралды 11 МЛН
What's in the clown's bag? #clown #angel #bunnypolice
00:19
超人夫妇
Рет қаралды 39 МЛН
Osman Kalyoncu Sonu Üzücü Saddest Videos Dream Engine 275 #shorts
00:29
Tracking Employee Training and/or Certifications in Microsoft Access
19:59
Computer Learning Zone
Рет қаралды 1,2 М.
STOP Using Default KPI Cards in Power BI. CUSTOMISE Other Visuals.
21:01
From Zero2BI Hero with Stelian
Рет қаралды 6 М.
PowerShell S2E57 (sendkeys)
16:04
Mr Automation
Рет қаралды 9 М.
How to Run Scripts and Open Other Applications from MS Access Using VBA
10:35
Sean MacKenzie Data Engineering
Рет қаралды 6 М.
Cool Parenting Gadget Against Mosquitos! 🦟👶 #gen
00:21
TheSoul Music Family
Рет қаралды 33 МЛН