The King of Good Enough Sometimes Functions

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 should not use it.

Pre-Requisite

• Intro to VBA: https://599cd.com/IntroVBA

Recommended Course

• Access Developer 1: https://599cd.com/ACD1

Notes

• Shift +
• Ctrl ^
• Alt %
• Enter ~
• Remember to specify lowercase letters, otherwise you get Shift-whatever!
• {LEFT 15} means press the left arrow key 15 times

Links

• Evil Access Stuff: https://599cd.com/EvilAccessStuff
• MS SendKeys Reference: https://tinyurl.com/y57rx8ba
• Caps Lock On Off: https://599cd.com/CapsLockOnOff
• Value From a Form: https://599cd.com/FormName
• SQL with Access: https://599cd.com/SQLwithAccess
• Using Recordsets: https://599cd.com/Recordset
• Caps Lock On Off: https://599cd.com/CapsLockOnOff
• Fill In PDF Form: http://599cd.com/FillInPDF
• Text File I/O: https://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.

Learn More FREE Access Beginner Level 1 FREE Access Quick Start in 30 Minutes Access Level 2 for just $1 Free Templates TechHelp Free Templates Blank Template Contact Management Order Entry & Invoicing More Access Templates

Resources Diamond Sponsors - Information on our Sponsors Mailing List - Get emails when new videos released Consulting - Need help with your database Tip Jar - Your tips are graciously accepted Merch Store - Get your swag here! Questions? Please feel free to post your questions or comments below or post them in the Forums.

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