Tek-Tips is the largest IT community on the Internet today!

Members share and learn making Tek-Tips Forums the best source of peer-reviewed technical information on the Internet!

  • Congratulations Mike Lewis on being selected by the Tek-Tips community for having the most helpful posts in the forums last week. Way to Go!

Using database record as a hyperlink. 1

Status
Not open for further replies.

bcicsuci

MIS
Jun 28, 2002
9
US

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
 
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...
 
Is this done in a repeat region?

What I do is something like this.
Code:
<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)
 
Status
Not open for further replies.

Part and Inventory Search

Sponsor

Back
Top