I am having trouble with exporting images in reports inMicrosoft Access 2010. I am using MicrosoftSarepoint to link with access. End usersenter data in a SharePoint list which creates a table. Sharepoint can only import images through a “Attachments”field. End users routinely attach 3 or 4photos to an individual record.
I use Access 2010 to import the data from the SharePointlist, which appears as a simple table in Access. All images appear in an attachments field. Web databases in access are only allowed 1 attachments field that can contain multiple attachments (various photos in my case).
I want to create a report that can display images in the attachmentfield. Currently, Access in only pullingthe first image in the “attachments” field. When I add the attachment field multiple times in the same report record,it pulls the same photo. I need to knowhow to tell the attachment field to display different images in the report.
Can anyone help with this?
Thanks.