Solved

Pictures in a sub-report

Posted on 2014-09-10
2
215 Views
Last Modified: 2014-09-15
I have two tables... main table and sub table.  In the sub table I have an attachment field.  In the attachment field I have 8 jpg files.

Then I have two forms.  A main form and a sub-form.  The main form has a record ID as does the subform.  This record ID field is the link between the main form and the subform.

In the subreport detail section I have an "image block".  The control source of the image block is "Picture" which is a field in the sub table.

But when I do a print preview of the main report I get the first picture over and over again... 8 times instead of each picture one time.

What am I doing wrong?
0
Comment
Question by:SteveL13
2 Comments
 

Author Comment

by:SteveL13
ID: 40315770
I just reduced the number of pictures to 4 to reduce the file size.  Please see attached.
Picture-Test-2.accdb
0
 
LVL 29

Accepted Solution

by:
IrogSinta earned 500 total points
ID: 40316097
Create a query from your table and use the query instead as the recordsource of your report.  For instance, create a query called qryDetail by adding the fields from the tblDetail table.  If you run the query you'll notice that you have multiple records this time (one for each attachement).  Then change the Recordsource of your subreport to qryDetail and voila, you can see your pictures.  Here's what your query should look like:
qryDetailRon
0

Featured Post

Free Tool: Site Down Detector

Helpful to verify reports of your own downtime, or to double check a downed website you are trying to access.

One of a set of tools we are providing to everyone as a way of saying thank you for being a part of the community.

Question has a verified solution.

If you are experiencing a similar issue, please ask a related question

In a multiple monitor setup, if you don't want to use AutoCenter to position your popup forms, you have a problem: where will they appear?  Sometimes you may have an additional problem: where the devil did they go?  If you last had a popup form open…
AutoNumbers should increment automatically, without duplicates.  But sometimes something goes wrong, and the next AutoNumber value is a duplicate.  This article shows how to recover from this problem.
In Microsoft Access, learn different ways of passing a string value within a string argument. Also learn what a “Type Mis-match” error is about.
Polish reports in Access so they look terrific. Take yourself to another level. Equations, Back Color, Alternate Back Color. Write easy VBA Code. Tighten space to use less pages. Launch report from a menu, considering criteria only when it is filled…

685 members asked questions and received personalized solutions in the past 7 days.

Join the community of 500,000 technology professionals and ask your questions.

Join & Ask a Question