Resize Images in Microsoft Access: Using FFmpeg & Paint with VBA - Advanced Developer Tutorial
ฝัง
- เผยแพร่เมื่อ 18 ก.ย. 2023
- In this Microsoft Access tutorial, I'm going to teach you how to resize images directly from your Access database. We'll cover two distinct methods for achieving this. First, we'll explore how to use the Shell function in VBA to run FFmpeg, an open-source multimedia handling utility. Next, for those who prefer an approach that doesn't require 3rd-party software, I'll guide you through a technique using SendKeys and Microsoft Paint. This tutorial is designed for both Advanced users and Developers, offering a practical way to manipulate images within Access.
Maya from Eagan, Minnesota (a Silver Member) asks: How can I resize large, high-resolution JPEG files from my photographers to a more manageable size, like 500 pixels across, so that I can easily link them to my Microsoft Access database?
BECOME A MEMBER:
TH-cam: / @599cd
or My Site: 599cd.com/THMember
LEARN MORE:
Resize Images: 599cd.com/ResizeImages
PREREQUISITES:
Images: 599cd.com/Image
Intro to VBA: 599cd.com/IntroVBA
Error Handling: 599cd.com/ErrorHandling
LINKS:
Shell Command: 599cd.com/Shell
Sleep: 599cd.com/Sleep
SendKeys: 599cd.com/SendKeys
FFMPEG:
FFmpeg Project: ffmpeg.org
Specific Build: www.gyan.dev/ffmpeg/builds
RECOMMENDED COURSES:
Access Developer Courses: 599cd.com/Developer
FREE TEMPLATE DOWNLOADS:
TechHelp Free Templates: 599cd.com/THFree
Blank Template: 599cd.com/Blank
Contact Management: 599cd.com/Contacts
Order Entry & Invoicing: 599cd.com/Invoicing
More Access Templates: 599cd.com/AccessTemplates
ADDITIONAL RESOURCES:
FREE Access Beginner Level 1: 599cd.com/Free1
How to Use Access in 30 Minutes: 599cd.com/30Minutes
$1 Access Level 2: 599cd.com/1Dollar
Donate to my Tip Jar: 599cd.com/TipJar
Get on my Mailing List: 599cd.com/YTML
Contact Me: 599cd.com/Contact
TechHelp: 599cd.com/TechHelp
Consulting Help: 599cd.com/DevNet
Twitter: / learningaccess
en.wikipedia.org/wiki/Microso...
products.office.com/en-us/access
microsoft.com/en-us/microsoft...
KEYWORDS:
access 2016, access 2019, access 2021, access 365, microsoft access, ms access, ms access tutorial, #msaccess, #microsoftaccess, #help, #howto, #tutorial, #learn, #lesson, #training, #database, resize images in access, resize pictures, ffmpeg, shell, sendkeys, Access VBA Image Resize, Image Manipulation Access, Scale Images Access Database, Access Image Control, VBA Code Image Resize, Batch Resize Access, MS Access Image Optimization, VBA Picture Resize
QUESTIONS:
Please feel free to post your questions or comments below. Thanks.
I swear go G*D you read my mind.
I was storing images in the new database until you showed us how to link an image to the image object.
I was then using my Raspberry PI to run a program manually to create thumbnails...
And then this TH-cam upload came along literally a week later. I was already getting fed up of going on to the PI to do it and this has upload literally dropped in a week later.
After some typos on my part it worked like a DREAM. I'm so impressed with what I've learned from your uploads in the last few weeks. Is there NOTHING you don't know about Access????
Legend.
I'm sure there's one or two things here and there. I try to learn something new every week myself. I follow a lot of other great authors that write about Access like Mike Wolfe. nolongerset.com
Richard, thanks for the video! I really like your "automation" tips!
Glad you liked it
This is so... nifty, thanks for the hint, never read through the manual of 'ffmpeg' to know that images can also be resized! Also you refreshed to my mind, the 'shell' (but not shallow) way to do things. Live long and prosper, Rick!!
Glad you liked it
We would like a drag drop image + Copy to a specific path + resize. Drag and Drop is the most important.
I played around with drag and drop before but Access doesn't natively support it so I'm still working on a decent solution
@@599CD thanks for your reply. A Indian guy made a access file that used dll files to make drag and drop works. That worked perfectly, but I can't trust the dll he made to use on my end software.
Yeah, that's the problem... I don't like 3rd party add-ins either.
Thanks Richard,
Welcome
I will tell you 1000 thanks in Arabic "شكرا جزيلا
1000 you're welcomes
Great tip using ffmpeg. Can you do a video to show how to run the routine on a folder for example that has several images in there. Thank you.
That... would be... INCREDIBLE!!!!
I cover looping through files in a folder in this class: 599cd.com/ACD31
Thank you so mach ..❤
If possible, a link to download the file
Gold members can download files from my website
Hi Richard. Perhaps if you requery the control instead the Recordset it also works. Sometimes I use Me!ProfilePictureImage.Requery to repaint some control.
I think I tried that