Viewing Thumbnails in an Access Database question

W

White Knight

Is it possible to view thumbnail pics of jpeg files inside an Access
database? If so could some please explain to me how I should go about this.

Thanks in anticipation.

Joe
 
D

doco

Are you wanting to view a set of thumbnails or just one image at a time?

If you want to view one at a time you can embed an image control and set
it's .picture property to the path where the image is.

To make this dynamic and you have a list of paths in a data base you can
place this code in the FormName.Current() event

Private Sub Form_Current()
' This assumes you have a text box named path and an image control named
image

with me
if .path <> "" then
.image.picture = .path
else
' defalut image
.image.picture = "C:\Documents and Settings\doco\My Documents\My
Pictures\Blue Hills.jpg"
end if
end with

End Sub

or something like that. If you want multiple images I would like to know
how that is done as well. Possibly there is a third party ocx out there
somewhere?

HTH
doco
 
W

White Knight

doco said:
Are you wanting to view a set of thumbnails or just one image at a time?

If you want to view one at a time you can embed an image control and set
it's .picture property to the path where the image is.

To make this dynamic and you have a list of paths in a data base you can
place this code in the FormName.Current() event

Private Sub Form_Current()
' This assumes you have a text box named path and an image control
named image

with me
if .path <> "" then
.image.picture = .path
else
' defalut image
.image.picture = "C:\Documents and Settings\doco\My
Documents\My Pictures\Blue Hills.jpg"
end if
end with

End Sub

or something like that. If you want multiple images I would like to know
how that is done as well. Possibly there is a third party ocx out there
somewhere?

HTH
doco
Click to expand...

Thank you for your quick reply. I was thinking of being able to show a list
of thumbnails of the matched results query, but if I understand this
correctly, could your method not be used to show such a list if linked into
a macro that could auto the ".image.path = c:\..." required pathnames? Just
a thought, your comments welcomed.

Bottom posting would be preferable please, in case others wish to add to
this thread.

Thanks.

Joe
 
E

Exponent

White Knight said:
Thank you for your quick reply. I was thinking of being able to show a list
of thumbnails of the matched results query, but if I understand this
correctly, could your method not be used to show such a list if linked into
a macro that could auto the ".image.path = c:\..." required pathnames? Just
a thought, your comments welcomed.

Bottom posting would be preferable please, in case others wish to add to
this thread.

Thanks.

Joe
Click to expand...

You can, but you can't use 'continuous forms', because the relevant event is not fired for each record
(in order for you to load the image control).

An alternative is to design a form with a fixed layout of controls, eg a page of 10 results, like a search
engine.
The sample below illustrates this technique (using our own image control):
http://www.ammara.com/support/samples/showsam084d.html

If you are displaying thumbnails then you should ideally have a pre-prepared thumbnail image at the correct
resolution, rather than using the full-res image 'zoomed-out'. Otherwise, there may be a significant overhead
in disk, (network), memory and cpu usage in the retrieval, decoding, and display of the image. This can
hit performance in the front-end and back-end hard in larger systems, and the result is usually an image
with lower display quality than a pre-prepared thumbnail resampled to the correct resolution.
 
W

White Knight

Exponent said:
You can, but you can't use 'continuous forms', because the relevant event
is not fired for each record
(in order for you to load the image control).

An alternative is to design a form with a fixed layout of controls, eg a
page of 10 results, like a search
engine.
The sample below illustrates this technique (using our own image control):
http://www.ammara.com/support/samples/showsam084d.html

If you are displaying thumbnails then you should ideally have a
pre-prepared thumbnail image at the correct
resolution, rather than using the full-res image 'zoomed-out'. Otherwise,
there may be a significant overhead
in disk, (network), memory and cpu usage in the retrieval, decoding, and
display of the image. This can
hit performance in the front-end and back-end hard in larger systems, and
the result is usually an image
with lower display quality than a pre-prepared thumbnail resampled to the
correct resolution.

--
_______________________________________________________
http://www.ammara.com/
Image Handling Components, Samples, Solutions and Info
DBPix 2.0 - lossless jpeg rotation, EXIF, asynchronous
Click to expand...

Many thanks for your reply, this information has been passed onto a friend
(an astronomer) who is looking to be able display thumbnails of his many
astronomy pictures.

I will let you know the outcome of the information given in this thread when
he has had a chance to implement it. Again many thanks.

Joe
Joe
 
Top