Access DB Results as Link 1

[dburnham]

I am using an access DB to display a list of web sites. I would like for the sites to appear as active links, however, the actual link shows as a subdirectory to the site that I created as in

http://www.mysite.com/pagefolder/www.linkedpage.com

This cause the browser to return an error.

I have chosen both options in the Database Colum Value (Column Value Contains HTML and Display as Hyperlink. I have also tried saving the DB column as both text and a hyperlink.

Any and all help is appreciated.
David

 

[Noconi]

If you want the result to display as a hyperlink, the value in the column needs to include the http:// as opposed to the value being

http://www.sitedomain.com

Another way to do this is to have 2 different fields, one being the web site title and the other being the URL of the website. Then you would have the list display the website title and hyperlink the website title - click the parameters button in the hyperlink dialog box and have the hyperlink URL set to the value of the URL field for that record.

HTH
Tiffany

Microsoft MVP - FrontPage

http://www.at-frontpage.com

http://www.anyfrontpage.com

http://www.frontpage-webtemplates.com

 

[dburnham]

Thanks, I have the site working as instructed by adding the http:// to the record set. However, I like the sound of the second option better.
How would I set the hyperlink property to recognize the rs value?

David

 

[Noconi]

Here is a tutorial I have on my site for doing the hyperlinks using database column values:

http://www.at-frontpage.com/2000/drwlinks.htm

Also note the link to spiderwebwoman.com site at the bottom of the tutorial. It is a great site for DRW tips and tutorials.

Tiffany

Microsoft MVP - FrontPage

http://www.at-frontpage.com

http://www.anyfrontpage.com

http://www.frontpage-webtemplates.com

 

[dburnham]

Thank you!! I love your tutorials.

David