Links on an INFORM

[devesa]

Dear colleagues,

On a field in an INFORM I have this expresion:
="VIDEOS\2008_09\" & [CATEGORIAS.Nombre] & "\" & [Id Partido] & ".mpg"

So that for each row I get something like:
VIDEOS\2008_09\EBA\1176.mpg

But it doesn't work as link. It appears in blue underlined, but when I try to click nothing happens... "Is link" option is marked as YES.

Could anyone help me? Thanks!

 

[Uncle Gizmo]

I think it should look something like this:

file://D:\MyFolder\MyDoc.doc

 

[jwhite]

What is an "INFORM" ? I'm assuming an Access form. In addition to Gizmo's suggestion, you can also use FollowHyperlink (see Access Help) which would take a regular {Drive}{Path}{filename} combination and load the document with the associated application. Another method that is more versatile is API: Start an app with ShellExecute

 

[devesa]

Thanks for your replies!

With "Inform" I meant "report" (sorry for my awful English). I tried your suggestions but it seems it doesn't work. I have on the report what it seems to be an hyperlink, but when I try to click on it, nothing happens (not even an error).

But something interesting. If I create a field in a table with the hyperlink \MYFOLDER\myfile1.doc
\MYFOLDER\myfile2.doc
\MYFOLDER\myfile3.doc

And get the report of this field, it works when I click on it.

More ideas?

 

[jwhite]

Report Controls don't have OnClick events like forms, so what you seek cannot happen. It will have to be a form as a 'report' to get that feature.

 

[devesa]

Re: Links on an REPORT

Thanks friend,

But then I cannot understand why it works when I fill by hand a field like that:
\MYFOLDER\myfile1.doc
\MYFOLDER\myfile2.doc
\MYFOLDER\myfile3.doc

And show it on a report. It works, I can click on it and it gets opened.

But if I create a report expression to generate the path to exactly the same:
="\MYFOLDER\myfile" & [Id] & ".doc"

I cannot click on it. THANKS again.