If this is your first visit, be sure to check out the FAQ by clicking the link above. You may have to register before you can post: click the register link above to proceed. To start viewing messages, select the forum that you want to visit from the selection below. |
|
|
Thread Tools | Display Modes |
#1
|
|||
|
|||
Image error in reports.
I have a database that includes the path and filename of associated
photographs. I am trying to create a report that includes a description of each photo and a thumbnail image. The image is linked in code with Me.imgPicture.Picture=Me.PictureFilename. On the report each image is a little less than an inch tall and the detail section is the same so there are about 12 records per page. A report may have two or three pages. I have had two symptoms. The first symptom is that the report will only have a few images. Five of the 12 records on a page may have their associated image visible and the other seven records will have the description but no image. An alternative symptom is an error message: Run-time error ‘2114’: Microsoft Office Access doesn’t support the format of the file ‘Filename.jpg’ or file is too large. Try converting the file to BMP or GIF format. This message pops up inconsistently after several records have processed. I have read of similar problems here and have tried several of the suggestions but haven't yet found a solution. I have used regedit to suppress the Loading Image dialog and I have converted the images from jpg to bmp in code as the report is created. Thanks, David |
#2
|
|||
|
|||
Image error in reports.
This could be due to a limit in the maximum image size that the Access Image Control can handle. Try running the report after downsampling the images (make backup copies of the image files first!). If you dont have a batch image resizer you can use the free Image Resizer PowerToy from Microsoft. To do this using the PowerToy: 1) Make a backup copy of the image files. 2) Select the image files for your report in an Explorer window. 3) Right-click and choose Resize Pictures. 4) Choose the relevant size (try Large 1024 x 768). 5) Click Advanced and check Resize the original pictures (*** Make sure you have made backups this will irreversibly discard resolution!!! ***) 6) Click OK then try running your report again (it should now be using the reduced resolution images). You can get the Image Resizer PowerToy for XP he http://www.microsoft.com/windowsxp/d...powertoys.mspx -- __________________________________________________ _____ DBPix 2.0: Add pictures to Access, Easily & Efficiently http://www.ammara.com/dbpix/access.html =?Utf-8?B?NDExMA==?= wrote: I have a database that includes the path and filename of associated photographs. I am trying to create a report that includes a description of each photo and a thumbnail image. The image is linked in code with Me.imgPicture.Picture=Me.PictureFilename. On the report each image is a little less than an inch tall and the detail section is the same so there are about 12 records per page. A report may have two or three pages. I have had two symptoms. The first symptom is that the report will only have a few images. Five of the 12 records on a page may have their associated image visible and the other seven records will have the description but no image. An alternative symptom is an error message: Run-time error ‘2114’: Microsoft Office Access doesn’t support the format of the file ‘Filename.jpg’ or file is too large. Try converting the file to BMP or GIF format. This message pops up inconsistently after several records have processed. I have read of similar problems here and have tried several of the suggestions but haven't yet found a solution. I have used regedit to suppress the Loading Image dialog and I have converted the images from jpg to bmp in code as the report is created. Thanks, David |
#3
|
|||
|
|||
Image error in reports.
Ta Da!
Worked like a charm! Thanks Bob. David "bob" wrote: This could be due to a limit in the maximum image size that the Access Image Control can handle. Try running the report after downsampling the images (make backup copies of the image files first!). If you don’t have a batch image resizer you can use the free “Image Resizer PowerToy” from Microsoft. To do this using the PowerToy: 1) Make a backup copy of the image files. 2) Select the image files for your report in an Explorer window. 3) Right-click and choose “Resize Pictures”. 4) Choose the relevant size (try ‘Large’ – 1024 x 768). 5) Click ‘Advanced’ and check ‘Resize the original pictures’ (*** Make sure you have made backups – this will irreversibly discard resolution!!! ***) 6) Click OK then try running your report again (it should now be using the reduced resolution images). You can get the Image Resizer PowerToy for XP he http://www.microsoft.com/windowsxp/d...powertoys.mspx -- __________________________________________________ _____ DBPix 2.0: Add pictures to Access, Easily & Efficiently http://www.ammara.com/dbpix/access.html =?Utf-8?B?NDExMA==?= wrote: I have a database that includes the path and filename of associated photographs. I am trying to create a report that includes a description of each photo and a thumbnail image. The image is linked in code with Me.imgPicture.Picture=Me.PictureFilename. On the report each image is a little less than an inch tall and the detail section is the same so there are about 12 records per page. A report may have two or three pages. I have had two symptoms. The first symptom is that the report will only have a few images. Five of the 12 records on a page may have their associated image visible and the other seven records will have the description but no image. An alternative symptom is an error message: Run-time error ‘2114’: Microsoft Office Access doesn’t support the format of the file ‘Filename.jpg’ or file is too large. Try converting the file to BMP or GIF format. This message pops up inconsistently after several records have processed. I have read of similar problems here and have tried several of the suggestions but haven't yet found a solution. I have used regedit to suppress the Loading Image dialog and I have converted the images from jpg to bmp in code as the report is created. Thanks, David |
Thread Tools | |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Thread Starter | Forum | Replies | Last Post |
Image on Reports A 2003 ? | Bruno Frisque | Setting Up & Running Reports | 5 | October 22nd, 2005 03:50 PM |
Dynamic Image when Printing? | JDP@Work | Mailmerge | 2 | September 10th, 2005 07:11 PM |
Converting .emf images to .gifs loses background image. | zsarduy | Powerpoint | 6 | March 12th, 2005 11:44 PM |
Image Control Access 2002 | Tom | General Discussion | 8 | December 8th, 2004 08:11 AM |
Image Control Table | John Gavin | General Discussion | 3 | June 28th, 2004 04:21 AM |