making linked images appear in Reports

[yamalis]

I'm having a real tough time trying to get images (photos, tables, graphs, etc) appear in Access Reports. The goal is to link to images on a network server, rather than actually make the image a part of the Access Database. I found one way to do it, but then the same 2 images appear on every page of the report. The report can be thought of as a series of 1-page fact-sheets, with each page representing a new fact-sheet for a new site. This is why it's necessary to have Access update the image boxes for each page of the report. This report must be printable, as well as viewable on a monitor.

All suggestions appreciated. thanks!

 

[GumbyD]

I have created a similiar report and the way I delt with that was to put a "fake" image in the design view of the report and then in the Format event for the section containing the image I changed the property to the file I wanted to display from the network. It worked very well and as faster than I expected it to be.

Good Luck

GumbyD

 

[yamalis]

Thanks GumbyD. I'll give that a shot. But did you have to enter the path to that specific file in the Format Event, or were you able to refer back to a field in a table containing a list of paths to all the files that need to be in the report? For example, let's say there are 10 different images, 2 of which must appear on each page for a 5-page report. Will 2 new images appear on each page as I send this to the printer?

 

[GumbyD]

I referred back to the field in the query I was using. The report I was using actually printed 8 images per page and switched them depending on what was in the query. Here is the code I used:

Private Sub Detail_Format(Cancel As Integer, FormatCount As Integer)

Dim LocSt As String

LocSt = Me.PictureLocation
Image9.Picture = LocSt


End Sub

I made me.PictureLocation a hidden field on the form, my dummy picture is the field Image9 - then I just update the Picture property to the value of the hidden field.

GumbyD