Print Form/Report with Master and one Detail record per page?

Tech-Archive recommends: Repair Windows Errors & Optimize Windows Performance

From: Chuck Harmon (anonymous_at_discussions.microsoft.com)
Date: 02/12/04 

Date: Thu, 12 Feb 2004 11:07:08 -0800

Is there a way to print, on a single page, master and
detail data when multiple detail records can occur for
each master record? This needs to be done automatically
without user response.

I have a form with master/detail record data. There can be
many detail records for each master record. Detail and
master data are on separate tables. Both form and report
used subform/subreport respectively. I have been unable to
print the form with just a single detail record data per
page when there are multiple detail records.

I tried using a report, but it also failed. It printed all
detail records on multiple pages along with a header and
trailer on first and last page respectively.

I created a partial solution using a filtered form printed
from a different print menu form, but unfortunately Access
generated a prompt for the user to type in, thus defeating
the desired automatic print action. Also it caused an
annoying flash on the screen as the form to be printed
reloaded for each new detail record.

Any suggestions on how to do this will be appreciated.
I am using Access 2000.

Thanks.
Chuck Harmon

Relevant Pages

  • Re: About "caching" Re: Ajax Demo
    ... in the first time. ... each master record has about 10 detail records. ... no matter what the data model volumetics ...
    (borland.public.delphi.non-technical)
  • Retrieving Contents of Select List on Form Submit
    ... On an HTML form, I have a select list that is fed dynamically with ... detail records when the master record is displayed on the form. ... array so I can update and add the proper database records. ...
    (comp.lang.php)
  • Re: BIG BUG in Deleting detali records
    ... happen deleting master record does not delete detail records after ... You have to delete the detail records just deleting the master record doesn't ... updatebatch before changing master records all the deletes will be lost. ...
    (borland.public.delphi.database.ado)
  • RE: How to diable edit mode in the datagrid
    ... Protected Function CheckStatus(ByVal StatusID As Boolean) As Boolean ... > I have a datagrid that allows users to eidt/update detail records. ... > shows detail records for a master record. ...
    (microsoft.public.dotnet.framework.aspnet)
  • Re: Limit a report to print the first 5 detail results per record?
    ... >I am printing a report that uses two tables, one is the master record and ... > I want to limit my report to only print 10 of the detail records. ...
    (microsoft.public.access.reports)