Free Lessons
Courses
Seminars
TechHelp
Fast Tips
Templates
Topic Index
Forum
ABCD
 
Home   Courses   TechHelp   Forums   Help   Contact   Merch   Join   Order   Logon  
 
Back to Captain's Log    Comments List
Upload Images   @Reply   Bookmark    Link   Email   Next Unseen 
Generate Images in Access with OpenAI
Richard Rost 
          
11 months ago
So you guys have probably seen my videos before where I show you how to integrate OpenAI (which is the ChatGPT engine) into your Microsoft Access database and use it for all kinds of cool things. Well, tonight I spent a little time playing around with image generation using the OpenAI API, and while it's not quite as good as what you can get with the web-based ChatGPT interface, you can get it to do some pretty cool things, and you can control that with your Access database.

You basically use code very similar to what I've built before. You write a prompt like you would on the web, send it to a particular page, and then it will return a URL to a picture generated based on your prompt, which you can then download and save locally and display in your Access database. Then you can do whatever you want with it.

I put together a simple database where you put a prompt in and specify what your images folder is. You can set a couple of things: HD or standard quality (obviously it's an API, so you have to have an API key, and standard quality images cost less than HD images). Then you can pick a few options: vivid or natural style. Vivid is like the colors really pop, whereas natural is a little more muted. I made a list of a whole bunch of different types of styles (like ink wash, impressionist, fantasy, hand drawn, pencil, that kind of stuff), futuristic, sci-fi, so you could pick one of those just to give you some ideas.

Down below are some sample images that I generated with this, and it takes about 5-10 seconds to generate an image, so it's not bad at all. Then you've got them to use with your database. You can automate this, so if you want to make multiple images for different things, you can. I'm curious how many of you would like to see a set of videos on this and how I did it. If enough of you are interested, maybe I'll put something together. And if not, then I'll just put this together as a template, and you guys can play with it and figure it out on your own lol.
Richard Rost OP  @Reply  
          
11 months ago

Richard Rost OP  @Reply  
          
11 months ago

Richard Rost OP  @Reply  
          
11 months ago

Richard Rost OP  @Reply  
          
11 months ago

Richard Rost OP  @Reply  
          
11 months ago

Richard Rost OP  @Reply  
          
11 months ago

Richard Rost OP  @Reply  
          
11 months ago
Then I played it around with a couple of different settings. I tried to get one vibrant and bright with neon accents, which came out pretty good. This looks like the older images that ChatGPT itself would create.
Richard Rost OP  @Reply  
          
11 months ago

Richard Rost OP  @Reply  
          
11 months ago
And sadly, it doesn't produce very photorealistic images like you can get from ChatGPT. Like if you've seen the ones I've produced with my Captain's Log, like Star Trek stuff like Picard and Spock and that. In chatting with ChatGPT, it says that the API has stricter guardrails for intellectual property reasons. It won't let you generate things that are super photorealistic. And they don't want people making them for deepfakes and stuff. So I get it. But if you want a simple image generator that you can tie into your database and run batches and stuff, this is pretty cool.
Richard Rost OP  @Reply  
          
11 months ago

Richard Rost OP  @Reply  
          
11 months ago
You can see the prompt I used there. This is nowhere near 1980s TSR fantasy art. Dungeons and Dragons stuff like Larry Elmore and Jeff Easley who are two of my favorite illustrators. This looks nothing like it and he's holding a sword and he's got his bow and the arrow is knocked but by what? It just doesn't make sense but it's something it's not bad. For a cheesy illustration but I can see this being better for non-realistic stuff like the last batch of photos or images.
Richard Rost OP  @Reply  
          
11 months ago

Richard Rost OP  @Reply  
          
11 months ago
That was actually the first one I tried doing, and it looks like it doesn't look like DND style art, it looks like a 1990s video game art. But that's better than nothing. I'm sure it will get better, and I'm sure they'll make it more realistic. Compare that to some of the stuff I've created with just ChatGPT...
Richard Rost OP  @Reply  
          
11 months ago

Richard Rost OP  @Reply  
          
11 months ago
And here's the one from before using ChatGPT. As you can see, it's significantly better, but the API will catch up eventually.
Richard Rost OP  @Reply  
          
11 months ago

Kevin Robertson  @Reply  
          
11 months ago
That is really cool. I would love to see how you built it. I have recently moved to the paid version so I'm all about getting my money's worth. LOL
Jerry Fowler  @Reply  
       
11 months ago
I am always in the mood for a new video, and the fact that it is using AI is even better. Thanks
John Davy  @Reply  
         
11 months ago
Hi Rick, I would also love to see how you built it.  Thanks  John

This thread is now CLOSED. If you wish to comment, start a NEW discussion in Captain's Log.
 

Next Unseen

 
New Feature: Comment Live View
 
 

The following is a paid advertisement
Computer Learning Zone is not responsible for any content shown or offers made by these ads.
 

Learn
 
Access - index
Excel - index
Word - index
Windows - index
PowerPoint - index
Photoshop - index
Visual Basic - index
ASP - index
Seminars
More...
Customers
 
Login
My Account
My Courses
Lost Password
Memberships
Student Databases
Change Email
Info
 
Latest News
New Releases
User Forums
Topic Glossary
Tips & Tricks
Search The Site
Code Vault
Collapse Menus
Help
 
Customer Support
Web Site Tour
FAQs
TechHelp
Consulting Services
About
 
Background
Testimonials
Jobs
Affiliate Program
Richard Rost
Free Lessons
Mailing List
PCResale.NET
Order
 
Video Tutorials
Handbooks
Memberships
Learning Connection
Idiot's Guide to Excel
Volume Discounts
Payment Info
Shipping
Terms of Sale
Contact
 
Contact Info
Support Policy
Mailing Address
Phone Number
Fax Number
Course Survey
Email Richard
[email protected]
Blog RSS Feed    YouTube Channel

LinkedIn
Copyright 2026 by Computer Learning Zone, Amicron, and Richard Rost. All Rights Reserved. Current Time: 5/6/2026 2:57:25 PM. PLT: 2s