About This Course

Take what you learned in the Intermediate Access VBA Course to a level that is probably far beyond what you thought was possible. This course takes the Prototype System introduced in the Intermediate VBA course to a much higher level by adding the ability to incorporate unlimited subforms!

I spent a solid month of programming greatly expanding this system while, at the same time, making it simpler to work with! I’m pretty happy with the way it turned out and I think you will be too!

Restrictions like having your form have the same name as the recordsource table are GONE, and you can name the List form anything you want. You can add unlimited subforms to your main form and use any or all of them in search! Best of all, now you can save your searches!

To help make saved searches more valuable, two new Date Criterias have been added: MTD and YTD. Put one of these into your criteria and the search will automatically calculate the date from the beginning of the month or year through today, every time you run the search!

Searches can be setup with criteria on just one of your subforms, or all of them or any combination of the main form and subforms. Save the search with a descriptive name and then retrieve it at any time. You can also have an unlimited number of main forms and have searches running in ALL of THEM AT THE SAME TIME! If you close the database without ending the searches, they will all be there when you open the database again!

Follow along as I take you step by step through the inner workings of this radically improved database. We will cover VBA syntax that is far beyond what you thought possible with subforms.

This system contains all the code and capabilities from the Intermediate system, but also shows you how to :

  • Make the menu buttons change color when you move the mouse over them.
  • Create “Quick Search” pulldowns that integrate with the regular search.
  • Use the prototype form to quickly setup an existing form to have all the functionality of the Customer form in the course.
  • Easily add unlimited subforms to your main form and have them work in search also.
  • Use all the search criteria methods from the Intermediate course within your subforms.
  • Save an unlimited number of searches on each of your main forms.
  • Remove or modify saved searches easily.
  • Use the new MTD and YTD criteria in any main form or subform date field.
  • Understand the tables that search automatically creates for you.

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 power search with subforms.

30 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 with subforms in Access!

Course Curriculum

Section 1 - System Overview And Demonstrations
What This System Is And How It Can Help You 00:00:00
System Demo – The Minor Changes From The Intermediate Database 00:00:00
System Demo – The Quick Search Pulldowns 00:00:00
System Demo – The Orders Subform 00:00:00
System Demo – The Tasks Subform 00:00:00
System Demo – The Search System 00:00:00
Database Download Links 00:00:00
Section 2 - How Keyflash Works
Setting RGB Colors With The Mouse Move Event 00:00:00
The FKeyColors Subroutine 00:00:00
How Are The Key Colors Reset Back To Default? 00:00:00
Section 3 - How To Resize The Notes Box
Find The Code For Resizing Notes 00:00:00
Section 4 - How Quick Search Works
Examine The Company Search 00:00:00
Examine The Company Search AfterUpdate Sub 00:00:00
The Company Search Got Focus Event 00:00:00
Section 5 - The Order Subform
The Order Subform Enter Subroutine/Testing For No Records 00:00:00
More On The Orders Subform Enter Subroutine 00:00:00
The Order Subform Exit Subroutine 00:00:00
How The GO button In The Orders Subform Works 00:00:00
Section 6 - The Task Subform
Overview Of The Task Subform 00:00:00
The Add New Task Menu Command 00:00:00
The All Tasks Report Command 00:00:00
The Tasks Due Report Command 00:00:00
Section 7 - Details On How Search With Subforms Works
Quick Overview Of FormControl And FormSubControl Tables 00:00:00
UnlinkSubforms Subroutine 00:00:00
Remove The Search Tables And Test SetupSearch 00:00:00
Examine The SetupSearch And SetupSrchTbl Subroutines 00:00:00
Step Through SetupSearch Part 1 00:00:00
Step Through SetupSearch Part 2-SetInputMasks 00:00:00
Process Search Part 1 00:00:00
Process Search Part 2 – Building The FStr 00:00:00
Process Search Part 3 – Building The Keylist Table Query 00:00:00
Process Search Part 4 – LinkToSearch And Finish 00:00:00
Step Through Processing A Search 00:00:00
Section 8 - Ending, Saving And Retrieving Searches
Cancel Or End Search – Code Step Through 00:00:00
Save Search – Code Step Through 00:00:00
Retrieve Search – Code Step Through 00:00:00
Delete Search – Code Step Through 00:00:00
Setup Search On Open Form – Code Step Through 00:00:00
Section 9 - Using The Prototype And Prototype List Forms
Setup A New Form Using The Prototype Form 00:00:00
Modify The VBA Editor Toolbar And Create Subform Enter/Exit Subroutines 00:00:00
Create Subform Menus 00:00:00
Create A New Continuous List Form 00:00:00
Using The Prototype List Form 00:00:00
Section 10 - Conclusion
Conclusion – How To Get The Most Out Of What You’ve Learned 00:00:00
Template Design © VibeThemes. All rights reserved.

Setup Menus in Admin Panel