Very Newb question on hyperlink

[skim464]

Hi all

I am really new to database coding (almost never coded much before)



I have an access database and I want to hyperlink each cell to a specific file in the hard drive

011-1234

021-1234

211-0011

231-0001

311-1101

411-0401

461-2101

My database looks somewhat like that on the first column
I want to make it so that when I click on the value it opens (like hyperlink) the following file

C:\01\011-1234.jpeg
C:\02\021-1234.jpeg
C:\21\211-0011.jpeg
C:\31\311-1101.tif
... respectively
first two number is the folder number and the whole value is the name of the file and the modifier will be either jpeg or tif (So probably if it can't find jpeg, it looks for tif)

Is it hard to code? If you got a bit of time, please help me I am so new to programming and I don't even know how to call the value from the table.

[pbaldy]

One option is FollowHyperlink, and you can build a string:

"C:\" & Left(FieldName, 2) & "\" & FieldName & ".jpeg"

You can use Len() with Dir() to test if the file exists, and if not switch to the tif.