Picture Hotspot Link to Access DB

[Tim Dyeson]

I would like to create a hotspot link on a picture that, when clicked,
queries an Access database. I see the parameters option in the "edit
hyperlink" dialoge box, but I don't know how to write the string in the
name/value menu. Any suggestions would be much appreciated.

 

[Stefan B Rusynko]

In your page write before the image your SQL code to open the DB and get your URL from the DB as say
<%
' SQL DB code here for the link recordset objRS ..
hotlink=objRS("linkfieldname")
%>

Then create your hot spot link to anything existing page
- and in code view edit the links in the area tag to be say:
<area href="<%=hotlink%>" ...>
--

_____________________________________________
SBR @ ENJOY (-: [ Microsoft MVP - FrontPage ]
"Warning - Using the F1 Key will not break anything!" (-;
_____________________________________________


|I would like to create a hotspot link on a picture that, when clicked,
| queries an Access database. I see the parameters option in the "edit
| hyperlink" dialoge box, but I don't know how to write the string in the
| name/value menu. Any suggestions would be much appreciated.