Access Table related uestion 1

[rossmcl]

At the moment, I bring in an access recordset. Is there anyway of having one of those columns as a hyperlink to another page. All rows would go to the same page, each row having a different 'Course' that I would like to take to the new page (and use in SQL)<br><br>Is there anyway I can take a field in the recordset as a variable to the new page?<br><br>Any help would me appreciated. (sorry if this is poorly explained.<br>Thanks<br>Ross

 

[NickBulka]

I'm not sure I understand your question completely.&nbsp;&nbsp;How is the value that you want to use as a hyperlink stored in the database? <p>nick bulka<br><a href=mailto: > </a><br><a href= > </a><br>

 

[rossmcl]

The Value that I want to use is stored as a text field in the table.<br>I was thinking I would have another field in which I would put this hyperlink to the new page (the same h/l for each record.)<br>Then depending on what record I click on the hyperlink, it would take that text field in and use it in teh new page (in SQL)

 

[NickBulka]

sorry, Ross.&nbsp;&nbsp;My question was not phrased clearly.&nbsp;&nbsp;What I'd like to see is a sample value from the field in question.&nbsp;&nbsp;I had already assumed it was text. <p>nick bulka<br><a href=mailto: > </a><br><a href= > </a><br>

 

[rossmcl]

Course CourseDate User UserEnteredDate Status<br>Advanced Powerpoint 25/05/00 09:00:00 rmclanac 08/06/00 BookedOn<br>Advanced Word 24/05/00 11:00:00 rmclanac 08/06/00 BookedOn<br>Advanced Outlook 25/05/00 15:00:00 rmclanac 08/06/00 BookedOn<br><br><br>I would add another column with a hyperlink to the page in question.<br>On clicking on this hyperlink, I would like the value from column1 (ie Course) to be taken over to the new page. EVEN THOUGH THIS IS NOT WHAT IT IS BEING CLICKED - it is another column in the same row that contains the hyperlink.<br><br>Thanks Nick<br><br>Ross

 

[NickBulka]

Ross,<br>&nbsp;&nbsp;&nbsp;&nbsp;Assuming that you have a column containing the url to the site for the course,&nbsp;&nbsp;when building your table, include the hyperlink in the first column of the table, using a combination of the Course field and Hyperlink field:<br><br>StringToDisplay = &quot;&lt;a href = '&quot; & rs(&quot;HyperLink&quot & &quot;?Course=&quot; & rs(Course) & &quot;'&gt;&quot; & rs(Course) & &quot;&lt;/a&gt;&quot;<br><br>response.write &quot;&lt;TD&gt;&quot; & StringToDisplay & &quot;&lt;/TD&gt;&quot;<br><br>Then,&nbsp;&nbsp;in the page referred to in the hyperlink,&nbsp;&nbsp;you can get the name of the course by referencing request.querystring(&quot;Course&quot<br><br><br><br><br>&nbsp;&nbsp;&nbsp; <p>nick bulka<br><a href=mailto: > </a><br><a href= > </a><br>