two to three Pictures in PDF while exporting

%3CLINGO-SUB%20id%3D%22lingo-sub-2380230%22%20slang%3D%22en-US%22%3Etwo%20to%20three%20Pictures%20in%20PDF%20while%20exporting%3C%2FLINGO-SUB%3E%3CLINGO-BODY%20id%3D%22lingo-body-2380230%22%20slang%3D%22en-US%22%3E%3CP%3EHi%2C%3C%2FP%3E%3CP%3E%26nbsp%3B%3C%2FP%3E%3CP%3EI%20am%20new%20to%20Microsoft%20access%20database.%20I%20have%20a%20share%20point%20list%20and%20this%20is%20accessed%20with%20Microsoft%20Access.%20In%20Design%20Form%2C%20I%20had%20added%20Attachment%20as%20Pictures%2C%20but%20only%20one%20picture%20appears%20while%20the%20list%20has%20multiple%20pictures.%3C%2FP%3E%3CP%3EHow%20could%20I%20view%20multiple%20pictures%20in%20the%20design%20form%2C%20so%20that%20while%20I%20print%20it%20%2C%20I%20can%20view%20all%20the%20pictures%20associated%20with%20the%20particular%20comment.%3C%2FP%3E%3CP%3E%26nbsp%3B%3C%2FP%3E%3CP%3E%26nbsp%3B%3C%2FP%3E%3CP%3E%3CSPAN%20class%3D%22lia-inline-image-display-wrapper%20lia-image-align-inline%22%20image-alt%3D%22Access%20Database%20Issues.jpg%22%20style%3D%22width%3A%20999px%3B%22%3E%3CIMG%20src%3D%22https%3A%2F%2Ftechcommunity.microsoft.com%2Ft5%2Fimage%2Fserverpage%2Fimage-id%2F283081iE1DA7CFB9111AA70%2Fimage-size%2Flarge%3Fv%3Dv2%26amp%3Bpx%3D999%22%20role%3D%22button%22%20title%3D%22Access%20Database%20Issues.jpg%22%20alt%3D%22Access%20Database%20Issues.jpg%22%20%2F%3E%3C%2FSPAN%3E%3C%2FP%3E%3C%2FLINGO-BODY%3E%3CLINGO-LABS%20id%3D%22lingo-labs-2380230%22%20slang%3D%22en-US%22%3E%3CLINGO-LABEL%3EAccess%3C%2FLINGO-LABEL%3E%3C%2FLINGO-LABS%3E%3CLINGO-SUB%20id%3D%22lingo-sub-2380390%22%20slang%3D%22en-US%22%3ERe%3A%20two%20to%20three%20Pictures%20in%20PDF%20while%20exporting%3C%2FLINGO-SUB%3E%3CLINGO-BODY%20id%3D%22lingo-body-2380390%22%20slang%3D%22en-US%22%3E%3CP%3E%3CA%20href%3D%22https%3A%2F%2Ftechcommunity.microsoft.com%2Ft5%2Fuser%2Fviewprofilepage%2Fuser-id%2F795969%22%20target%3D%22_blank%22%3E%40sanjurk%3C%2FA%3E%26nbsp%3B%3C%2FP%3E%3CP%3EI'm%20not%20completely%20clear%20about%20what%20you%20are%20trying%20to%20do%20here%20or%20about%20the%20relevance%20of%20Sharepoint%20or%20exporting%20to%20PDF.%20Most%20developers%20will%20tell%20you%20to%20avoid%20attachment%20fields%20in%20Access%20as%20they%20cause%20file%20bloat%20and%20will%20affect%20performance.%20A%20far%20better%20approach%20is%20to%20save%20the%20images%20externally%20and%20only%20store%20the%20file%20paths%20in%20Access%20as%20text%20fields.%20You%20can%20still%20view%20the%20images%20in%20Access%20forms%20and%20reports.%3CBR%20%2F%3EIn%20case%20it%20helps%2C%20have%20a%20look%20at%20my%20folder%20image%20viewer%20app%20which%20demonstrates%20three%20methods%20of%20displaying%20images%20in%20forms%20together%20with%20a%20report%3C%2FP%3E%3CP%3ESee.%26nbsp%3B%3CA%20title%3D%22Folder%20Image%20Viewer%22%20href%3D%22http%3A%2F%2Fwww.mendipdatasystems.co.uk%2Ffolder-image-viewer%2F4594429467%22%20target%3D%22_self%22%20rel%3D%22nofollow%20noopener%20noreferrer%22%3Ehttp%3A%2F%2Fwww.mendipdatasystems.co.uk%2Ffolder-image-viewer%2F4594429467%3C%2FA%3E%26nbsp%3B%3C%2FP%3E%3CP%3E%26nbsp%3B%3C%2FP%3E%3C%2FLINGO-BODY%3E%3CLINGO-SUB%20id%3D%22lingo-sub-2380502%22%20slang%3D%22en-US%22%3ERe%3A%20two%20to%20three%20Pictures%20in%20PDF%20while%20exporting%3C%2FLINGO-SUB%3E%3CLINGO-BODY%20id%3D%22lingo-body-2380502%22%20slang%3D%22en-US%22%3EThis%20is%20a%20snag%20report%20or%20a%20condition%20report%20of%20an%20asset%2C%20and%20we%20need%20a%20detailed%20report%20with%20pictures%20for%20each%20snag%20and%20comment.%20The%20snag%20has%20multiple%20photos%20to%20let%20you%20know%20on%20the%20condition%20of%20the%20asset.%20I%20have%20to%20then%20convert%20it%20to%20a%20PDF%20document%20with%20photos%20so%20that%20the%20client%20gets%20to%20know%20the%20condition%20of%20his%20asset.%20Is%20there%20any%20way%20round%20to%20attach%20multiple%20photos%3C%2FLINGO-BODY%3E
Occasional Contributor

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.

 

 

Access Database Issues.jpg

5 Replies

@sanjurk 

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 

 

This is a snag report or a condition report of an asset, and we need a detailed report with pictures for each snag and comment. The snag has multiple photos to let you know on the condition of the asset. I have to then convert it to a PDF document with photos so that the client gets to know the condition of his asset. Is there any way round to attach multiple photos
First of all, did you look at my example database and, if so, did it help?

If I recall correctly, you can cycle through the images attached to a record but only displaying one at a time. However, I haven't used attachment fields since around 2008 so may not be best placed to advise on what is possible. The last time I worked with them was when a client asked me to sort out a mess they had created using them. As they had anything up to 16 images per record, they created a non-normalised table with 16 attachment fields and put one image in each. It worked .but was a very BAD solution. They finally realised their mistake when a new record needed even more than 16 images.

I recommend you scrap the attachment field and store the image paths in a separate table tblAssetPaths with a one to many join to your tblAssets. You can definitely make that work
Thanks for your reply. The images that I will need is max to 3 pictures.

I looked up your webpage, but what I need is displaying multiple images horizontally in the report that I want to print.

@sanjurk 

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:

Capture.PNG