Results 1 to 6 of 6
  1. #1
    PsYc0TiC is offline Advanced Beginner
    Windows 7 32bit Access 2010 32bit
    Join Date
    Aug 2016
    Posts
    35

    Question Attachments in report issue

    First post (I think)



    I have a db with a bunch of records... there is an attachment field in the data table. Only images are attached to these records.

    I created a query to display the attachments in a report. I grouped the results by record ID.

    Here is where the problem starts. When the report is displayed, if there are more than one image attachments in the record (lets say there are 5), the report will display all five but the image that is displayed will be the first image only 5 times. Even though all the other information pertaining to each picture is correct... it doesn't show all 5 images.

    What the report looks like... as you can see... record 184 has 4 attached images with unique file names but the image from the first one just repeats.
    Click image for larger version. 

Name:	Capture1.JPG 
Views:	12 
Size:	65.9 KB 
ID:	28514

    Here is the query in case it means anything. (some of the items in the query aren't shown in the screenshot of the report above)
    Click image for larger version. 

Name:	Capture2.JPG 
Views:	12 
Size:	38.0 KB 
ID:	28515

    Any idea why it doesn't show each attached image to go with each filename?

  2. #2
    jwhite is offline Competent Performer
    Windows 10 Access 2013 32bit
    Join Date
    Dec 2012
    Location
    North Carolina
    Posts
    349

  3. #3
    PsYc0TiC is offline Advanced Beginner
    Windows 7 32bit Access 2010 32bit
    Join Date
    Aug 2016
    Posts
    35
    Isn't that exactly what I did? I could be missing something. The only difference I see in what was done on that page was they used a continuous form rather than a report.

    BTW... I tried the continuous form and it did the same thing that is happening on my report.

  4. #4
    jwhite is offline Competent Performer
    Windows 10 Access 2013 32bit
    Join Date
    Dec 2012
    Location
    North Carolina
    Posts
    349
    Never used (and never will use) Attachment fields so not for sure, but I did notice in the link the inclusion of image, image.FileData, image.FileName, and image.FileType, whereas yours includes only VisAtt.FileName. If you can post a version of your DB with just enough to replicate the issue, I'll have a look at it directly.

  5. #5
    PsYc0TiC is offline Advanced Beginner
    Windows 7 64bit Access 2013 64bit
    Join Date
    Aug 2016
    Posts
    35
    I tried adding in the VisAtt.FileData like on the link but it just returned an empty column. That and file type are the only things I did not use

    I cant attach my db because it is too big even without most of the data

    Click image for larger version. 

Name:	Capture3.JPG 
Views:	11 
Size:	41.5 KB 
ID:	28521

  6. #6
    PsYc0TiC is offline Advanced Beginner
    Windows 7 64bit Access 2013 64bit
    Join Date
    Aug 2016
    Posts
    35
    Fixed it!

    In the query, I REPLACED the VisAtt (same as the "image" field in the example on the link)field with the VisAtt.FileData field and it works now. However... the images are no longer clickable in the report to open the dialog box to view the images.

    I don't guess that is a big issue.

Please reply to this thread with any new information or opinions.

Similar Threads

  1. Export Report with attachments
    By benjamin.m.winchester in forum Reports
    Replies: 3
    Last Post: 12-17-2015, 01:13 PM
  2. How do I work as a report in the attachments
    By azhar2006 in forum Access
    Replies: 2
    Last Post: 04-06-2012, 03:09 AM
  3. Display every attachments in report?
    By mitchel in forum Reports
    Replies: 7
    Last Post: 02-11-2012, 07:53 PM
  4. Emailing Report with Attachments
    By Rookie in forum Reports
    Replies: 1
    Last Post: 08-19-2011, 06:52 PM
  5. Attachments in Report
    By Meccer in forum Reports
    Replies: 1
    Last Post: 04-15-2011, 01:37 PM

Posting Permissions

  • You may not post new threads
  • You may not post replies
  • You may not post attachments
  • You may not edit your posts
  •  
Other Forums: Microsoft Office Forums