Insert picture in access form

[josnghi]

I create table with 1 field OLE Object type (picture in Human resource management). I would like to create the form to enter picture into field OLE Object so that we can generate the report displayed the picture in each records. Could you please help me

[nick404]

If you want to display an image the best way to go about it is to not link it via a field in a table. Your database will become very bloated and suck up a lot more space that you think, even with just a few small .jpg's.

The best way is to keep the pictures on a local folder somewhere where everyone who uses the database can access (a shared drive if this is a company network or likewise). Then keep the filepath to the image stored in a field in one of your tables and set the SourceDoc property of an OLE object frame to that filepath.

Be aware though, that even though this is a better memory conservative option, I have had it where with very large images (using the latter method) I still get memory errors and issues.

I am not entirely sure on this so someone else may have to confirm/correct me.

[June7]

I would use Image control and set ControlSource property to text field that stores file path/name.

If you feel the db will stay small enough even with embedded images, then I suggest an Attachment field instead of OLEObject. I have not had good experience with OLEObject field and controls. An Image control bound to Attachment field will also dynamically display images.

What is the image format - jpg, bmp, png, tiff?

[josnghi]

Thanks nick404 for your help

[josnghi]

Thanks June7 for your idea. I will try to dp