Forum home » Delegate support and help forum » Microsoft Access Training and help » microsoft training access course - Adding Pictures to access table
|
|
|
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 training access course - Adding Pictures to access table
Resolved · Low Priority · Version Standard
Reply Fri 5 Oct 2007, 15:45Delegate Tony said...
Tony has attended:
Access Consulting course
Adding Pictures to access table
Please advise how to add photos to records in a table and does the photo file have to be a specific type ( E.G product photos)???
For upcoming training course dates see: Pricing & availability
RE: Adding Pictures to access table
Hi Tony
I repeated what we did in the training on my PC and it gave me no problems. Use JPG pictures for this. I used photos I had taken with my digital camera. Try to keep the picture size down. (GIF and BMP don't work too well)
So to add a picture to a database use the following steps:
1. In the design view add a field named Picture with an OLE Object type.
2. In the Datasheet view Select the Picture cell and insert Object
3. I the Object dialog box, Select Create from file, Browse for the required picture and click OK.
To View the picture in the Form:
1. Create the form as normal
2. In design view right click the picture box and select Properties
3. In the Size Mode line Select Zoom (This ensures the picture resizes to the frame you created for it)
Hope this helps
Carlos
|
|