display image on form

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
 
J

jjrmy1

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!
 

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Top