Pictures in Database ?

  • Thread starter Thread starter Ty
  • Start date Start date
T

Ty

Does anyone have suggestions on pictures in the database?

I have a friend who wants to have 2 pictures in her
database for each record. This has been done as OLE and
she right clicks on the field and insert object, ....

The picture does into field 1 then the next pictures goes
into field 2. This works, but I have noticied the
database is getting large fast and I don't know if this
will cause issues in the future.

The reports that she runs needs to print out the pictures.

Any ideas, suggestions, opinions, etc. are very welcome.

Thanks.

Ty
 
Use the Image Control instead of an Object Frame control.
If your pictures are all the same dimensions, use a sample
picture to size the frame around it. If your pictures are
of different dimensions, make your frame square and set
the Picture Alignment property to "top left". In this
case, there will be a certain amount of dead space at the
bottom or right depending upon the dimensions of each
picture. Then set the following properties of the Image
control:
Picture - "(none)"
SizeMode - Zoom
Picture Type - Embedded
Picture Alignment - [see above]
Picture Tiling - No

Depending upon the coding, the table will have a text
field (not an OLE field) that holds the file name or
complete path to each picture. Check the Northwind sample
database for version 2002, where they have switched to the
Image control in their Employees form.
 
Back
Top