Create Better MS Access Reports
Report Builder for Microsoft Access helps you create dynamic, professional-looking reports fast! The easy-to-understand wizard helps you with complex tasks like calculated fields, adding subreports, customizing styles, as well as grouping and sorting. Download a free trial today!
While it's possible to actually store the images within the Microsoft Access database itself as OLE objects, normally it's not the preferred way. When you embed an OLE object in a table, you're storing a lot of overhead as well. This overhead is the information about the object (such as it's parent application) that Access needs to store in order to render the object properly.
The preferred way to display images is to store the complete path and filename to the actual files themselves within a table, and then use the Image tool (in Access 97/2000) to update the display.
The following example shows you how to display Windows bitmap images on a Microsoft Access report without storing the images in a Microsoft Access table.
c:\windows\circles.bmp c:\windows\waves.bmp c:\windows\tiles.bmp c:\windows\bubbles.bmp
Private Sub Detail_Format(Cancel As Integer, FormatCount As Integer) Me![Imageframe].Picture = Me![Imagepath] End Sub
Note: You may need to amend the file paths and image names to correspond with images stored on your system.
The method described above is similar to the actions required to include a bound image in a form. There is a further article related to this at: How to include a bound picture in a Microsoft Access form