Тёмный

Switch Between Open Applications Using AppActivate in Microsoft Access VBA 

Computer Learning Zone
Подписаться 237 тыс.
Просмотров 6 тыс.
50% 1

Опубликовано:

 

8 сен 2024

Поделиться:

Ссылка:

Скачать:

Готовим ссылку...

Добавить в:

Мой плейлист
Посмотреть позже
Комментарии : 40   
@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
@CollDott
@CollDott 8 месяцев назад
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 8 месяцев назад
No doubt!
@ryeaton
@ryeaton Год назад
Yes, more of this type of stuff! I love it.
@599CD
@599CD Год назад
Thanks
@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".
@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
@bgroves816
@bgroves816 Год назад
Great Video. How do you close a program (such as File Explorer) with VBA?
@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.
@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
@boerinbeton7052
@boerinbeton7052 Год назад
Great video as always, show as more
@599CD
@599CD Год назад
Thanks
@19chade
@19chade Год назад
Thank you
@599CD
@599CD Год назад
Welcome
@giovannibortolotti6686
@giovannibortolotti6686 Год назад
Thanks Richard!!!
@599CD
@599CD Год назад
welcome
@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
@dbdata9836
@dbdata9836 Год назад
thanks
@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
@robertstoner6200
@robertstoner6200 Год назад
After you do the addition on the calculator it changes the Task Id.
@599CD
@599CD Год назад
Yeah, I never trusted those IDs.
@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
@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
@gonefishing2006
@gonefishing2006 8 месяцев назад
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 8 месяцев назад
Well I didn't get my Tribble... soooo......
@gonefishing2006
@gonefishing2006 8 месяцев назад
@@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
Мама знает где все документы
00:21
The Most Elite Chefs Ever!
00:35
Просмотров 4,5 млн
▼ЮТУБ ВСЁ, Я НА ЗАВОД 🚧⛔
30:49
Просмотров 456 тыс.
Restaurant POS in Microsoft access with source code
18:31
Shell Function in VBA || Open PDF file using VBA
9:12
How to Use Sleep to Pause VBA in MS Access
8:42
Просмотров 4,5 тыс.
How to Get a Value from a Subform in Microsoft Access
17:32
Мама знает где все документы
00:21