Jim Dettman
jimdettman at verizon.net
Wed Oct 6 09:43:51 CDT 2010
Joe, <<Can dbpix be used to resize the pictures?>> See "ImageResample" under methods of the Reference Guide found here: http://www.ammara.com/support/help/help.html There are also sample DB's. This one is probably close to what you want: http://www.ammara.com/support/samples/access-linking-images.html I haven't used this control myself, but a couple of the Experts on EE have been using it for a for a few years and have spoken highly of it. Of course, your mileage may vary, so download the free trial and play around with it. Jim. -----Original Message----- From: accessd-bounces at databaseadvisors.com [mailto:accessd-bounces at databaseadvisors.com] On Behalf Of Joe O'Connell Sent: Wednesday, October 06, 2010 10:24 AM To: Access Developers discussion and problem solving Subject: Re: [AccessD] Resize pictures Jim, The demo rescales pictures when displaying on forms or reports. I need to resize them to save disk space and minimize time to load into forms and reports. I could not see how this is accomplished in dbpix. As an example one of the pictures is 4,320 x 3,240 pixels needing 5,554KB to store it. Using the resize tool in Microsoft Office Picture Manager, the picture can be reduced to 518 x 389 pixels needing 84KB to store it. For our purposes this reduced picture quality is sufficient. Can dbpix be used to resize the pictures? Joe -----Original Message----- From: accessd-bounces at databaseadvisors.com [mailto:accessd-bounces at databaseadvisors.com] On Behalf Of Jim Dettman Sent: Wednesday, October 06, 2010 9:51 AM To: 'Access Developers discussion and problem solving' Subject: Re: [AccessD] Resize pictures Joe, A couple of the guys on EE use DBPix: http://www.ammara.com/ It has a host of features and has a free trail download that's fully functional. Jim. -----Original Message----- From: accessd-bounces at databaseadvisors.com [mailto:accessd-bounces at databaseadvisors.com] On Behalf Of Joe O'Connell Sent: Wednesday, October 06, 2010 12:28 AM 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 -- AccessD mailing list AccessD at databaseadvisors.com http://databaseadvisors.com/mailman/listinfo/accessd Website: http://www.databaseadvisors.com -- AccessD mailing list AccessD at databaseadvisors.com http://databaseadvisors.com/mailman/listinfo/accessd Website: http://www.databaseadvisors.com