Images in Access?

  • Thread starter ShaneDevenshire
  • Start date
S

ShaneDevenshire

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)
 
F

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)
Click to expand...

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]
 
J

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)
Click to expand...

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]
 
Top