Darren - Active Billing
darren at activebilling.com.au
Wed Oct 6 00:04:00 CDT 2010
Hi Joe Google this text "resize images" + VBA Got some interesting results Also lebans (of course) has some stuff to manipulate images http://www.lebans.com/imageclass.htm PictureBoxA97.zip is the updated version Also Google "ImageMagick" - I found some clever and simple code to use that tool to resize images via code http://www.imagemagick.org/script/index.php Can be called via VBA code using its command line Good luck Darren -----Original Message----- From: accessd-bounces at databaseadvisors.com [mailto:accessd-bounces at databaseadvisors.com] On Behalf Of Joe O'Connell Sent: Wednesday, 6 October 2010 3:28 PM To: Access Developers discussion and problem solving Subject: [AccessD] Resize pictures I am developing an A2003 application for a division of a construction company that installs guardrails on highways. They have long term contracts with the Department of Transportation to fix/repair/replace guardrails that have been damaged. Part of the documentation that is required is to provide a "before" and an "after" picture for all repairs. The application lets the user browse the memory card for the pictures and then copies them to the computer's disk. The original size of the pictures is 5-6mb. Not only will a lot of disk space be required to store the pictures, but pictures of this size take a lot of time to be scaled for forms and reports. Due to the number of pictures processed each day, it is not feasible for the user to manually resize the pictures before uploading. What I would like to do is to resize the pictures during this transfer process to about 10% of their original size. Any suggestions or code snippets to resize the pictures are greatly appreciated. Joe O'Connell -- AccessD mailing list AccessD at databaseadvisors.com http://databaseadvisors.com/mailman/listinfo/accessd Website: http://www.databaseadvisors.com