Table Design - .tiff file images

  • Thread starter Thread starter Guest
  • Start date Start date
G

Guest

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?
 
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>.
 
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?
 
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.
 
Back
Top