Solved Report won't Print Multiple Pictures. (1 Viewer)

HillTJ

Registered User.
Local time
Yesterday, 17:22
Joined
Apr 1, 2019
Messages
337
Hi,I have a report that includes a sub-report of photos, which can be scrolled through using the record nav buttons. I have a control on the form that contains the file path called [Attachment_Link] to the saved photos, then i set the image control Control source = [Attachment_Link]. Upon previewing the form, only the first photo is displayed. Any ideas? Appreciate it.
 

HillTJ

Registered User.
Local time
Yesterday, 17:22
Joined
Apr 1, 2019
Messages
337
Arnel, a report. Interestingly, another field on that same 'subreport', basically a description of the photo, prints for each record. Cheers
 
Last edited:

bastanu

Registered User.
Local time
Yesterday, 20:22
Joined
Apr 13, 2010
Messages
408
How big are the picture (file size)? I have found that working with anything over about 1-2 MB will overwhelm Access. And usually the bigger file size is not really needed for a picture embedded in an Access report (there are tools available that allow you to resize all pictures in a certain folder).

Another thing to try is to leave the image control unbound (set its Picture property to (none) and in the subreport's Detail section Format event add code to set it:
Me.ImageFrame1.Picture = Me.Attachment_Link ' the Attachment_Link textbox could be hidden

Cheers,
 

HillTJ

Registered User.
Local time
Yesterday, 17:22
Joined
Apr 1, 2019
Messages
337
Vlad, will give it a go. The pictures are taken from my phone, can be 4mb with current phone camera resolution. The second photo does not display on a preview either. I'll save some examples at lower resolution and try too. Thanks for the prompt response.
 

HillTJ

Registered User.
Local time
Yesterday, 17:22
Joined
Apr 1, 2019
Messages
337
Vlad, that didn't work but I was able to preview & print multiple images when freshly linked & running on an alternate PC & printer (My home). I did find some code to reduce the size of the image though. Will give this a go. Thanks.
 

The_Doc_Man

Immoderate Moderator, Former MVP, Retired SysAdmin
Staff member
Local time
Yesterday, 22:22
Joined
Feb 28, 2001
Messages
18,302
If it works on one machine but not on another, it is time to try to find differences between them. The most common culprit is if you look (on both machines) to see when and to what version of Windows they were patched, ditto for Office updates. The next question would be whether your machine that has the problem is part of a domain that imposes strict group policies.
 

arnelgp

error reading drive A:
Local time
Today, 12:22
Joined
May 7, 2009
Messages
10,832
what is Attachment_Link, is it a fieldname.
you Can only use the Image ControlSource to the Fieldname.
i don't know but i can view, Any size of picture with this setup.
 

HillTJ

Registered User.
Local time
Yesterday, 17:22
Joined
Apr 1, 2019
Messages
337
ArnelGP/The_Doc_Man, Yes 'Attachment_Link' is a fieldname. I refer to this as the control source of the image. This all works fine on a form. I have dramas when I attempt to print out (or view) a report where the last 'picture' is missing. Since posting this, I've installed a module that reduces the picture file source which can be 10mb down to about 1mb. It seems through my initial testing that that this works?
 

HillTJ

Registered User.
Local time
Yesterday, 17:22
Joined
Apr 1, 2019
Messages
337
Gents, Seems to work now. I was able to view & print out multiple photos. Thanks.
 

Users who are viewing this thread

Top Bottom