Forum home » Delegate support and help forum » Microsoft Access Training and help » microsoft access courses - Access - photos
|
|
|
The UK's most regular Training information: See also: |
|
Welcome. Please choose your application (eg. Excel) and then post your question. Our Microsoft Qualified trainers will then respond within 24 hours (working days). Frequently Asked Questions
Any suggestions, questions or comments? Please post in the Improve the forum thread. |
microsoft access courses - Access - photos
Resolved · Low Priority · Version Standard
Reply Mon 9 Jul 2007, 15:59Delegate Connie said...
Connie has attended:
Access Introduction course
Access - photos
How do I insert a photo from a table into a Access form?
For upcoming training course dates see: Pricing & availability
RE: 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
|