So in a previous post:
I demonstrated how one could easily integrate the means to crop images. This was fine and works very well.
That said, I wanted to push things further. I know that quite often, I need to do a little more than just crop an image. I don’t need a full blown editor like Photoshop, GIMP, Paint.net, … but I do need the ability to resize, crop, insert some text and a few other simple things (from time to time).
Wouldn’t it be nice if we could do all of this in Access directly and no longer need 3rd party applications, or ActiveX controls? Wouldn’t it be nice if we could have a seamlessly integrated full fledged image editor in a Microsoft Access form!
So, I went out searching and found a few options. Time after time I would try to implement them and kept hitting the HTML/HTTP CORS wall. Such a PITA!
Eventually … I finally found a technique to bypass CORS and managed to put together a pretty nice tool, IMHO.
Now, I can take no credit for the editor itself! All I’ve done is managed to integrate it into Access so we can all benefit from it.
This is based off of the Toast UI Image Editor (link below) which is JavaScript based, so an HTML image editor which enables:
- Cropping
- Flipping
- Resizing
- Rotation
- Drawing
- Shapes
- Text
- Image adjustments (grayscale, sepia, contrast, brightness, …)
more than most people need. It is also highly configurable, so you can simply change the configuration in the template HTML file to change the look/feel, which menus are available, …
Well, that will pretty much wraps things up for me as far as working with images directly in Microsoft Access. I don’t think we can truly go much further without getting into requiring professional 3r party applications.
So I hope this will help a few of you out there!
Let me know your thoughts on this demo and what other features/functionalities you might be look for.
Demo Database
Feel free to download a 100% unlocked copy of a sample database I have put together to illustrate some of what is discussed above by using the link provided below:
Download “Image Editor Demo” ImageEditing.zip – Downloaded 5160 times – 1.27 MBNotice About Content/Downloads/Demos
Disclaimer/Notes:
If you do not have Microsoft Access, simply download and install the freely available runtime version (this permits running MS Access databases, but not modifying their design):Microsoft Access 2010 Runtime
Microsoft Access 2013 Runtime
Microsoft Access 2016 Runtime
Microsoft 365 Access Runtime
In no event will Devhut.net or CARDA Consultants Inc. be liable to the client/end-user or any third party for any damages, including any lost profits, lost savings or other incidental, consequential or special damages arising out of the operation of or inability to operate the software which CARDA Consultants Inc. has provided, even if CARDA Consultants Inc. has been advised of the possibility of such damages.
Additional Resources
This is excellent!! Regarding other suggestions, here’s one… I’d be interested in seeing a demonstration of a calendar within the Access Edge Browser control. Populating the calendar from SQL and equipped with CRUD operations. (this would be similar to what you’ve done with Chart.js)
For example, using something like this:
https://williamtroup.github.io/Calendar.js/https://fullcalendar.io/Thanks for your website!
Great idea, it works fine.
It seems to load faster local immages then with default browser settings.
Thanks for sharing this,