Elevate your skills with advanced techniques through this Access VBA Intermediate course. Advance your VBA proficiency now! 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
Who this course is for:
- Anyone interested in learning more about Access VBA
What you’ll learn:Â
- Different approach to take with menu buttons
- How you can set up the “Power Search” for any table
Requirements:Â
- Basic knowledge of Access VBA
Welcome to “Access VBA Intermediate: Power Search And Word/Excel Export”!
Take your basic knowledge of Microsoft Access VBA to an entirely new level! This is your opportunity to work with a FULLY FUNCTIONING SYSTEM that is ready to install RIGHT NOW!
Once you have been exposed to Access VBA a logical next question is “What could I create with VBA?”. This course will give you an answer to that question by providing you with a finished system that you can start using right away. Rather than lead you through building parts of databases, this course examines the workings of this finished database that I have used in my consulting business for years.
Most of the employees in my client businesses know nothing about Access and the ribbon and navigator are always hidden, yet these people usually get more work done faster than experienced Access users!
Inside this Access VBA Intermediate course, I will show you a different approach to take with menu buttons and how you can set up the “Power Search” for any table in just a matter of minutes! You will also learn how to, with one click, create merge letters in Word with the search results or how to create and title a new Excel sheet.
Follow along as I take you through this Microsoft Access VBA training to learn the inner workings of this simple to understand, yet a very powerful platform that is very understandable to any prospective client, whether they are computer savvy or not.
This system contains all the code to:
- Provide a simple to understand and use menu system that can be used with the mouse or keyboard.
- Control the proper addition, editing, and deletion of records.
- Quickly sort and locate records based on any item of data.
- Instantly create letters and/or envelopes for the displayed record using Microsoft Word with two keystrokes.
- Allow the user to do highly complex searches without knowing anything about Access.
- Instantly Create reports based on those searches with complete descriptions in the title.
- Export search results to a new Excel spreadsheet, then format and title it, with just a two keystrokes.
- Create a merge document in Word with the search results for bulk mailing.
- Allow you to add all these functions to an existing form in less than one minute.
If you take the time to master doing a demo with this database, you will instantly impress potential clients with your capabilities.
Our Promise to You
By the end of this course, you will have a clear understanding of how to create a power search and export Word or Excel files in Microsoft Access.
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 learn how to create power search and use Access VBA export to excel or Word files in Microsoft Access!
Course Curriculum
| Section 1 - Introduction And Feature Demonstration Of The Access Prototype Database | |||
| Download The PowerSearch Database | 00:00:00 | ||
| What This System Is | 00:00:00 | ||
| QUICK DEMO Of Basic Functions | 00:00:00 | ||
| QUICK DEMO Of SEARCH | 00:00:00 | ||
| Using The Comma In Search For A Range Of Values | 00:00:00 | ||
| QUICK DEMO Of Using Prototype Form | 00:00:00 | ||
| Rules For Using The Prototype Form | 00:00:00 | ||
| The Form Control Table | 00:00:00 | ||
| Using The Prototype List Form | 00:00:00 | ||
| Using The Prototype Listing Report | 00:00:00 | ||
| Section 2 - How The Function Key Menus Work | |||
| Why Use These Function Key Menus? | 00:00:00 | ||
| How Are The Buttons Built? | 00:00:00 | ||
| What Does The Menu VBA Code Look Like? | 00:00:00 | ||
| The FormMenu Function And ModeSub Subroutine | 00:00:00 | ||
| Section 3 - How The Basic Menu Functions Work And Access VBA Code | |||
| Examine Code Behind The ADD Selection | 00:00:00 | ||
| Examine Code Behind MyYesNoBox | 00:00:00 | ||
| Heads Up On A BUG - See If You Can Find It! | 00:00:00 | ||
| Examine Code Behind The LIST FORM Selection | 00:00:00 | ||
| Coming Back From The List Form To The Full Form | 00:00:00 | ||
| Explanation Of The Bug And Prep The Full Form To Send Multiple Open Arguments | 00:00:00 | ||
| Modification Of The List Form To Receive Multiple Open Arguments | 00:00:00 | ||
| Make The Same Changes For Going From The List Form To The Full Form | 00:00:00 | ||
| Examine Code Behind The SORT Selection | 00:00:00 | ||
| Examine Code Behind The SALES PERSON Selection | 00:00:00 | ||
| How The NOTES Box Works | 00:00:00 | ||
| Section 4 - Working With WORD 1 - Instant Letter Or Envelope With Access VBA | |||
| Instant Letter Code 1 | 00:00:00 | ||
| Explore References | 00:00:00 | ||
| Instant Letter Code 2 - Examine The PrepInstant Function | 00:00:00 | ||
| Instant Letter Code 3 - Opening Word And Setup Document | 00:00:00 | ||
| Find Command Syntax By Creating Macros In Word | 00:00:00 | ||
| Instant Letter Code 4 - Create The Letter And Leave Word Open | 00:00:00 | ||
| Examine The Instant Envelope Function | 00:00:00 | ||
| Section 5 - How SEARCH Works - Examining The Access VBA Code | |||
| Tracing The Steps To Setup Criteria Mode | 00:00:00 | ||
| Creating The Search Table If It Is Not There | 00:00:00 | ||
| The Idea Behind The Search Table | 00:00:00 | ||
| Finish Inspecting The SetupSearch Subroutine | 00:00:00 | ||
| Revisit Criteria Mode And Test Search | 00:00:00 | ||
| Inspect The Code Behind FinishSearch | 00:00:00 | ||
| Processing Search 1 - Examine The ProcessSearch Function | 00:00:00 | ||
| Processing Search 2 - Using Collections For Field Names, Types And Values | 00:00:00 | ||
| Processing Search 3 - Overview Of The CheckFilters Subroutine | 00:00:00 | ||
| Processing Search 4 - Processing A Search Value | 00:00:00 | ||
| Processing Search 5 - Testing For Wildcards And BLANK Or NOT BLANK | 00:00:00 | ||
| Processing Search 6 - Review Of InStr And Mid Functions | 00:00:00 | ||
| Processing Search 7 - Examine The Comma Criteria For Range Of Values | 00:00:00 | ||
| Processing Search 8 - Examine The SemiColon Criteria For Multiple Values | 00:00:00 | ||
| Processing Search 9 - Processing Literal Values And NOT | 00:00:00 | ||
| Processing Search 10 - Why Separate Sections For Numbers, Text And Dates? | 00:00:00 | ||
| Section 6 - Working With EXCEL - Export To Excel And Modify Spreadsheets Using Access VBA | |||
| Examine The Send Search To Excel Function | 00:00:00 | ||
| Manipulate Excel With VBA | 00:00:00 | ||
| Section 7 - Working With WORD 2 - Creating Merge Letters And Envelopes With Access VBA | |||
| Examine The Code Behind Merge Letters | 00:00:00 | ||
| Examine The Merge Engine Function | 00:00:00 | ||
| Examine Merge Envelope | 00:00:00 | ||
| Section 8 - The Access VBA Code Behind The Prototype Forms And Report | |||
| How Can Prototype Work For All Forms? | 00:00:00 | ||
| What Happens On Form Open? | 00:00:00 | ||
| The VBA Code Behind The SetupFormTbl Function | 00:00:00 | ||
| Review Of Open And SetupFormTbl In The List Form | 00:00:00 | ||
| Review Of The Code Behind The Prototype Listing Report | 00:00:00 | ||
| Section 9 - CONCLUSION | |||
| Conclusion | 00:00:00 | ||
About This Course
Who this course is for:
- Anyone interested in learning more about Access VBA
What you’ll learn:Â
- Different approach to take with menu buttons
- How you can set up the “Power Search” for any table
Requirements:Â
- Basic knowledge of Access VBA
Welcome to “Access VBA Intermediate: Power Search And Word/Excel Export”!
Take your basic knowledge of Microsoft Access VBA to an entirely new level! This is your opportunity to work with a FULLY FUNCTIONING SYSTEM that is ready to install RIGHT NOW!
Once you have been exposed to Access VBA a logical next question is “What could I create with VBA?”. This course will give you an answer to that question by providing you with a finished system that you can start using right away. Rather than lead you through building parts of databases, this course examines the workings of this finished database that I have used in my consulting business for years.
Most of the employees in my client businesses know nothing about Access and the ribbon and navigator are always hidden, yet these people usually get more work done faster than experienced Access users!
Inside this Access VBA Intermediate course, I will show you a different approach to take with menu buttons and how you can set up the “Power Search” for any table in just a matter of minutes! You will also learn how to, with one click, create merge letters in Word with the search results or how to create and title a new Excel sheet.
Follow along as I take you through this Microsoft Access VBA training to learn the inner workings of this simple to understand, yet a very powerful platform that is very understandable to any prospective client, whether they are computer savvy or not.
This system contains all the code to:
- Provide a simple to understand and use menu system that can be used with the mouse or keyboard.
- Control the proper addition, editing, and deletion of records.
- Quickly sort and locate records based on any item of data.
- Instantly create letters and/or envelopes for the displayed record using Microsoft Word with two keystrokes.
- Allow the user to do highly complex searches without knowing anything about Access.
- Instantly Create reports based on those searches with complete descriptions in the title.
- Export search results to a new Excel spreadsheet, then format and title it, with just a two keystrokes.
- Create a merge document in Word with the search results for bulk mailing.
- Allow you to add all these functions to an existing form in less than one minute.
If you take the time to master doing a demo with this database, you will instantly impress potential clients with your capabilities.
Our Promise to You
By the end of this course, you will have a clear understanding of how to create a power search and export Word or Excel files in Microsoft Access.
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 learn how to create power search and use Access VBA export to excel or Word files in Microsoft Access!
Course Curriculum
| Section 1 - Introduction And Feature Demonstration Of The Access Prototype Database | |||
| Download The PowerSearch Database | 00:00:00 | ||
| What This System Is | 00:00:00 | ||
| QUICK DEMO Of Basic Functions | 00:00:00 | ||
| QUICK DEMO Of SEARCH | 00:00:00 | ||
| Using The Comma In Search For A Range Of Values | 00:00:00 | ||
| QUICK DEMO Of Using Prototype Form | 00:00:00 | ||
| Rules For Using The Prototype Form | 00:00:00 | ||
| The Form Control Table | 00:00:00 | ||
| Using The Prototype List Form | 00:00:00 | ||
| Using The Prototype Listing Report | 00:00:00 | ||
| Section 2 - How The Function Key Menus Work | |||
| Why Use These Function Key Menus? | 00:00:00 | ||
| How Are The Buttons Built? | 00:00:00 | ||
| What Does The Menu VBA Code Look Like? | 00:00:00 | ||
| The FormMenu Function And ModeSub Subroutine | 00:00:00 | ||
| Section 3 - How The Basic Menu Functions Work And Access VBA Code | |||
| Examine Code Behind The ADD Selection | 00:00:00 | ||
| Examine Code Behind MyYesNoBox | 00:00:00 | ||
| Heads Up On A BUG - See If You Can Find It! | 00:00:00 | ||
| Examine Code Behind The LIST FORM Selection | 00:00:00 | ||
| Coming Back From The List Form To The Full Form | 00:00:00 | ||
| Explanation Of The Bug And Prep The Full Form To Send Multiple Open Arguments | 00:00:00 | ||
| Modification Of The List Form To Receive Multiple Open Arguments | 00:00:00 | ||
| Make The Same Changes For Going From The List Form To The Full Form | 00:00:00 | ||
| Examine Code Behind The SORT Selection | 00:00:00 | ||
| Examine Code Behind The SALES PERSON Selection | 00:00:00 | ||
| How The NOTES Box Works | 00:00:00 | ||
| Section 4 - Working With WORD 1 - Instant Letter Or Envelope With Access VBA | |||
| Instant Letter Code 1 | 00:00:00 | ||
| Explore References | 00:00:00 | ||
| Instant Letter Code 2 - Examine The PrepInstant Function | 00:00:00 | ||
| Instant Letter Code 3 - Opening Word And Setup Document | 00:00:00 | ||
| Find Command Syntax By Creating Macros In Word | 00:00:00 | ||
| Instant Letter Code 4 - Create The Letter And Leave Word Open | 00:00:00 | ||
| Examine The Instant Envelope Function | 00:00:00 | ||
| Section 5 - How SEARCH Works - Examining The Access VBA Code | |||
| Tracing The Steps To Setup Criteria Mode | 00:00:00 | ||
| Creating The Search Table If It Is Not There | 00:00:00 | ||
| The Idea Behind The Search Table | 00:00:00 | ||
| Finish Inspecting The SetupSearch Subroutine | 00:00:00 | ||
| Revisit Criteria Mode And Test Search | 00:00:00 | ||
| Inspect The Code Behind FinishSearch | 00:00:00 | ||
| Processing Search 1 - Examine The ProcessSearch Function | 00:00:00 | ||
| Processing Search 2 - Using Collections For Field Names, Types And Values | 00:00:00 | ||
| Processing Search 3 - Overview Of The CheckFilters Subroutine | 00:00:00 | ||
| Processing Search 4 - Processing A Search Value | 00:00:00 | ||
| Processing Search 5 - Testing For Wildcards And BLANK Or NOT BLANK | 00:00:00 | ||
| Processing Search 6 - Review Of InStr And Mid Functions | 00:00:00 | ||
| Processing Search 7 - Examine The Comma Criteria For Range Of Values | 00:00:00 | ||
| Processing Search 8 - Examine The SemiColon Criteria For Multiple Values | 00:00:00 | ||
| Processing Search 9 - Processing Literal Values And NOT | 00:00:00 | ||
| Processing Search 10 - Why Separate Sections For Numbers, Text And Dates? | 00:00:00 | ||
| Section 6 - Working With EXCEL - Export To Excel And Modify Spreadsheets Using Access VBA | |||
| Examine The Send Search To Excel Function | 00:00:00 | ||
| Manipulate Excel With VBA | 00:00:00 | ||
| Section 7 - Working With WORD 2 - Creating Merge Letters And Envelopes With Access VBA | |||
| Examine The Code Behind Merge Letters | 00:00:00 | ||
| Examine The Merge Engine Function | 00:00:00 | ||
| Examine Merge Envelope | 00:00:00 | ||
| Section 8 - The Access VBA Code Behind The Prototype Forms And Report | |||
| How Can Prototype Work For All Forms? | 00:00:00 | ||
| What Happens On Form Open? | 00:00:00 | ||
| The VBA Code Behind The SetupFormTbl Function | 00:00:00 | ||
| Review Of Open And SetupFormTbl In The List Form | 00:00:00 | ||
| Review Of The Code Behind The Prototype Listing Report | 00:00:00 | ||
| Section 9 - CONCLUSION | |||
| Conclusion | 00:00:00 | ||
Related Courses
Are you interested in higher education?
All Rights Reserved