AI Builder 1.2 Update

v1.2 Update: The Builder Now Writes VBA Code!

S M L XL FS | Slo Reg Fast 2x | Bookmark

I've updated the Access AI Builder, a new and improved version of the former Access Query Builder. This enhanced tool now boasts the capability to write VBA code, responding to your requests for more versatility. In version 1.2, you can utilize it for creating generic VBA code, or tailor it to generate VBA scripts specific to your database.

For instance, I asked it to create a subroutine that iterates through all Florida-based customers using a Recordset, compiling their first names, last names, and email addresses into a comma-separated text string. Then, a message box displays the results. This feature was tested thoroughly and functions flawlessly, demonstrating its proficiency in recognizing your field, table, and query names, much like its query writing capabilities in version 1.1.

If this innovative tool piques your interest, order your copy today. Remember, with each new version and added feature, the price increases. Secure your purchase now to be grandfathered into all future version 1 updates. Don't delay!

New Features

Version 1.2 adds the ability to write custom VBA code based on the tables, queries, and fields in your database!

Learn More

To learn more about this update, visit the Access AI Query Builder page.

Comments for AI Builder 1.2 Update

Age	Subject	From
2 years	Tech Help	John Davy

Subscribe to AI Builder 1.2 Update
Get notifications when this page is updated

Intro

In this video, I will show you the new features added to the Microsoft Access AI Builder version 1.2, previously called the Access Query Builder. You'll see how the updated tool can now generate both generic and database-specific VBA code, using your actual field, table, and query names, in addition to writing queries. I'll also give you a quick example of the AI Builder writing a VBA subroutine based on a sample request and test the results.

Transcript

Okay, you guys asked for it. I have updated the Access Query Builder, which we are now going to call just the Access AI Builder because it does more than write queries.

You guys wanted to see it write VBA code? Well, I just added it to version 1.2. Now you can use it to write generic VBA code or, more importantly, you can have it write VBA code specific to your database.

For example, I said, "Write me a sub that loops through all the customers from Florida with a recordset and adds their first name, last name, and email address to a comma-delimited text string, message box the results, send it to OpenAI," and this is what I get back.

If you want to look at it, let's zoom in. There is the code. I tested it, and it works great.

As you can see, it knows what your field names, table names, and query names are, as I did for queries in version 1.1.

If you are interested, check it out. There is the website right there.

Remember, do not delay; with every version, the price goes up. As I add more features, the price is going up. If you get it now, you are grandfathered in for all version 1 updates. So do not wait. Check it out.

Live long and prosper, my friends. See you next time.

Quiz

Q1. What is the new name of the Access Query Builder tool mentioned in the video?
A. Access Report Generator
B. Access Table Designer
C. Access AI Builder
D. Access Macro Maker

Q2. What new feature was added to the Access AI Builder in version 1.2?
A. Exporting tables to Excel
B. Writing VBA code
C. Generating PDF reports
D. Importing CSV files

Q3. What type of VBA code can the Access AI Builder write?
A. Only for sending emails
B. Only for form design
C. Generic VBA code and code specific to the user's database
D. Code only for running queries

Q4. What example was given for the AI Builder's VBA code generation?
A. Import data from Excel to Access
B. Create a chart based on sales data
C. Loop through Florida customers and add their info to a string
D. Delete outdated records automatically

Q5. How does the AI Builder know which field names, table names, and query names to use in the code?
A. It asks the user to type them each time
B. It uses sample database names only
C. It recognizes them from your database
D. It guesses based on common names

Q6. What is the presenter's advice regarding purchasing the Access AI Builder?
A. Wait for version 2 for more features
B. Try it free for 30 days first
C. Buy now to lock in the current price and free updates to version 1
D. Buy only after watching more tutorials

Answers: 1-C; 2-B; 3-C; 4-C; 5-C; 6-C

DISCLAIMER: Quiz questions are AI generated. If you find any that are wrong, don't make sense, or aren't related to the video topic at hand, then please post a comment and let me know. Thanks.

Summary

Today's video from Access Learning Zone highlights the latest updates to my utility, now called the Access AI Builder. The reason for the new name is that the tool now does much more than just write queries.

One major new feature is the ability to generate VBA code. Many of you requested this capability, so I added it in version 1.2. With this new version, you can ask the AI Builder to write general-purpose VBA code or, even better, generate VBA that is tailored specifically to your database.

For example, I asked it to create a procedure that loops through all customers who live in Florida, collects their first name, last name, and email address into a comma-separated list, displays the result in a message box, and sends the data to OpenAI. The tool generated functional VBA code that accomplished exactly what I described. I tested the code, and it worked as expected.

Just as in the previous version for queries, the AI Builder already understands your existing field names, table names, and query names, allowing it to produce highly accurate code that matches your specific database structure.

If you are interested in exploring the new features, you can visit my website for more details. Please keep in mind that the price will increase as I continue adding new functionality, but purchasing now will lock in your access to all version 1 updates at no extra cost.

You can find a complete video tutorial with step-by-step instructions on everything discussed here on my website at the link below. Live long and prosper, my friends.

Topic List

This is a sales announcement for the Access AI Builder v1.2, highlighting its new ability to generate VBA code specific to your Access database.