This lesson shows how to how to Fix the Problems which have come up with the Buttons on the Forms that were made during the SDC Buttons Lesson.
Doing this Lesson will provide great experience in using Macro Commands, Using Submacros, Form Load and Update Events, and Writing VBA Code.
The Step by Step Guide which is available below for this lesson shows exactly what needs to be done and is a FREE PDF Doc of Instructions available at the Link shown later below.
FORMS LESSON CONTENTS
The Video Lesson and the Download Step By Step Guide both contain the following:
- Fixing Button Macros - Overview
- Client Form Button Fixes – START DB
- Access Demonstration of What Needs Fixing
- Additional Fixes which are Required
- Things You Need to Know Already
- Link to Download Word Doc of Fixes
- Problem 1 – Prev Button Macro Crash
- Problem 2 – New Member Disables Next Button
- Problem 3 - Record Delete Breaks Prev and Next Buttons
- Problem 4 - New Member Records and Validation
- Fix to Reference Members while Adding a New Dog
- Fix to Add Save Confirmation Message
- Fix to Add Blank Field Checking for New Records
- Saving the Database
- Where to Next
- Our Website Access Course
- Video Wrap-Up and Outro
Watch the following YouTube Video Tutorial about Fixing the Form Buttons.
We recommend you use the WORD DOC Instructions
to follow along step by step with the Tutorial Video.
The YouTube Video is free to watch as many times as you want, and the Start and Finish Databases, including the PDF Summary Guide, and the Detailed Word Doc of Instructions including all required VBA Code, are available in the one package for FREE at the Webpage contained in the Link Below:
Click Here for the Free Downloads for This Button Fixes Lesson
Our Access Learning Modules are designed for complete beginners, and they have been extensively trialed with High School students learning Access for the first time. They have a proven track record of being able to get everyone up and running with Microsoft Access - the world's most popular Relational Database for Education and Small Business.
We highly recommend using the Step by Step Summary Guide as well as the other support materials to maximise learning outcomes.
Our students have found the Summary Guide to be far more useful than re-watching the Video, when it comes time for them to apply their newly acquired Access skills to Database Build tasks.
If you experience any problems please email us immediately at:
