Hyperlink in report

[edonahue]

I'm trying to create a report that, for each record, links to a different scanned image. The file name for each image is stored in the table with the document number and other info. I created a query, concatenated the fields that contain the path and filename and, for that field on the report, turned the hyperlink property on. This made the field "hot", but it does not go to the file, it only goes to the directory that the report is output to. The only successful way I could put a hyperlink in that works is to use the Insert Hyperlink menu option which forces you to select a specific file.

Does anyone know how I can use the data in the table to point to a different file for each record?

Thanks,

Erika

 

[owenh]

Hyperlinks in Reports

I have been wondering the same thing, except that I have created a simple directory with email addresses and websites as well as a person's name in each record. I have created a macro to export the report to HTML. I would like to be able to click on the email address and expect this link: "mailto:[EmailAddress]" and click on the name and get "[Website]". It seems to be impossible to use fields in hyperlinks, but I'm sure there is a way to do it.

Thanks, Owen

 

[owenh]

edonahue,

I have had the same problem. I concatenated a "Name" field with a "Website" field in a query, ending up with
Joe Smith#http://www.joesmith.com/joe/#
However, when the "Website" field was empty, the query returned
Joe Smith##
Only when this happened did the exported HTML files link to the directory of the pages. Otherwise the links worked properly.

I'm not great with Access, and am going to attempt to throw in an if statement or something in the query so it will return
Joe Smith
when the "Website" field is empty. Hopefully then I can coax the report into changing the format back to simple text without the hyperlink.

Hopefully this will help you a bit...?

owenh