Integrate OpenAI (ChatGPT) for Recipe Ideas into the Microsoft Access Chef’s Kitchen Helper

In this Microsoft Access tutorial, I will show you how to integrate OpenAI (ChatGPT) into your Chef’s Kitchen Helper database to generate new recipe ideas based on pantry items directly from Access

Nolan from Evanston, Illinois (a Platinum Member) asks: I’ve been using your Chef’s Kitchen Helper database for over a year now, and it works great. But, I got to thinking that I could use ChatGPT to help me come up with new recipe ideas based on what I have in my pantry. I can copy and paste my list of ingredients into the GPT interface, but is there any way I can just integrate this into my database directly? I know you showed how to do some stuff with GPT before with Access. How would I put these two together?

BECOME A MEMBER:
YouTube: https://youtube.com/channel/UCl7-jJie4ifOVK87FINIuDg/join
or My Site: https://599cd.com/THMember

LEARN MORE:
AI Chef Helper: https://599cd.com/AIChefHelper

PREREQUISITES:
Chef’s Kitchen Helper: https://599cd.com/ChefsKitchenHelper
OpenAI: https://599cd.com/OpenAI
Intro to VBA: https://599cd.com/IntroVBA
Recordsets: https://599cd.com/Recordset

UP NEXT:
AI Chef Helper, Part 2: https://599cd.com/AIChefHelper2

RECOMMENDED COURSES:
Access Developer Courses: https://599cd.com/Developer

FREE TEMPLATE DOWNLOADS:
TechHelp Free Templates: https://599cd.com/THFree
Blank Template: https://599cd.com/Blank
Contact Management: https://599cd.com/Contacts
Order Entry & Invoicing: https://599cd.com/Invoicing
More Access Templates: https://599cd.com/AccessTemplates

ADDITIONAL RESOURCES:
FREE Access Beginner Level 1: https://599cd.com/Free1
How to Use Access in 30 Minutes: https://599cd.com/30Minutes
$1 Access Level 2: https://599cd.com/1Dollar
Donate to my Tip Jar: https://599cd.com/TipJar
Get on my Mailing List: https://599cd.com/YTML
Contact Me: https://599cd.com/Contact
TechHelp: https://599cd.com/TechHelp
Consulting Help: https://599cd.com/DevNet
Twitter: https://twitter.com/LearningAccess
https://en.wikipedia.org/wiki/Microsoft_Access
https://products.office.com/en-us/access
https://microsoft.com/en-us/microsoft-365/blog/access/

KEYWORDS:
TechHelp Access 2016, Access 2019, Access 2021, Access 365, Microsoft Access, MS Access, MS Access Tutorial, #msaccess, #microsoftaccess, #help, #howto, #tutorial, #learn, #lesson, #training, #database, OpenAI integration, recipe generation, Chef’s Kitchen Helper database, pantry items, Access VBA, developer level tutorial, advanced VBA, recordsets in Access, generate dishes, AI-enhanced cooking, Access API integration, automated recipe suggestions, database programming, VBA scripting, OpenAI API key.

QUESTIONS:
Please feel free to post your questions or comments below. Thanks.
Live long, and prosper.

Welcome to another techelp video brought to you by access learning zone.com I’m your instructor Richard Rost got a good one for you today folks we’re going to take the Chef’s Kitchen Helper we’re going to AI it we’re going to integrate it with chat GPT open Ai

And we’re going to use it to say hey this is the stuff I have in my kitchen pantry right I got milk I got marinara sauce I got pepperoni I got whatever right here’s my list of ingredients you tell me what I can make with it

And we’ll have chat GPT do the hard work today’s question comes from Nolan in evinston Illinois one of my Platinum members Nolan says I’ve been using your Chef’s Kitchen Helper database for over a year now and it works great but I got the thinking that I could use chat GPT

To help me come up with some new recipe ideas based on what I have in my pantry I can copy and paste my list of ingredients into the GPT interface but is there a way I can just integrate this into my database directly I know you

Showed us how to do some stuff with GPT before with access how would I put these two things together well that’s a great idea Nolan with the Chef’s Kitchen Helper that I showed you how to build before you’ve got a list of all the products that are

In your pantry right now all the different ingredients we could literally take that build a text string out of it send that text string to open Ai and say with some instructions and say hey based on these ingredients give me three dishes or five dishes or whatever that I

Can make out of this stuff right and then there you go and we’ll have chat GPT do all the hardwork so what do we need to know well first off this is going to be a developer level video which means we’re going to need a decent

Amount of VBA with this one this is more of an advanced level VBA uh video for you and in fact we’re going to have to use record sets in today’s video record sets allow us to say okay here are the records in my table I want to Loop

Through them and read in the data into VB right and to create a text string that’s got one or more records worth of data in it that I can then take that text string and do stuff with it like send it to open AI okay so definitely go

Watch my record sets video If you haven’t worked with record sets before this is pretty much the only way that I can think of to do this and I love record sets I use them all the time so definitely a good tool to have in your box if you haven’t watched my Chef’s

Kitchen Helper video this one’s about four years old this was a popular one back in the day uh go watch this in fact this one came up even before I had my my tech help free template so it’s just a couple of tables and some queries but

Basically in this database I show you how to to put in your list of ingredients you specify the recipes right like a pizza requires this much flour this much marinara sauce this much pepperoni this much monzer Treese and then the database will will tell you based on what the required quantities

Are and what you have on hand what you can make okay so go watch this just to get a feel for it if you want to this is kind of optional because we’re going to just all you need really is a product table this is definitely the big one

Though definitely go watch the open AI video there’s two parts to it I will teach you how to build a database where you can send information to open AI get a response back display that in your form uh we’re going to be working with a copy of this database

For today so if you haven’t built this yet go build it now go watch this video and follow along build it if you’re a gold member you can download the database off my website that’s one of the benefits of being a member and then once you done once you’ve got that then

Come on back all right I’m going to start with grabbing a copy of the Chef’s Kitchen Helper database since I’m a gold member on my own website I can do that here’s the download right there I’m going to click on that it’ll download the file there it is right there let’s

Open her up and this database is pretty simple we got a list of products and this is really all we need for today right we got a product ID which we don’t really don’t care about product name that’s your products your quantity on hand and your unit type ounces cups

Pounds whatever okay that’s all we need the rest of stuff in this database is if you want to you know put in your own recipes right cereal pancakes chicken parm and then you specify the ingredients required for each recipe I cover this in that other video all we

Really need for today is this because we’re going to make chat GPT tell us what to do now you could do this yourself manually using the chat GPT web interface if you want to let me show you an example all right here I am in chat

GPT on the web uh you can use gp4 GPT 3.5 works just fine uh I’ve tried it in both of them gp4 is a little more advanced of course by the time you’re watching this it could be the year 2030 and we’re up to GPT 85 I don’t know but

Anyways we’re just going to come down here okay we’re going to type in a basic prompt like I’m going to give you the contents of my food pantry please suggest three dishes that I can make using these ingredients now don’t hit enter yet hit shift enter a couple times

So you’re on a blank line go up to your product table select these columns like that copy it contrl + C come back over here and then paste that in there’s your stuff and yeah GPT can make sense out of that and then send it and then right

Away there you go there’s three three dishes for you chicken parm with spinach pasta yeah I got that stuff chicken breast flour eggs parmesan cheese spinach pancakes with eggs uh I don’t know if that that that sounds kind of okay right creamy chicken alfredo pasta sure sounds great okay so what we want

To do with today’s lesson is we want to make access do this so I can just from my database you know keep your product list up to date update your pantry whatever and then when you’re ready for some ideas for dinner click the button and have it tell you you know some

Different ideas okay so now the next step is to go get my open AI database I believe it’s on part two yeah so usually you’ll find links to multiple Parts down here there’s part two and usually the database is on the last part this is a two-part series there’s the database

Right there I’m going to click on that bad boy have that download all right we can open up the open AI database all right here we are now this is the members version of it so if you’re not a member there have been a a few changes

To this basically what I did was uh in the in the free version we just had one command which was please correct for spelling in grammar well in the Extended Cut we made it so you can have different bots so you can pick okay reply as if

You’re Jean Luke Picard right if I say you know please go to the store and you can say you know please reply as if you’re Jean Luke Picard it will come back with that answer and of course I’m getting error unauthorized because and I was going to bring this up

But I I jumped the gun uh we have to go go into the secret key mod and in here is where you have to put your API key remember if you’re going to do this you need an API key from open AI so you put

That right in here I’m going to put mine in now and you’re not going to know what it is because it’s mine and I don’t want you running up my bill but go ahead and put your API key key in here now and now that my API key is in there it should

Come back there we go make it so engag make your way to the store and proceed with your mission so that’s what we did in the other one or you could say you know reply is Mr Spock let’s see what it comes back with oh this is a need fasinating you’re

Suggesting physical a physical visit to acquire Goods I love it anyways uh so that’s basically what we added in the Extended Cut all right so next up let’s take the product table from our chef database and bring that over here okay that’s all you got to do now we really don’t need this

Other database anymore we can close that and get it out of the way all right so we got our list of products from our pantry in our AI database now we’re going to set up a bot for the instructions for the chef so I’m going to go to the bot table if you’re

If you’re building this off the free database you’re not going to use a bot you’re just going to replace the instructions your system message with this okay we’ll call this the chef’s Helper and I’ll put that same set of instructions in here that I gave to chat GPT okay now what we’re essentially

Going to do is we’re going to take this and send it as a system message and then we’re going to send our list of products as the user message okay all right now note that this members note that this is id7 for our send to open AI phone function all

Right so instead of using this send open AI which which uses these Bots here okay what we’re going to do is we’re going to make another button in fact I’m going to get rid of these we don’t need all these buttons and let’s just rename this guy

Chef’s helper in fact what I’m going to do is we don’t need we can keep this stuff around if you want to keep it around just kind of bring it over here make it smaller right we’ll send to open AI we put our little bot over

Here okay um yeah we just know change this to Chef’s helper whatever you want to do make it look pretty I make it look pretty for this for the slide right Chef’s helper whatever okay but we want a nice big area over here so we can see

What the responses so we can see all the dishes okay we’ll do like that okay now we’re going to use a custom button to send this stuff all right we’re not going to use these we’ll keep these around in case you want to use them something else but this is the

Button that’s going to be sending our stuff to open Ai and getting the response let’s rename the button uh it’s customer list button right now let’s call this the chef button now we’re going to take the code out of the send open AI button all right so go in here build

Event all right this is the code here for the members uh the non-member version all I did was I took that all that code in the button and I just encapsulated it into this function called ask open AI all right which sends to it the text which is the user message

And the bot information which is the instructions all right that’s all that does you should be able to figure out how to work with that we’re going to copy that stuff there we’re going to drop it in this button here okay now our bot combo we’re not going

To use the bot combo we’re just going to put in there our id7 we’re going to use the chef bot okay and the we’re going to send to it is not going to be my text my text is the text box we don’t want to send that we want to send our product

String all right what’s the product string well the product string is a string we’re going to build up from all of our products all right so we’re going to dim that as a string okay so we’re going to build up a product string which is a list of all

The products out of the product T which we’ll use a record set for okay and then we’re going to send that as the data with the instructions from the bot bot 7 and that’s going to go to open Ai and we’ll get our reply back and we’re going to build that

Product string in tomorrow’s class so tune in tomorrow same bat Time same bat Channel or if you’re a member you can watch it now cuz I’m going to record it in just a few minutes and part two we will continue on by building our string of products to

Send to open Ai and make sure this whole thing works works all right so that’s going to be your Tech help video for today hope you learned something live long and prosper my friends I’ll see you tomorrow for part two if you enjoyed this video please

Give me a thumbs up and post any comments you may have below I do try to read and answer all of them as soon as I can make sure you subscribe to my channel which is completely free click the Bell icon and select all to receive notifications when new videos are

Posted want to learn more click the show more link below the video to find additional resources and links YouTube does a pretty good job of hiding it it’s right down there see this part of the description here right the name the videos up here there’s a little show

More down there right down the bottom it’s kind of hard to find but once you click on that you’ll see a list of other videos additional information related to the current topic free lessons and lots more and YouTube no longer sends out email notifications when new videos are

Posted like used to do but if you’d like to get an email every time I post a new video click on the link to join my mailing list and you can pick how frequently to get emails from me either as they happen daily weekly or monthly now if you’d like to become a

Paid member of my channel and receive all kinds of awesome perks click on the join button you’ll see a list of all the different membership levels that are available each with its own special perks including my Extended Cut videos access to my code Vault lots of VBA source code in there template downloads

And lots more I’ll talk more about these Perks at the end of the video even if you don’t want to commit to becoming a paid member and you’d like to help support my work please feel free to click on the tip jar link your patronage is greatly appreciated and

Will help keep these free videos coming I got some puppies to feed but don’t worry no matter what these free techel videos are going to keep coming as long as you keep watching them I’ll keep making more and they’ll always be free now if you really want to learn

Access and you haven’t tried my free access level one course check it out now it covers all the basics of Microsoft Access including building forms queries reports and more it’s over 4 hours long you could find it on my website or on my YouTube channel I’ll put a link down

Below you can click on and did I mention it’s completely free the whole thing free for 4 hours go watch it and okay okay a lot of you have told me that you don’t have time to sit through a 4-Hour course so I do now have a quicker Microsoft Access for beginners

Video that covers all the basics faster in about 30 minutes and no I didn’t just put the video on fast forward but I’ll put a link to this down below as well now if you like level one level two is just a dollar that’s it $1 that’s another whole like 90minut course level

Two is also free for paid members of any level including supporters so if you’re a member go watch level two it’s free okay want to get your question answered in a video just like this one visit my techel page and send me your question there members get priority of

Course while I do try to read and respond to all of the comments posted Below in the comments section I only have time to go through them briefly a couple of times a month and sometimes I get thousands of them so send me your question here on the tech help page and

You’ll have a better chance of getting it answered and while you’re on my website be sure to stop by my access Forum we’ve got lots of lively conversations about Microsoft Access and other topics I have a fantastic group of moderators who help me answer questions shout out to Alex

Kevin Scott Adam John Dan Juan and everybody else who helps out on the site I appreciate everything you do I couldn’t do it without you be sure to follow my blog find me on Twitter and of course on YouTube yeah I’m on Facebook too but I don’t like Facebook don’t get me

Started now let’s talk more about those member perks if you do decide to join as a paid member there are different levels silver gold platinum and diamond silver members end up get access to all of my Extended Cut techel videos one free beginner class every month month and some other

Perks Gold members get all the previous perks plus access to download the sample databases that I build in my techel videos plus access to my code Vault where I keep tons of different functions that I use the code that I build in most of the videos You’ll also get higher priority

If you do submit any Tech help questions now answers are never guaranteed but you do go higher in the list for me to read them and if I like your question you got a good chance of being answered you’ll also get one free expert level class each month after You’ finished the beginner

Series Platinum members get all the previous perks plus even higher priority for Tech help questions you get access to all of my full beginner level courses for every subject and I cover lots of different subjects like word excel VBA ASP lots of different stuff not just access these are the fulllength courses

Found on my website you get all the beginner ones in addition once you finish the expert classes you get one free developer class per month so lots of training and finally you can also become a diamond sponsor you’ll have your name or your company name listed on a sponsors page

That will be shown on each video as long as you’re a sponsor you’ll get a shout out in the video and a link to your website or product in the text below the video and on my website so that’s it once again my name is name is Richard Rost thank you for

Watching this video brought to you by access learning zone.com I hope you enjoyed I hope you learned something today live long and prosper my friends I’ll see you again soon for