display image on form

  • Thread starter Thread starter jjrmy1
  • Start date Start date
J

jjrmy1

I have an access form which basically displays a table in a nice format 1
record at a time and allows you to navigate thru the records and change data
in certain fields. I need to let the users see a picture so that they can
understand what item the record is for. All of the pictures are hosted
remotely and are named according to the model field. For example model field
on the form is ABC1234 and the picture is ABC1234.jpg. I've tried using the
Microsoft Web Browser Control but can't get it to navigate right. link would
look like "http://www.mysite.com/images/" & [model] & ".jpg".

Any help or suggestions would be much appreciated, I've been hackin away at
this all day.
I am an access newbie and have no idea what I'd put here:
Option Compare Database

Private Sub WebBrowser0_Updated(Code As Integer)

End Sub


Thanks in advance
 
Here's the solution for those interested:
Click on "more controls > microsoft web browser control"
add it to your form
right click on it and go to properties and name it (in this case
webbrowser9)
go to "view > code" and paste this:

Option Compare Database

Private Sub Form_Current()
WebBrowser9.Navigate ("http://www.YOURWEBSITE.com/images/" & [model]
& ".jpg")
End Sub
_______________________________
replace "model" with your field name that corresponds to your images.

Hope this helps someone
Cheers!
 
Back
Top