microsoft access courses - Access - photos

Hi Connie

Essentially you need to use the OLE Object field to store an image in a table. To insert an image, go to the datasheet view, and right click on the field you want to add the image to.
Then choose INSERT OBJECT.

You have two choices:

Either

Insert the actual image into the table (CREATE NEW)

OR

Create a new object from a file (FROM FILE).
With this option you have a choice to LINK to the file, rather than insert it. So if the image changes, it will updated.


Once you have those steps in place you would need to add the OLE Field to the form.


For a full description of how this all fits together, have a read through these to articles from Microsoft.


http://office.microsoft.com/en-us/access/HA011472041033.aspx #DispImgWinOrForm

http://office.microsoft.com/en-us/access/HA011472041033.aspx #DispImg



Regards

Richard