How to creat thumbnails of jpg images in MS-Access database

[Timo]

Hi there,

This is my first time here,.....I am a Perl developer by trade but
currently working on Access database.

Anyway,...I use this artical from Microsoft knowldge base number
(285820) to creat a database that contains few .jpg images.

My question is; how can I create a thumbnail imges for those jpg images
and, if how can I get the the original jpg image to be displayed once I
click on the thumbnail?

Thanks for yoyr help.
Tim

[Rich P]

You can use an image control(s) then use the width and height
propertie(s) of your control(s). Make sure that the size mode property
of the image contorl (in the property sheet of the image control) is set
to zoom for this to work (because you are zooming in and out).

Private Sub Image11_Click()
Static i As Integer
If i Then
Image11.Width = 7920
Image11.Height = 6360
Else
Image11.Width = 2220
Image11.Height = 2040
End If
i = Not i
End Sub

Note: in the property sheet of the image control the sizes are in
inches. In programming you have to use twips - 1440 twips per inch.
The above is in twips. You could have a bunch of image controls placed
together like a table.

Rich

*** Sent via Developersdex http://www.developersdex.com ***