Images in Access?

[Guest]

Hi folks,

If I want images in a form, there are a lot of these images. Does this get
stored in Access or can I use a pointer to keep the file size smaller.
(Access 2003)

 

[fredg]

Hi folks,

If I want images in a form, there are a lot of these images. Does this get
stored in Access or can I use a pointer to keep the file size smaller.
(Access 2003)

If all of the pictures are stored in the same folder, then store just
the name of the picture in a table field, i.e. "Mt. McKinley.jpg"

If the pictures are stored in different folders, then store the path
to the image and the image name in a field in a table, i.e.
"C:\\PictureFolderName\Mt.Mckinley.jpg"

Assuming the field is included in the form's record source, add an
Image control to the form.

Code the form's Current event:

If pictures are stored in the same folder...
Me.ImageName.Picture ="C:\\PictureFolderName\" & Me.[PictureName]

If the pictures are stored in different folders..
Me.ImageName.Picture = Me.[PathToFolder] & "\" & Me.[PictureName]

 

[John W. Vinson]

Hi folks,

If I want images in a form, there are a lot of these images. Does this get
stored in Access or can I use a pointer to keep the file size smaller.
(Access 2003)

Use a pointer. A2007 is much improved, but 2003 and all earlier versions store
image data VERY inefficiently.

I'd store the filename and path to an external .jpg or other image file, and
set the Picture property of an image control on the form in some appropriate
event.

John W. Vinson [MVP]