Printing the pictures on an access form 1

[JeMK]

I have used the technique listed in the FAQ's to display pictures of objects on an access form. The pictures are stored outside the database, and are linked in through the after update event for the image on the form, to avoid bloating the database with the 3000 photos that go along with the database.

This works wonderfully well with the form on screen, but I can't print the records with their pictures showing. Is there some similar code that can be used to print the pictures with their relevant details?

 

[smeadows]

JeMe

Try this

Create report , add image field and place this code in report, add image field to report and report will import all images in your table. I use this but find that the report will only print about 300 pictures unless you have the latest spec PC!



Private Sub Detail_Format(Cancel As Integer, FormatCount As Integer)
Photo.Picture = "c:\Directory\" & Me.Image & ".jpg"
End Sub