Solved

Pictures in a sub-report

Posted on 2014-09-10
2
208 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

U.S. Department of Agriculture and Acronis Access

With the new era of mobile computing, smartphones and tablets, wireless communications and cloud services, the USDA sought to take advantage of a mobilized workforce and the blurring lines between personal and corporate computing resources.

Question has a verified solution.

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

Suggested Solutions

Title # Comments Views Activity
Sending email from List Data 2 51
Access Runtime 2010 Error 17 32
DSum for Access 6 47
Set Query Column Heading parameters through VBA for CrossTab query 6 27
Most if not all databases provide tools to filter data; even simple mail-merge programs might offer basic filtering capabilities. This is so important that, although Access has many built-in features to help the user in this task, developers often n…
Describes a method of obtaining an object variable to an already running instance of Microsoft Access so that it can be controlled via automation.
What’s inside an Access Desktop Database. Will look at the basic interface, Navigation Pane (Database Container), Tables, Queries, Forms, Report, Macro’s, and VBA code.
Access reports are powerful and flexible. Learn how to create a query and then a grouped report using the wizard. Modify the report design after the wizard is done to make it look better. There will be another video to explain how to put the final p…

895 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

Need Help in Real-Time?

Connect with top rated Experts

14 Experts available now in Live!

Get 1:1 Help Now