Can a thumbnail image be inserted on a form? how?

Thread view:

Enable EMail Alerts

Start New Thread

Thread rating:

Dennis - 12 Sep 2007 22:46 GMT

I would like to have a thumbnail of an image that is linked to the record
that is showing on a form. If this is possible how can this be done and is
there a wide variety of formats that can be used for the image?

Reply to this Message

Daniel - 13 Sep 2007 13:12 GMT

First off, do not ever embed your images within the database. Only add the
path into the db. This will avoid major db bloating issues.

Now to answer your question. Your question is the same as create a photo
album with access. By associating an image path to a record your simply
display the image using the current form event. There are numerous good
example of how to do this. Here are a few to take inspiration from.

http://www.cardaconsultants.com/en/msaccess.php?lang=en&id=0000000007#images
http://www.cardaconsultants.com/en/msaccess.php?lang=en&id=0000000007#album
http://www.rogersaccesslibrary.com/download3.asp?SampleName=Pictures.mdb

Signature

Hope this helps,

Daniel P

> I would like to have a thumbnail of an image that is linked to the record
> that is showing on a form. If this is possible how can this be done and is
> there a wide variety of formats that can be used for the image?

Reply to this Message

Dennis - 13 Sep 2007 14:10 GMT

thanks, however, the images are not photos, persay, they are drawings drawen
with a cadd program and i would like to try to get the image of the drawing
to appear on a form when the drawing information is selected.
if this is not possible, that is ok, i am just curious if it is possible.

> First off, do not ever embed your images within the database. Only add the
> path into the db. This will avoid major db bloating issues.
[quoted text clipped - 11 lines]
> > that is showing on a form. If this is possible how can this be done and is
> > there a wide variety of formats that can be used for the image?

Reply to this Message

Arvin Meyer [MVP] - 13 Sep 2007 15:58 GMT

Put the thumbnails in a folder and use the path. Also store the path to the
autocad drawing. Here's how to store them and use them:

http://www.datastrat.com/Download/Picture2K.zip

then by double-clicking the image of the thumbnail, use ShellExecute op open
AutoCAD to the drawing:

http://www.mvps.org/access/api/api0018.htm

Signature

Arvin Meyer, MCP, MVP
http://www.datastrat.com
http://www.mvps.org/access
http://www.accessmvp.com

> thanks, however, the images are not photos, persay, they are drawings
> drawen
[quoted text clipped - 21 lines]
>> > is
>> > there a wide variety of formats that can be used for the image?

Reply to this Message