Using database record as a hyperlink. 1

[bcicsuci]

I have an Access dbase with a column that contains the hyperlinks to reports. I can retrieve the values but I need to use the values as URL's to go where the reports are located. I currently have the links trying to go to the detail page. What is the solution for this?

Thanks.
bcicsuci

 

[GUJUm0deL]

I don't understand your problem...
You said that you need retrieve the values as URL's, but then you say you currently have the links going to the detail page. So what are you asking?? I have not failed; I merely found 100,000 different ways of not succeding...

 

[Cheech]

Is this done in a repeat region?

What I do is something like this.

<A href=&quot;<%=(Recordset1.Fields.Item('YourDBColumn').Value)%>&quot;><%=(Recordset1.Fields.Item('YourFileName').Value)%></a>

I put this as a link in the relevant table cell.

Cheech The secret of life is honesty and fair dealing. If you can fake that, you've got it made.
Groucho Marx (1895-1977)

 

[230173]

http://www.webthang.co.uk/tutorials/dwmx_files/dwmx1/mxfiles1_6.htm