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 gkittelson on being selected by the Tek-Tips community for having the most helpful posts in the forums last week. Way to Go!

How can I in Access have a Field with HTML code to display a picture?

Status
Not open for further replies.

ottagolater

Vendor
Oct 26, 2002
4
US
In a field,in Access database, can I add HTML code that is an address to a picture and a hyperlink attached to the picture send the database to the web as a .asp file and when the web page is displayed. The field will show the picture and the hyperlink on the picture.

I have the database set up with a DSN-Less connection. But I can't get pictures to be displayed. Just hyperlinks. I rather have a thumbnail picture to be displayed and a hyperlink on the picture to display a larger view.

Any suggestion?
Joe
 
In the database field put the URL to the picture and in another field put the hyperlink
Then create the HTML code on your ASP page. I use it like this
<A href=&quot;<%=rs(&quot;URL_Link&quot;)%>&quot; target=&quot;_blank&quot;>
<IMG SRC=&quot;<%=rs(&quot;Image_Path&quot;)%>&quot; width=&quot;75&quot; height=&quot;65&quot; border=&quot;0&quot;>
</A> Saturday 12.00
im6.gif
im2.gif
im2.gif
20.00
im5.gif
im4.gif
im7.gif
3.00am
im8.gif
Sunday [img http
 
GaryC123,

You are a GENIUS !!! It worked.
I saw that I could change the border HTML code on the ASP page. But I never thought of adding the image html in the ASP page and putting the links in the access database. I was trying to put everything, all the HTML code in the access page then create the asp page.

Thanks very much
Joe
 
Status
Not open for further replies.

Part and Inventory Search

Sponsor

Back
Top