Adding a different Photo per employee record

[Beamarshall]

I'm new to Access so I don't know the terminology. I need to add a persons photo to their employee record and don't know where to start. Does anyone have any step by step notes on how to do this?



Thank you in advance

[ranman256]

The table must have a field you can call [photo] but the datatype is: OLE Object

Build a form (instant form button icon) for the employee record. It should show a box. Paste the picture in the box.

[burrina]

I would recommend that you store the pictures in a folder on your Hard Drive and link to it.
My 2 Cents!

[June7]

It is possible to embed images in an OLE or Attachment field. I've never had good experience with OLE field/controls.

Lots of large documents can use up Access file size limit fast. If the images are small png or jpg files and this is a small db, embedding images would be ok.

For dynamic display of images, I recommend using Image control bound to field or expression in ControlSource property. Depends on if the images are embedded or external files.

If embedded, just bind Image control to the Attachment field. Drag attachment field from the Field List to form or report in design view.

If images are external, need a field that has at least the image name. If each image is named with the EmployeeID, that field can serve. If all images are in same folder on central file server, the expression could be like:
="\\server name\path\" & [EmployeeID] & ".jpg"

[Beamarshall]

I can't seem to paste it's grayed out after I copy.

[June7]

Did you read post 4?

[Beamarshall]

Yes, but I'm not a programmer and I need step by step info. Sorry, I'm new to Access and don't understand a lot about it.

[June7]

There is no macro or VBA programming required in my suggestion. Only requires understanding of very basic Access functionality.

Exactly which item did you not understand?

How to name image file?

How to create field in table to store image name (or using the EmployeeID field) or to create an attachment type field?

How to build a form or report?

How to create a control by dragging field from field list?

How to type an expression in textbox ControlSource property?

[Beamarshall]

These two, sorry.

How to create field in table to store image name (or using the EmployeeID field) or to create an attachment type field?
How to type an expression in textbox ControlSource property?

[Beamarshall]

I did get it to show up in a report but I also want it to show up in each record when in Form view can I do that?

[June7]

Use Image control on form same as on report.

[Beamarshall]

Thank you so much, you have been a great help, thank you!!