tags:

views:

22

answers:

1
Q: 

VBA photo/image compression

Hi there, I am wondering if this is possible and within the realms of Access?

I currently have a database system where the user can open up directories/folders related to the record; such as images, docs etc... This avoids bloat by attaching the images to the records and what not, and works fine.

A user enhancement would be to allow the user to automatically compress photos so that they are more appropriate in file size to attach to emails.

I was wondering if it would be possible to, say whilst using the FileSystemObject and CopyFile, copy the photos from one folder (/photos) to another folder (/compressed_photos) and compress them at the same time.

Could I use "VBA.Shell" and run a batch image compression program on the photos?

Any advice on the above is greatly appreciated, even if it is just to confirm that it is not possible.

Cheers Noel

+2  A: 

A simple solution would be to use ImageMagick via Command Line. See the examples on the manual pages there.

Tom  2010-10-21 11:26:15
Cheers tom, ill have a look at that and using the command line in VBA
glinch  2010-10-21 11:59:19
+1 But he might prefer using ImageMagickObject from VBA rather than going through Shell: http://www.imagemagick.org/script/ImageMagickObject.php
HansUp  2010-10-21 12:38:47
glinch  2010-10-21 14:42:46

related questions

MS-Access design pattern for last value for a grouping
Best way to test a MS Access application?
How would you migrate hundreds of MS Access databases to a central service?
Is there anything wrong with this query?
Read Access File into a DataSet
MS Access Reporting - can it be pretty?
Import OLE Object from Access to MySQL
What's the best way to work with SQL Server data non-programmatically?
Is there a way to get ms-access to display images from external files
Using MS Access & ODBC to connect to a remote PostgreSQL
File database suggestion with support for multiple concurent users.
Delete Records from Access database, error while deleting
Converter for VB.NET Code to Linux Platform Exist?
Performance issues regarding Access 2003 and the OLE Object data type
Java code to import CSV into Access
Can you use LINQ tools such as SQLMetal with an access database?
Good Free Alternative To MS Access
Can DTS Test for Presence of MS-Access Table
How to filter by 2 fields when loading data into an access database table from an excel spreadsheet
Any tips on getting Rails to run with an Access back-end?
Disabling multi-line fields in MS Access
Access 2000 connecting to SQL Server 2005
Building an auditing system; MS Access frontend on SQL Server backend.
Is there a way for MS Access to grab the current Active Directory user?
Issues using MS Access as a front-end to a MySQL database back-end?