Working with Images

[quixote]

I'm wondering what the best way is to work with/show/store
images? I've played around with a few things but can't get
my head around it. Let's say I would like to store an
image of each client. When I retrieve this clients
information via a form/report I would like for the picture
to display on the form along with the other information.
Also I would like to take into consideration for another
user to Add a new image for an existing or new client
also...ergo I would like to make it user friendly.

Thanks,
quixote

 

[Jack]

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.

 

[Paul Falla]

Dear Quixote
You will be glad to hear that what you wish to do is
relatively simple. In the table that holds the clien
information, include a field to hold the picture. The
field type will need to be OLE. When you are designing
your form size the field appropriately. If a user needs to
add/change a photo, the easiest way to do so is to double
click on the field with the photo. There is a little bit
more to it than I have described here, but this should get
you up and running.

Kind regards

Paul