Linking images specific data, and displaying in report.

[Rocky]

Hello,

First I will give a little background on what I what to do.

Currently I am handling a large amount of data with excel. I have a master
sheet that summarizes data that is located in other workbooks. Each one the
workbooks are for a single day holding a large amount of data relating to a
specific asset, and there are multiple assets. In each work book there is an
image relating to that day for that asset

the problem is that I don't know how I could handle these images. I would
like to have them linked to their respect asset and day so that it can be
queried when needed, and displayed in a report.

 

[Fred]

Hello Rocky,

Store the images in a separate folder, then store and pathe and file name of
the image in one or two text fields of the record that it relates to. Then
use code to display the image in Forms and Reports.

There have been several posts in this forum with how to do the code.....you
might search there, . I'm not fluent enough to just write it from memory.


Hope that helps a little.