Access VBA Advanced: Power Search With Subforms

This course includes lifetime access so you can complete the course at your own speed.

This Microsoft Access VBA Advanced course will teach you the inner workings of a radically improved database. By taking this course today, you will be able to add unlimited subforms to your main form, remove or modify saved searches easily, add MTD and YTD criteria in any main form or subforms and impress potential clients with your capabilities by doing power searches with subforms in your database.

Benefits of taking this course include:

• Unlimited and lifetime access to the course
• Learn the course at your own pace
• Course can be accessed on any platform
• 24/7 Customer support

Certificate of completion

Digital certificate - Included

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

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!

This course 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.

This Access VBA Advanced: Power Search With Subforms course will cover the following topics:

Topic 1 - System Overview And Demonstrations

• What This System Is And How It Can Help You
• System Demo – The Minor Changes From The Intermediate Database
• System Demo – The Quick Search Pulldowns
• System Demo – The Orders Subform
• System Demo – The Tasks Subform
• System Demo – The Search System
• Database Download Links

Topic 2 - How Keyflash Works

• Setting RGB Colors With The Mouse Move Event
• The FKeyColors Subroutine
• How Are The Key Colors Reset Back To Default?

Topic 3 - How To Resize The Notes Box

• Find The Code For Resizing Notes

Topic 4 - How Quick Search Works

• Examine The Company Search
• Examine The Company Search AfterUpdate Sub
• The Company Search Got Focus Event

Topic 5 - The Order Subform

• The Order Subform Enter Subroutine/Testing For No Records
• More On The Orders Subform Enter Subroutine
• The Order Subform Exit Subroutine
• How The GO button In The Orders Subform Works

Topic 6 - The Task Subform

• Overview Of The Task Subform
• The Add New Task Menu Command
• The All Tasks Report Command
• The Tasks Due Report Command

Topic 7 - Details On How Search With Subforms Works

• Quick Overview Of FormControl And FormSubControl Tables
• UnlinkSubforms Subroutine
• Remove The Search Tables And Test SetupSearch
• Examine The SetupSearch And SetupSrchTbl Subroutines
• Step Through SetupSearch Part 1
• Step Through SetupSearch Part 2-SetInputMasks
• Process Search Part 1
• Process Search Part 2 – Building The FStr
• Process Search Part 3 – Building The Keylist Table Query
• Process Search Part 4 – LinkToSearch And Finish
• Step Through Processing A Search

Topic 8 - Ending, Saving And Retrieving Searches

• Cancel Or End Search – Code Step Through
• Save Search – Code Step Through
• Retrieve Search – Code Step Through
• Delete Search – Code Step Through
• Setup Search On Open Form – Code Step Through

Topic 9 - Using The Prototype And Prototype List Forms

• Setup A New Form Using The Prototype Form
• Modify The VBA Editor Toolbar And Create Subform Enter/Exit Subroutines
• Create Subform Menus
• Create A New Continuous List Form
• Using The Prototype List Form

Topic 10 - Conclusion

• Conclusion – How To Get The Most Out Of What You’ve Learned

This course is designed for anyone who is interested in learning how to create powerful search forms in Microsoft Access.

No prior knowledge is required to take this course.

Currently there are no Q&As for this course. Be the first to ask a question.