Creating a link/hyperlink to a set of tiff files on a CD

[Guest]

Hi, I have a table designed, there are over 1000 records and I need to create
a link/hyperlink from each record to a tiff file on a CD rom. I have one
column whose field name is the same name as the tiff file name (how will the
extension be read?). If I had to complete this task manually it would take
forever! Also I may need to add to this list in the future. Any help would be
appreciated

Thanks

 

[Guest]

Thinking about it again, having gone for a coffee (don't you hate working
Saturdays) i realised that the above was about as clear as mud.

The calculations above should form a hidden text box on your form, then
create an object, like a "look at photo" button maybe, right click it, and in
it's properties, look for "hyperlink address". Set that to be equalt to your
calculated field's contents

Alec

 

[Guest]

As you'll gather if you have seen any of my posts, i am no expert
(understatement of the year!) but I think what you want to do is this

Assuming you have a form, and the form will display the filename to the user
for him to click and view the file, then

filename=file & ".tiff"

will get you the filename bit, but you will need to add a path in there too,
so maybe

filename="D:\mydbase\myphotos" & file & ".tiff"

would be better. You can then simply format this calculated field as a
hyperlink. generating it on-the-fly like this keeps your database size lower
than storing it in a table, and thus makes it faster.

Good luck

Alec

 

[Guest]

Thanks Alec, I will try your suggestion and see how I get on! Will probably
be back again!

 

[Guest]

Hi again Alex,

We have tried that to no avail.
would it be possible to provide the excat steps so that I can follow.
I dont have much experience with programming therefore I would appreciate
the steps.

Thanks

Phil