Results 1 to 8 of 8
  1. #1
    Join Date
    Mar 2009
    Posts
    10

    Unanswered: Access Report Disappearing Images

    Some images print out blank on my Access Report. I have the path and filename of the image stored in SQL database using MS Access interface. For the report On Format event (have also tried on the Print event with the same results) I have the following code

    Me![ImageFrame1].Picture = Me![ImageFile1]
    Me![ImageFrame2].Picture = Me![ImageFile2]

    where ImagFrame1 and 2 refer to two image controls and ImageFile1 and two are to text fields on the report bound to the table fields containing path and file name of images.

    Usually three images get printed whether I send 3, 4 ,5, 6, or 15 records with images. The images usually show up in a print preview (sometimes missing one or two.) When I try to print to Adobe, I usually get 0-2 images to print regardless of the number sent.

    Will Access Reports just not handle a job like this? Suggestions?

  2. #2
    Join Date
    Nov 2004
    Location
    out on a limb
    Posts
    13,692
    Provided Answers: 59
    probably best to ask this in the Access forum
    I'd rather be riding on the Tiger 800 or the Norton

  3. #3
    Join Date
    Sep 2006
    Posts
    265
    I would try creating a subform(s) for the images.

    On Print seems to work for me. I don't use the picture property but an ActiveX control instead so I'm guessing.

    Simon

  4. #4
    Join Date
    Nov 2007
    Location
    Adelaide, South Australia
    Posts
    4,049
    I don't work with images that much in Access, but when I have, they seem to work for me.

    Could it be a machine memory restriction? How many images are there to print?
    Owner and Manager of
    CypherBYTE, Microsoft Access Development Specialists.
    Microsoft Access MCP.
    And all around nice guy!


    "Heck it's something understood by accountants ... so it can't be 'that' difficult..." -- Healdem
    "...teach a man to code and he'll be frustrated for life! " -- georgev

  5. #5
    Join Date
    Sep 2006
    Posts
    265
    Images will work and I have had them working since Access 1997. I have encountered no problems with Access 2007 using .picture property.

    Memory is not an issue, if the images are large over well over 200Kb, the reports do struggle.

    Simon

  6. #6
    Join Date
    Mar 2009
    Posts
    10
    Bingo! It worked to compress the pictures. I was trying to avoid that extra step since they deal with so many pictures and they are always worried about the resolution. Got any code in your back pocket to add that extra step when they select their folder? I have used the Microsoft Office Picture Manager to compress but so far just hand-jam them.

    Thanks for your suggestion.

  7. #7
    Join Date
    Nov 2007
    Location
    Adelaide, South Australia
    Posts
    4,049
    Awesome, glad you got it sorted.

    I don't have code to compress a jpg, but that's probably another topic.
    Owner and Manager of
    CypherBYTE, Microsoft Access Development Specialists.
    Microsoft Access MCP.
    And all around nice guy!


    "Heck it's something understood by accountants ... so it can't be 'that' difficult..." -- Healdem
    "...teach a man to code and he'll be frustrated for life! " -- georgev

  8. #8
    Join Date
    Sep 2006
    Posts
    265
    There is a paid for ActiveX component called dbpix which does have properties regarding resolution however even with this I still use Photoshop because I can do a lot more than just resolution adjustments. Sometimes you can follow a global rule regarding images and it better to see the effect before you commit the resolution changes. I have dealt with 17,000 images and resizing and correcting the resolution is a real pain!

    Simon

    Simon

Posting Permissions

  • You may not post new threads
  • You may not post replies
  • You may not post attachments
  • You may not edit your posts
  •