Hyperlink

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

Guest

I had a previous post on this same topic. I have a data base that I have one hyperlink field in each record that is set according to the field [sq] I am trying to open the link in a report. The link goes to the folder (doorpics) on my C: drive. The only thing in each file is a JPG. I have previously seen this done but I can not remember how to do it

I am trying to insert the contents of each hyperlink into the report. I have 186 individual reports that have to be manually updated DUE TO THE DIFFERENT JPG's then printed. If I can get the hyperlink to open in the report then it will save about 12 hours worth of work. For example the report for 607_COS will already display the hyperlink to 607_COS.jpg but how can I make it open the JPG in the report?
 
Darrin:

Rather than using a hyperlink to the file, its a bit easier to use a simple
text field with the path; but you can use a hyperlink, you just have to
parse it appropriately. (which is why a text field with a path is more
simple.)

An image control has a property call .Picture. What you want to do is in
the On Print Event of the report section that contains the hyperlink / path
to the file, set the Image control's .Picture property to the value of the
path (it won't take a hyperlink, that's why you have to parse the link to a
properly formatted unc or local path.)
--
Steve Arbaugh
ACG Soft
http://ourworld.compuserve.com/homepages/attac-cg

Darrin said:
I had a previous post on this same topic. I have a data base that I have
Click to expand...
one hyperlink field in each record that is set according to the field [sq] I
am trying to open the link in a report. The link goes to the folder
(doorpics) on my C: drive. The only thing in each file is a JPG. I have
previously seen this done but I can not remember how to do it.
I am trying to insert the contents of each hyperlink into the report. I
Click to expand...
have 186 individual reports that have to be manually updated DUE TO THE
DIFFERENT JPG's then printed. If I can get the hyperlink to open in the
report then it will save about 12 hours worth of work. For example the
report for 607_COS will already display the hyperlink to 607_COS.jpg but how
can I make it open the JPG in the report?
 
I tried this and it works! Thank you. I was trying to print hyperlinked Photos into a report and have the image print. It's amazing how hard this is! I must conced that it is a LOT easier than it was five years ago when I first started down this slippery slope!
 
Back
Top