Frontpage 2000 & Access Databases

[chrisinoshkosh]

I've just started designing our intranet site using Frontpage 2000. The problem is I need to integrate some databases. I have them integrated but now I need to know more about frontpage and access databases. I can pull up tables from the database and show them via .asp pages. Is there any way to have FP automatically create hyperlinks to other pages from that database results page? What I mean is that the main results page is pretty much a summary. If I have the price code PP I would like to have FP automatically link to a page called pp.html or something like that. Is there any way to do that with FP? Thanks. Also, if you have any sites that would be helpful in this area please let me know!

 

[jbento]

I just asked a similar question. I hope someone on here knows the answer for us.

Jerome

 

[sheeyah]

Using FrontPage's Database Results Wizard to create hyperlinks in a database:

In Normal View, right-click on the field, select Hyperlink | Parameters

Click in the Path box (where you see http:// ), the Insert Field value button is now available to use.

Click on it and all the fieldnames in your database will drop down from that button.

Choose the field with the URL in it and code like this:

http://<%=FP_FieldLink(fp_rs,&quot;WebSite&quot;)%>

will appear in the box.

Click Ok, and then OK again.

Save the page, and Preview in Browser.

This is the best I can do - hope it helps.
I got this from an expert:

http://www.spiderwebwoman.com/resources/dbrwtipsandtricks.asp

 

[sheeyah]

http://support.microsoft.com/support/kb/articles/Q205/9/80.ASP?LNG=ENG&SA=ALLKB&FR=0

This might help you too.

Good luck )

 

[sareteam]

I did this once using access. I had a huge table but I only wanted to show selected fields. And this is the part I hope helps, I wanted some of the fields to hyperlink. The fields were house pics (I'm in real estate) Anyway, I did a make-table query. In my query I concatenated my results - I added text to the result. Here is my query include all quotes;

&quot;<a href=&quot;&quot;&quot;

http://web.com/folder/&quot;&data&&quot;&quot;&quot;&quot;

(Three quotes generates an actual text quote (&quot.)

When you make your results page right click on the column which will have the html and choose &quot;Database Column Value Properties&quot; and check the &quot;Column value contains html.)