Opening an image from hyperlink field in forms

  • Thread starter Thread starter Nick Transier
  • Start date Start date
N

Nick Transier

I am designing a database that keeps track of architectural diagrams. I have
a form which collects/displays all the information on the diagrams, but I
want to be able to show a preview of an image in the form. The actual link
to the image (html) is stored as a DB field in the table that the form
refers to. The image will be in a standard image format like JPEG and it
will be stored on a local server so that everyone on the project can use it.
I need to know

1) What type of object to use...image, unbound OLE, bound OLE, something
different
2) Examples of code that would open the image in the form drawing from the
DB field which has the hyperlink.

Thanks in advance-
Nick
 
Do not use an OLE Object type field to store these images inside the
database. That will very quickly bloat your database.

Use a Hyperlink type field, so you have a reference to the jpg file on the
server. Then use an image control on the form to display the picture when
you move record. The code to do that (including avoiding an important bug)
is at:
http://www.mvps.org/access/bugs/bugs0044.htm
 
Back
Top