May 24 2021 01:59 AM
Hi,
I am new to Microsoft access database. I have a share point list and this is accessed with Microsoft Access. In Design Form, I had added Attachment as Pictures, but only one picture appears while the list has multiple pictures.
How could I view multiple pictures in the design form, so that while I print it , I can view all the pictures associated with the particular comment.
May 24 2021 03:00 AM
I'm not completely clear about what you are trying to do here or about the relevance of Sharepoint or exporting to PDF. Most developers will tell you to avoid attachment fields in Access as they cause file bloat and will affect performance. A far better approach is to save the images externally and only store the file paths in Access as text fields. You can still view the images in Access forms and reports.
In case it helps, have a look at my folder image viewer app which demonstrates three methods of displaying images in forms together with a report
See. http://www.mendipdatasystems.co.uk/folder-image-viewer/4594429467
May 24 2021 03:49 AM
May 24 2021 05:08 AM
May 24 2021 12:59 PM
May 24 2021 03:01 PM
That's easily done. Use multiple columns in your report. In your case probably 3columns
The report used in that sample app has 5 columns so it looks like this: