Picture Manipulation on Forms.

[JLeo]

Hi,
On my forms, it is required to display images of the site according to a field [SiteID]. Since the total file size of the images is far too big(>2GB)to store as an OLE object. I have adopted this to apporach


Private Sub Form_Current()
Me!Image1.picture = "C:\My Pictures\" & Me![SITEID] & "-1.jpg"

End Sub

However i do not know how to upon 'double-clicking' to open this thumbnail where i'm able to"
1.)view it as a blown up image as it was stored,
or
2.)be opened by an external program that can zoom in for details.

Anyone with any suggestion would be most appreceiated.

Cheers!

 

[Lightenup]

JLeo,

I've found OLEs to be difficult to work with if you want to be able to manipulate the photo. You could use it to initially display the photo.

I load the file path of each of my photos i.e., C:\Photos\SiteID\picture.jpg in a field with a picture description in another field. (I have a database with over 8000 photos.) The field (file path)is assigned as a hyperlink. The hyperlink appears in a text box on the form and when the user clicks on it, it opens the photo in a separate window using the default browser. This allows the user to make it whatever size they need and to save it down to their machine if necessary.


Hope this helps.
L

 

[JLeo]

Hi Lightenup,
Thanks for the reply, however i am unable to try this out yet as there's problem with the shared drive. WIll hhope to report the good news as soon as its up.