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)???
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