MULTIPLE pictures on a report

[Dave Reardon]

I have created a database in Access 2007. I can successfully get pictures to
link to a folder on the network and display individual photos on either forms
or reports. However, what I really need to do is get it to display passport
sized photos of a group of individuals such as a tutor group. The syntax I
have used that works with the forms and reports is of the order:

Private Sub Form_Current()

'view the path to the pictures
Me.ImgStock.Picture = Me.TxtPath

End Sub
Where ImgStock is a control on the form with no related source, and TxtPath
is a text field in the underlying table that contains the path to the images.

Any help gratefully appreciated.

Dave

 

[Wayne-I-M]

There is a good method here
http://support.microsoft.com/kb/285820/en-us

make sure you add this to the report code - or it will not load
Private Sub Detail_Print(Cancel As Integer, PrintCount As Integer)
Me!txtImageNote = DisplayImage(Me!ImageFrame, Me!txtImageName)
End Sub

It will only work if you have a large enough printer buffer (if you want to
print the report) and a good machine (lots of ram) - also if you pictures are
large it will take a lot of proccesor power to load - so keep the pictures
small

Good luck

 

[Dave Reardon]

Thanks Wayne

Alas, the article relates to Office 2003. I have done exactly what it said
and all goes well until it attempts to generate the page, and I get an error
"438 Object doesn't support this property or method." which can be caused by
mis-spelt objects (but I can't find any) or otherwise incompatibility
between dlls... I'm confused :-s

Dave

 

[Wayne-I-M]

Sorry my fault - I assumedyou were using 2k3 (most people still do).

Which access version are you using

 

[Dave Reardon]

Hi Wayne

Access 2007.

Dave

Sorry my fault - I assumedyou were using 2k3 (most people still do).

Which access version are you using