Access VBA Advanced: Power Search with Subforms
4.8 (29 ratings)
Instead of using a simple lifetime average, Udemy calculates a course's star rating by considering a number of different factors such as the number of ratings, the age of ratings, and the likelihood of fraudulent ratings.
681 students enrolled
Wishlisted Wishlist

Please confirm that you want to add Access VBA Advanced: Power Search with Subforms to your Wishlist.

Add to Wishlist

Access VBA Advanced: Power Search with Subforms

Download and learn to use the "Power Search with Subforms" database that has helped me make more than $500,000!
4.8 (29 ratings)
Instead of using a simple lifetime average, Udemy calculates a course's star rating by considering a number of different factors such as the number of ratings, the age of ratings, and the likelihood of fraudulent ratings.
681 students enrolled
Last updated 8/2016
English
Current price: $10 Original price: $195 Discount: 95% off
1 day left at this price!
30-Day Money-Back Guarantee
Includes:
  • 5 hours on-demand video
  • 2 Articles
  • 1 Supplemental Resource
  • Full lifetime access
  • Access on mobile and TV
  • Certificate of Completion
Have a coupon?
What Will I Learn?
Install the database and use all the search functions, even with existing forms!
View Curriculum
Requirements
  • Students should have a very good grasp on VBA as we cover a great deal of highly complex code within this course.
Description

You've been shown many VBA techniques in my other courses and even a complete system in the Intermediate course, but this is much more than that! By adding subforms, this FULLY FUNCTIONING SYSTEM is ready to use RIGHT NOW as a demo to solicit business or impress your boss. The system is much more flexible and could easily be used to quickly create powerful custom systems.

Believe me, when a business owner or boss takes a look at this demo, they will be more than impressed! They will be ready to HIRE YOU to do the job!

So 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!

The database you receive as a download with this course is a new and improved version of the "prototype" database I have used for years to attract new clients. I call this system the CLOSER because, after viewing the demo, the only question is "When can you start?"

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 :

  1. Make the menu buttons change color when you move the mouse over them.
  2. Create "Quick Search" pulldowns that integrate with the regular search.
  3. Use the prototype form to quickly setup an existing form to have all the functionality of the Customer form in the course.
  4. Easily add unlimited subforms to your main form and have them work in search also.
  5. Use all the search criteria methods from the Intermediate course within your subforms.
  6. Save an ulimited number of searches on each of your main forms.
  7. Remove or modify saved searches easily.
  8. Use the new MTD and YTD criteria in any main form or subform date field.
  9. 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.

There will be no question of your computer background or certifications - this database provides your credibility. In fact I usually tell prospective clients that I have ZERO computer education and NO certifications, THEN I demo this system. BANG! New Client almost every time!

For a visual walk through of the prototype database, view the previews in the first section.

From a Student Review -

"This course is real value for money. I have learned a lot of new skills!" - Johan Kritzinger

Once you have done that, clicking the Take This Course button is the logical next step in your VBA journey. Exporing this system will expand your abilities with VBA faster than anything else you could possibly do. Think of it! In just HOURS you could be ready to go find your first client!

Intended Audience:

This course assumes that you have either gone through my "Access VBA Intermediate" course and know the basic way the Prototype system and its menus work.

Course Requirements:

You should have Office 2010 or later. The course was created using Office 2010.

Who is the target audience?
  • This course is for students who have completed my Access VBA Intermediate course and are ready to learn how to add Subforms to the Prototype database!
Students Who Viewed This Course Also Viewed
Curriculum For This Course
Expand All 45 Lectures Collapse All 45 Lectures 05:02:44
+
How Keyflash Works
3 Lectures 17:37
Setting RGB Colors with the Mouse Move Event
06:54

The FKeyColors Subroutine
07:01

How are the Key Colors Reset Back to Default?
03:42
+
How to Resize the Notes Box
1 Lecture 06:41
Find the Code for Resizing Notes
06:41
+
How Quick Search Works
3 Lectures 16:21
Examine the Company Search
03:51

Examine the Company Search AfterUpdate Sub
09:34

The Company Search Got Focus Event
02:56
+
The Order Subform
4 Lectures 25:35
The Order Subform Enter Subroutine/Testing for No Records
07:01

More on the Orders Subform Enter Subroutine
05:56

The Order Subform Exit Subroutine
06:29

How the GO button in the Orders Subform Works
06:09
+
The Task Subform
4 Lectures 18:45
Overview of the Task Subform
02:10

The Add New Task Menu Command
05:31

The All Tasks Report Command
08:34

The Tasks Due Report Command
02:30
+
Details on How Search with Subforms Works
11 Lectures 01:39:32
Quick overview of FormControl and FormSubControl Tables
06:18

UnlinkSubforms Subroutine
04:07

Remove the Search Tables and Test SetupSearch
05:29

Examine the SetupSearch and SetupSrchTbl Subroutines
09:16

Step Through SetupSearch Part 1
09:56

Step Through SetupSearch Part 2-SetInputMasks
09:28

Process Search Part 1
09:22

Process Search Part 2 - Building the FStr
07:12

Process Search Part 3 - Building the Keylist Table Query
11:31

Process Search Part 4 - LinktoSearch and Finish
06:54

Step Through Processing a Search
19:59
+
Ending, Saving and Retrieving Searches
5 Lectures 46:33
Cancel or End Search - Code Step Through
10:45

Save Search - Code Step Through
12:44

Retrieve Search - Code Step Through
07:36

Delete Search - Code Step Through
08:42

Setup Search on Open Form - Code Step Through
06:46
+
Using the Prototype and Prototype List Forms
5 Lectures 38:39
Setup a New Form Using the Prototype Form.
07:57

Modify the VBA Editor Toolbar and Create Subform Enter/Exit Subroutines
11:31

Create Subform Menus
05:15

Create a New Continuous List Form
05:29

Using the Prototype List Form
08:27
+
Conclusion
1 Lecture 02:00
Conclusion - How to Get the Most Out of What You've Learned
02:00
1 More Section
About the Instructor
Bruce Myron
4.7 Average rating
2,628 Reviews
35,551 Students
15 Courses
Productivity Specialist

Hello, my name is Bruce Myron. 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 systems I have built for these companies are critical to the success of the business. My specialty is taking the needs of the business and translating them into a system that facilitates, rather than obstructs, what they are trying to do.

I have also spent time as a full time trainer providing group classes on the Microsoft Office programs.

In my opinion the computer industry as a whole is a colossal failure in helping businesses solve their problems. I listen carefully to the needs expressed by my clients and then deliver the simplest, most flexible solution possible.

Over the years I have found that many of the techniques I have used enabled me to survive and thrive when many others have tried the computer programming business and failed.

My goal is to show my students how to create systems that business will value and that will create long term income.

Billy Myron
4.7 Average rating
1,371 Reviews
12,142 Students
12 Courses
Udemy Instructor

Hello, my name is Billy. I was born and raised in the state of Oregon, and still live there.

On Udemy, I primarily assist Bruce Myron as an instructor on his courses. They deal with Microsoft Access, Microsoft Access VBA, and other Microsoft Office programs such as Excel.