Тёмный

Using the SendKeys Function in Microsoft Access; the King of "Good Enough Sometimes" Functions. 

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

In this Microsoft Access tutorial, I will teach you about the SendKeys function. You can use it to make your VBA code act just like someone is typing at the keyboard. It has pros and cons. We'll address some of those in this video, and I'll show you a few examples. I'll explain when you could use it, and when you shouldn't use it.
LEARN MORE:
599cd.com/SendKeys
PRE-REQUISITE:
Intro to VBA: 599cd.com/IntroVBA
RECOMMENDED COURSES:
Access Developer 1: 599cd.com/ACD1
LINKS:
Evil Access Stuff: 599cd.com/EvilAccessStuff
MS SendKeys Reference: tinyurl.com/y57rx8ba
Caps Lock On Off: 599cd.com/CapsLockOnOff
Value From a Form: 599cd.com/FormName
SQL with Access: 599cd.com/SQLwithAccess
Using Recordsets: 599cd.com/Recordset
Caps Lock On Off: 599cd.com/CapsLockOnOff
Fill In PDF Form: 599cd.com/FillInPDF
Text File I/O: 599cd.com/ACD30
NITPICK:
Yes, yes, I know. SendKeys is technically not a function. It doesn't return a value. It is a statement or procedure.
BECOME A MEMBER:
RU-vid: / @599cd
or My Site: 599cd.com/THMember
ADDITIONAL RESOURCES:
FREE Access Beginner Level 1: 599cd.com/Free1
$1 Access Level 2: 599cd.com/1Dollar
Donate to my Tip Jar: 599cd.com/TipJar
Get on my Mailing List: 599cd.com/YTML
Contact Me: 599cd.com/Contact
TechHelp: 599cd.com/TechHelp
Consulting Help: 599cd.com/DevNet
Twitter: / learningaccess
en.wikipedia.org/wiki/Microso...
products.office.com/en-us/access
microsoft.com/en-us/microsoft...
KEYWORDS
access 2016, access 2019, access 2021, access 365, microsoft access, ms access, ms access tutorial, #msaccess, #microsoftaccess, #help, #howto, #tutorial, #learn, #lesson, #training, #database, #fasttips, Using the SendKeys Method, What are SendKeys in VBA, send keystrokes anywhere, sendkeys to another application, sendkeys not working, automate
QUESTIONS:
Please feel free to post your questions or comments below. Thanks.

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

 

24 окт 2022

Поделиться:

Ссылка:

Скачать:

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

Добавить в:

Мой плейлист
Посмотреть позже
Комментарии : 16   
@tajuddinidrisi6610
@tajuddinidrisi6610 Год назад
I never used SendKeys function, but you explained it in better way
@user-dz8uv8ks4h
Hi Richard!
@gonefishing2006
What is the better other option - and a link to your video on it members or not Again.... I'm really close to pulling that trigger because SendKeys is so iffy for me.
@Jojosmith342
@Jojosmith342 Год назад
Hi Richard, it does not show the key on mine. Is it because of the older Access version of 2016? I could not finish my question last night as youtube did not work. Sendkey does work on part note pad. Thanks Richard for your super quick reply. You're SUPER !
@donaldshroyer8633
@donaldshroyer8633 Год назад
I use Sendkeys to enter a field value equal to the last value entered (Ctrl apostrophe). What is the better way to do that?
@ssdusd
@ssdusd Год назад
Ho can I make Shell to open "Snip & Sketch"?
@RockasKane
@RockasKane Год назад
In your "Evil Access Stuff" you advise to remove layout.
@Paulheuer1
@Paulheuer1 Год назад
Ijust want to talk to same obu
Далее
Редакция. News: 128-я неделя
57:33
Просмотров 1,9 млн
Build A Progress Bar In Access
13:51
Просмотров 8 тыс.
5 Excel Secrets You'll Be Embarrassed You Didn't Know
17:32