Table Design - .tiff file images

[dallin]

I want to create a table that holds information about contracts and one of
the columns will be a scanned image of a contract .tiff file.

What is the best way to create the table and column so I can type the path
of where the .tiff files reside and ultimately have the user just click on
the .tiff file reference in the table and have the image open for viewing or
printing?

 

[John Nurick]

Hi Dallin,

Store the file name in a text field in the table (e.g. XXX.tiff). Store
the path to the folder separately (e.g. in a "settings" table along with
other settings, or in a global constant). To open the file, concatenate
the two (with a \ between) and pass the result to
Application.FollowHyperlink.

Doing it this way means you only have to change the path in one place
when the location of the folder changes - as it will<g>.

 

[dallin]

Thankyou - I'm not familar with passing results from concatenating fields --
can you point me to some references/literature that gives examples of how to
do it?

 

[John Nurick]

I typed
concatenate
in Access's "search help" textbox. The help topics
Combine text values
and
About combining and manipulating text values
should get you started.