Autoplay
Autocomplete
Previous Lesson
Complete and Continue
Microsoft Access VBA, Design and Advanced Methods Workshop 3
Section 1: Introduction and Overview
Introduction (2:24)
Section 2: Using SendKeys and SelStart
What is SendKeys and How and When to Use It (8:33)
Using SelStart Instead of SendKeys (11:13)
Fix the Customer Prompt (3:00)
Using SelLength and SelStart with Text Boxes (4:26)
Section 3: Creating a Stopwatch Program
Create a New Module and the Stopwatch Function (7:40)
Finish the StopWatch and Test (3:57)
Section 4: Understanding and Using AutoKeys
What Is AutoKeys? (3:53)
Section 5: Generating Random Values
Setting Up a Random Values Example (6:30)
Finish and Run the Plug Customer Type Function (3:53)
Section 6: Create a Generic Three Button Form
Create the New Form and Add Controls (8:44)
Create the Open and Click Subroutines (8:33)
Create the Add Customer Button (9:07)
Modify the Three Button Form (4:44)
Finish the Add Customer Subroutine (8:20)
Section 7: Design Challenge - Cleaning Phone Number Data
Examine Records and Create FixPhone Function (6:09)
Start Building the FixPhone Function (8:02)
Finish the FixPhone Function (8:03)
Final Fixes on the NewPhone Data (9:24)
Modify FixPhone into a Generic Tool (6:48)
Section 8: Conclusion
Conclusion and Review (2:58)
Teach online with
Finish the Add Customer Subroutine
Lesson content locked
If you're already enrolled,
you'll need to login
.
Enroll in Course to Unlock