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

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

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
 
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
 
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
 
Thanks Alec, I will try your suggestion and see how I get on! Will probably
be back again!
 
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
 
Back
Top