Master Microsoft Access VBA: Open forms with ease, automate tasks, boost income. Enroll now for enhanced skills. Try it today! Read more.
Hello, my name is Bruce. I am a self-employed Access programmer and general computer consultant to small and medium-sized businesses. I got into programming because I was tired of all the jargon most programmers use and how they don't seem to care about business. "Technology is great but I've always been more interested in how it can be used to make companies more profitable." - Bruce I live in Portland, Oregon and have many long-term relationships with local businesses. Many of the sy
Access all courses in our library for only $9/month with All Access Pass
Get Started with All Access PassBuy Only This CourseAbout This Course
Learn how to create what I call a Recordset Walk Thru with a Double Loop. These little programs can save you lots of time and grief!
Learn how to open a form anywhere in your Access Visual Basic (VBA) code and send and receive values from it!
Learn all the Access VBA programming concepts, tools, and functions that you will need while you build a fully functional system!
Build a strong foundation in Access Visual Basic with this tutorial for Non-Programmers!
- Create VBA Subroutines for Forms and Control the Keyboard
- Extensive Training on Handling Errors
- Control Record Sorting and Searching for Specific Records
- Learn How to Move and Pass Data Between Forms
- Create Interactive Pull Down Filters for Form Data
- Build a Complex Report Entirely with VBA
- Introduction to SQL and How to Use SQL in VBA
- Turn the Ribbon and Nav Pane On and Off
- Prevent Form Closure or Resizing
- Learn How to Close Access with VBA
Powerful Skills That Increase Your Value in the Marketplace
Learning VBA programming enables you to use ALL the power of Access to easily create systems that will be in high demand with your current employer or other businesses. The practical skills taught in this class will give you a solid foundation in creating systems that people can really use!
There is a HUGE need in the marketplace for people who can create systems like this in Access. This is your opportunity to break away from the pack of people who struggle to create effective Access databases, and learn to easily automate tasks! This could be your shortest path to increasing your income!
Our Promise to You
By the end of this course, you will have the knowledge about Microsoft Access VBA.
10 Day Money Back Guarantee. If you are unsatisfied for any reason, simply contact us and we’ll give you a full refund. No questions asked.
Get started today and develop your skills in Microsoft Access VBA!
Course Curriculum
| Section 1 - Introduction | |||
| Course Overview | 00:00:00 | ||
| Setup Tasks | 00:00:00 | ||
| Direct Download Links For Database Files | 00:00:00 | ||
| Microsoft Access VBA For Non Programmers – Course Materials | 00:00:00 | ||
| Section 2 - Start Learning VBA And Handling Errors | |||
| View Database Table And Forms – Review The Goal | 00:00:00 | ||
| Create Your First VBA Subroutine! | 00:00:00 | ||
| Fix A Syntax Error And Take Over The Keyboard | 00:00:00 | ||
| Use An IF Statement And DoCmd | 00:00:00 | ||
| Use ElseIf And A Select Statement | 00:00:00 | ||
| Runtime Errors, Error Traps And Program Stops | 00:00:00 | ||
| Break Into Programs And Infinite Loops | 00:00:00 | ||
| Section 2 Conclusion And Review | 00:00:00 | ||
| Section 3 - Create Record Sorting Subroutines | |||
| On Open Event, Me Keyword And OrderBy | 00:00:00 | ||
| Subroutines For Form Controls, VBA Editing Shortcuts | 00:00:00 | ||
| Modify Subroutines To Sort DESC, More Error Handling | 00:00:00 | ||
| Section 3 Conclusion And Review | 00:00:00 | ||
| Section 4 - Use Instant Search To Learn More About The Keyboard, Recordsets And Variables | |||
| Expanding The Keydown Subroutine | 00:00:00 | ||
| Using Public Variables | 00:00:00 | ||
| Building The Search Criteria | 00:00:00 | ||
| Field Names And Reserved Words | 00:00:00 | ||
| Using A Recordset And Bookmarks | 00:00:00 | ||
| Enhancing Our Instant Search | 00:00:00 | ||
| Section 4 Conclusion And Review | 00:00:00 | ||
| Section 5 - Interact With Other Forms And Pass Information | |||
| Open Another Form With A Button Click | 00:00:00 | ||
| Send Data To The Other Form | 00:00:00 | ||
| Modify A Form To Utilize Data Sent To It | 00:00:00 | ||
| Intro To SQL And Using SQL In The Recordsource | 00:00:00 | ||
| Locate Same Record When Returning From The Form | 00:00:00 | ||
| Modify The Form To Remember The Sort | 00:00:00 | ||
| Create A Prompt To Save Changes | 00:00:00 | ||
| Activate The Add Customer Button | 00:00:00 | ||
| Testing For A Blank Record | 00:00:00 | ||
| Activate The Delete Button | 00:00:00 | ||
| Section 5 Conclusion And Review | 00:00:00 | ||
| Section 6 - Add Multiple Interactive Pulldown Filters | |||
| Setup Rowsource For Dropdown Filters | 00:00:00 | ||
| Enable Editing In the Dropdown Filters | 00:00:00 | ||
| Set Dropdown Rowsources On The Fly | 00:00:00 | ||
| Create A Subroutine To Build All The Filters | 00:00:00 | ||
| Use The AfterUpdate Event To Rebuild The Filter | 00:00:00 | ||
| Setup The Clear Filter Buttons | 00:00:00 | ||
| Save The Filters When Closing The Form | 00:00:00 | ||
| Section 6 Conclusion And Review | 00:00:00 | ||
| Section 7 - Build A Report Containing Complex Calculations | |||
| Inspect The Tables And Review The Goal | 00:00:00 | ||
| Creating A Summary Table With A Query | 00:00:00 | ||
| Building Our First Function And Saving Queries To VBA | 00:00:00 | ||
| Add A Delete Query And Create A Test Macro | 00:00:00 | ||
| Restructure Tables And Add A Second Query To Our VBA Function | 00:00:00 | ||
| Figure Out How To Get The Days Between Orders | 00:00:00 | ||
| Doing The Steps With A Recordset | 00:00:00 | ||
| Calculate The Average Days Between Orders | 00:00:00 | ||
| Plug The Average Days Into The Report Table | 00:00:00 | ||
| Section 7 Conclusion And Review | 00:00:00 | ||
| Section 8 - Turn Off The Menu, Ribbon And Navigation Pane | |||
| View The Example Of Removing The Nav Pane And Ribbon | 00:00:00 | ||
| Create The HideMenu Subroutine | 00:00:00 | ||
| Call The HideMenu Subroutine From Our Form | 00:00:00 | ||
| Make The Subroutine Toggle The Menus | 00:00:00 | ||
| Create A Startup Subroutine And An Autoexec Macro | 00:00:00 | ||
| Prevent Closing The Form And Activate The Exit Button | 00:00:00 | ||
| Section 8 Conclusion And Review | 00:00:00 | ||
| Section 9 - How To Create And Modify Table Structures In VBA | |||
| Overview And Goal | 00:00:00 | ||
| Create Delete Subroutine And Make First Changes To SummRpt Function | 00:00:00 | ||
| Backup The SummRpt Function And Make The First Changes | 00:00:00 | ||
| Pull A Query From VBA Back To Design, Change It And Update VBA | 00:00:00 | ||
| Use TableDefs To Add A Field To A Table | 00:00:00 | ||
| Use TableDefs To Create A Table And Add Fields To It | 00:00:00 | ||
| Make Final Changes And Test The Modified Function | 00:00:00 | ||
| Section 10 - Using Subforms | |||
| Download The Subforms Database | 00:00:00 | ||
| Overview Of The Tables In The Subforms Database | 00:00:00 | ||
| Overview Of The Forms In The Subforms Database | 00:00:00 | ||
| Add OrderList As A Subform To The Customer Form | 00:00:00 | ||
| Using An On Exit Subroutine To Capture The Order Number You Were On | 00:00:00 | ||
| Pass The Order Number To The Go To Order Button | 00:00:00 | ||
| Open The Orders Form And Move To The Specified Order | 00:00:00 | ||
| Create Code To Return To The Customer Form | 00:00:00 | ||
| Setup The OrdProdList Subform | 00:00:00 | ||
| Create A Total In The Subform | 00:00:00 | ||
| Update The Subtotal And Order Total | 00:00:00 | ||
| Add A New Product To The Order | 00:00:00 | ||
| Create The Add Order Subroutine And Post A New Order | 00:00:00 | ||
| Get The New Order Number And Open The Order Form | 00:00:00 | ||
| Review, Conclusion And Future Enhancements | 00:00:00 | ||
| Section 11 - Using POPUP Forms | |||
| Download The POPUPS Database | 00:00:00 | ||
| Import Customer List Form And Rename It As CustPopup | 00:00:00 | ||
| Prepare The CustPopup Form For Use As A Popup Form | 00:00:00 | ||
| Modify The Customer Form Code To Open The Popup | 00:00:00 | ||
| Make The Popup Move To The Current Customer On Open | 00:00:00 | ||
| Use The TAG Property To Send The OrdCust Value Back From The Popup Form | 00:00:00 | ||
| Add A Customer From Inside The Popup Form | 00:00:00 | ||
| Section 12 - A CLASSIC Double Loop Walk Thru | |||
| Double Loop Database Download | 00:00:00 | ||
| A CLASSIC Situation That MUST Be Handled Correctly | 00:00:00 | ||
| Database Overview And Why You Want One Table | 00:00:00 | ||
| The Code Behind The Recalc Button | 00:00:00 | ||
| Doing Total Queries And Making The Subroutine A Function | 00:00:00 | ||
About This Course
Learn how to create what I call a Recordset Walk Thru with a Double Loop. These little programs can save you lots of time and grief!
Learn how to open a form anywhere in your Access Visual Basic (VBA) code and send and receive values from it!
Learn all the Access VBA programming concepts, tools, and functions that you will need while you build a fully functional system!
Build a strong foundation in Access Visual Basic with this tutorial for Non-Programmers!
- Create VBA Subroutines for Forms and Control the Keyboard
- Extensive Training on Handling Errors
- Control Record Sorting and Searching for Specific Records
- Learn How to Move and Pass Data Between Forms
- Create Interactive Pull Down Filters for Form Data
- Build a Complex Report Entirely with VBA
- Introduction to SQL and How to Use SQL in VBA
- Turn the Ribbon and Nav Pane On and Off
- Prevent Form Closure or Resizing
- Learn How to Close Access with VBA
Powerful Skills That Increase Your Value in the Marketplace
Learning VBA programming enables you to use ALL the power of Access to easily create systems that will be in high demand with your current employer or other businesses. The practical skills taught in this class will give you a solid foundation in creating systems that people can really use!
There is a HUGE need in the marketplace for people who can create systems like this in Access. This is your opportunity to break away from the pack of people who struggle to create effective Access databases, and learn to easily automate tasks! This could be your shortest path to increasing your income!
Our Promise to You
By the end of this course, you will have the knowledge about Microsoft Access VBA.
10 Day Money Back Guarantee. If you are unsatisfied for any reason, simply contact us and we’ll give you a full refund. No questions asked.
Get started today and develop your skills in Microsoft Access VBA!
Course Curriculum
| Section 1 - Introduction | |||
| Course Overview | 00:00:00 | ||
| Setup Tasks | 00:00:00 | ||
| Direct Download Links For Database Files | 00:00:00 | ||
| Microsoft Access VBA For Non Programmers – Course Materials | 00:00:00 | ||
| Section 2 - Start Learning VBA And Handling Errors | |||
| View Database Table And Forms – Review The Goal | 00:00:00 | ||
| Create Your First VBA Subroutine! | 00:00:00 | ||
| Fix A Syntax Error And Take Over The Keyboard | 00:00:00 | ||
| Use An IF Statement And DoCmd | 00:00:00 | ||
| Use ElseIf And A Select Statement | 00:00:00 | ||
| Runtime Errors, Error Traps And Program Stops | 00:00:00 | ||
| Break Into Programs And Infinite Loops | 00:00:00 | ||
| Section 2 Conclusion And Review | 00:00:00 | ||
| Section 3 - Create Record Sorting Subroutines | |||
| On Open Event, Me Keyword And OrderBy | 00:00:00 | ||
| Subroutines For Form Controls, VBA Editing Shortcuts | 00:00:00 | ||
| Modify Subroutines To Sort DESC, More Error Handling | 00:00:00 | ||
| Section 3 Conclusion And Review | 00:00:00 | ||
| Section 4 - Use Instant Search To Learn More About The Keyboard, Recordsets And Variables | |||
| Expanding The Keydown Subroutine | 00:00:00 | ||
| Using Public Variables | 00:00:00 | ||
| Building The Search Criteria | 00:00:00 | ||
| Field Names And Reserved Words | 00:00:00 | ||
| Using A Recordset And Bookmarks | 00:00:00 | ||
| Enhancing Our Instant Search | 00:00:00 | ||
| Section 4 Conclusion And Review | 00:00:00 | ||
| Section 5 - Interact With Other Forms And Pass Information | |||
| Open Another Form With A Button Click | 00:00:00 | ||
| Send Data To The Other Form | 00:00:00 | ||
| Modify A Form To Utilize Data Sent To It | 00:00:00 | ||
| Intro To SQL And Using SQL In The Recordsource | 00:00:00 | ||
| Locate Same Record When Returning From The Form | 00:00:00 | ||
| Modify The Form To Remember The Sort | 00:00:00 | ||
| Create A Prompt To Save Changes | 00:00:00 | ||
| Activate The Add Customer Button | 00:00:00 | ||
| Testing For A Blank Record | 00:00:00 | ||
| Activate The Delete Button | 00:00:00 | ||
| Section 5 Conclusion And Review | 00:00:00 | ||
| Section 6 - Add Multiple Interactive Pulldown Filters | |||
| Setup Rowsource For Dropdown Filters | 00:00:00 | ||
| Enable Editing In the Dropdown Filters | 00:00:00 | ||
| Set Dropdown Rowsources On The Fly | 00:00:00 | ||
| Create A Subroutine To Build All The Filters | 00:00:00 | ||
| Use The AfterUpdate Event To Rebuild The Filter | 00:00:00 | ||
| Setup The Clear Filter Buttons | 00:00:00 | ||
| Save The Filters When Closing The Form | 00:00:00 | ||
| Section 6 Conclusion And Review | 00:00:00 | ||
| Section 7 - Build A Report Containing Complex Calculations | |||
| Inspect The Tables And Review The Goal | 00:00:00 | ||
| Creating A Summary Table With A Query | 00:00:00 | ||
| Building Our First Function And Saving Queries To VBA | 00:00:00 | ||
| Add A Delete Query And Create A Test Macro | 00:00:00 | ||
| Restructure Tables And Add A Second Query To Our VBA Function | 00:00:00 | ||
| Figure Out How To Get The Days Between Orders | 00:00:00 | ||
| Doing The Steps With A Recordset | 00:00:00 | ||
| Calculate The Average Days Between Orders | 00:00:00 | ||
| Plug The Average Days Into The Report Table | 00:00:00 | ||
| Section 7 Conclusion And Review | 00:00:00 | ||
| Section 8 - Turn Off The Menu, Ribbon And Navigation Pane | |||
| View The Example Of Removing The Nav Pane And Ribbon | 00:00:00 | ||
| Create The HideMenu Subroutine | 00:00:00 | ||
| Call The HideMenu Subroutine From Our Form | 00:00:00 | ||
| Make The Subroutine Toggle The Menus | 00:00:00 | ||
| Create A Startup Subroutine And An Autoexec Macro | 00:00:00 | ||
| Prevent Closing The Form And Activate The Exit Button | 00:00:00 | ||
| Section 8 Conclusion And Review | 00:00:00 | ||
| Section 9 - How To Create And Modify Table Structures In VBA | |||
| Overview And Goal | 00:00:00 | ||
| Create Delete Subroutine And Make First Changes To SummRpt Function | 00:00:00 | ||
| Backup The SummRpt Function And Make The First Changes | 00:00:00 | ||
| Pull A Query From VBA Back To Design, Change It And Update VBA | 00:00:00 | ||
| Use TableDefs To Add A Field To A Table | 00:00:00 | ||
| Use TableDefs To Create A Table And Add Fields To It | 00:00:00 | ||
| Make Final Changes And Test The Modified Function | 00:00:00 | ||
| Section 10 - Using Subforms | |||
| Download The Subforms Database | 00:00:00 | ||
| Overview Of The Tables In The Subforms Database | 00:00:00 | ||
| Overview Of The Forms In The Subforms Database | 00:00:00 | ||
| Add OrderList As A Subform To The Customer Form | 00:00:00 | ||
| Using An On Exit Subroutine To Capture The Order Number You Were On | 00:00:00 | ||
| Pass The Order Number To The Go To Order Button | 00:00:00 | ||
| Open The Orders Form And Move To The Specified Order | 00:00:00 | ||
| Create Code To Return To The Customer Form | 00:00:00 | ||
| Setup The OrdProdList Subform | 00:00:00 | ||
| Create A Total In The Subform | 00:00:00 | ||
| Update The Subtotal And Order Total | 00:00:00 | ||
| Add A New Product To The Order | 00:00:00 | ||
| Create The Add Order Subroutine And Post A New Order | 00:00:00 | ||
| Get The New Order Number And Open The Order Form | 00:00:00 | ||
| Review, Conclusion And Future Enhancements | 00:00:00 | ||
| Section 11 - Using POPUP Forms | |||
| Download The POPUPS Database | 00:00:00 | ||
| Import Customer List Form And Rename It As CustPopup | 00:00:00 | ||
| Prepare The CustPopup Form For Use As A Popup Form | 00:00:00 | ||
| Modify The Customer Form Code To Open The Popup | 00:00:00 | ||
| Make The Popup Move To The Current Customer On Open | 00:00:00 | ||
| Use The TAG Property To Send The OrdCust Value Back From The Popup Form | 00:00:00 | ||
| Add A Customer From Inside The Popup Form | 00:00:00 | ||
| Section 12 - A CLASSIC Double Loop Walk Thru | |||
| Double Loop Database Download | 00:00:00 | ||
| A CLASSIC Situation That MUST Be Handled Correctly | 00:00:00 | ||
| Database Overview And Why You Want One Table | 00:00:00 | ||
| The Code Behind The Recalc Button | 00:00:00 | ||
| Doing Total Queries And Making The Subroutine A Function | 00:00:00 | ||
Course Review
5.0
1 RatingsRelated Courses
Are you interested in higher education?
All Rights Reserved
Great example!
This is an excellent example of what professionals need to improve their skills. Practical, useful and simple, narrated by an experienced tutor. Well done!