Inserting Pictures

  • Thread starter Thread starter Chris Roche
  • Start date Start date
C

Chris Roche

Hello,

I have created a form however I want to have the ability
to insert pictures from my local file in the form view
when the user is entering the information. For example one
record is a description of a broken control panel, the
form lists the Material Description, serial number and
other things. Within the "Description of Problem" text box
I have a writen description of the problem. I want to be
able to add pictures of the broken box itself, to aid in
description. Do I need a separate box or can I just add it
into the same box. I may need more than one pic per
record, and each record would be different. Also I want
the pictures to show up on the accompanying report as well.

Thank you for any help you can provide,
Chris
 
Storing pictures in Access is not a good idea. Pictures can be added as an
OLE object data type. However, the amount of disk space required to store
the picture will be about double the files size. A 1MB picture will make
your database 2 MB larger. If you don't have many pcitures this might not
be a problem, but from your description it looks like you will have lots of
pics. The best solution would be to store the filename, including the path,
in a text field. Then you can use this information to set the source for an
unbound picture field to the picture. This will involve some VBA coding,
but it is not too complicated. If you want multiple pictures per record, I
would suggest using a subform linked to a seperate table with just the
filenames of the pictures.

Kelvin
 
Back
Top