Too many pages printing

[Afrosheen via AccessMonster.com]

First of all again thanks for reading this post.

Here's what's happening. I have a form that will print out everyone on one
page based on the master/child link. It may be 3 names. The thing is that it
will print out 3 pages also with the same information. I don't need 2 extra
pages when 1 will do. I just need the names that may be on page one. If it
fills up page one then go to page 2 and so on.

I hope this kind of explains it.

 

[Duane Hookom]

It seems that your report and subreport have the same level of detail.
Normally a main report would have "master" data and the subreport would have
the related details. For instance a main report might be based on the Orders
table and a subreport would be based on the OrderDetails. If the OrderDetails
table was include in the main report record source, you would experience the
same symptoms that you have in your report.

 

[Afrosheen via AccessMonster.com]

I guess you're correct. The information for both the main form letter and the
three sub forms are coming from the same control source. A query. When i
changed the control source it kept on asking for parameters. Any suggestions?
I don't think I can change my control source. The three sub forms are based

It seems that your report and subreport have the same level of detail.
Normally a main report would have "master" data and the subreport would have
the related details. For instance a main report might be based on the Orders
table and a subreport would be based on the OrderDetails. If the OrderDetails
table was include in the main report record source, you would experience the
same symptoms that you have in your report.

First of all again thanks for reading this post.

[quoted text clipped - 5 lines]

I hope this kind of explains it.

 

[Duane Hookom]

Please don't use the term "form" when talking about reports and subreports. I
assume you don't mean form. Also, I think you mean the main and sub reports
have the same Record Source not control source.

If you don't want your information to repeat, move the subreport to a header
or get rid of the detailed records in the main report with a totals query as
the Record Source.

If you can't figure this out, come back with more information about your
tables and data and how you want them to appear in your report.
--
Duane Hookom
Microsoft Access MVP

I guess you're correct. The information for both the main form letter and the
three sub forms are coming from the same control source. A query. When i
changed the control source it kept on asking for parameters. Any suggestions?
I don't think I can change my control source. The three sub forms are based

It seems that your report and subreport have the same level of detail.
Normally a main report would have "master" data and the subreport would have
the related details. For instance a main report might be based on the Orders
table and a subreport would be based on the OrderDetails. If the OrderDetails
table was include in the main report record source, you would experience the
same symptoms that you have in your report.

First of all again thanks for reading this post.

[quoted text clipped - 5 lines]

I hope this kind of explains it.

 

[Afrosheen via AccessMonster.com]

Thanks for reading this and helping me out. I really appreciate it. I've only
been working with Access about 1 1/2yrs. So, I'm great full for any help

Sorry about the terminology. I do have a tendency to get them mixed up.

I don't know how detailed you want me to be, so here it is.

I have one report. It is a form letter where I can have one "form" and add
different things to it. Like a mass mailing letter. I'm trying to use the
same report/subreport for 3 things.

I use one query called: qryTaps. That query consist of:
StaffId
Lname
Fname
WorkPlan
WorkRec
IntDue
IntRec
FinalDue
FinalRec
Archive
About 4 other fields that I don't need.
Supervisor
Location
AssistMan
UnitMan

And that's it for the query.

I use a form for generating the report. The fields are List55 which consists
of WorkPlan - FinalRec. A Month group called grpMonth. A department group
that groups those in a certain department for selection.
And a combo box with the names of the department people.

Say for example I choose "WorkPlan" = January where the archive field is
false and the supervisor name is "Tom"

Here's the code that does that. I believe this produces a filter because when
I look at the report, the filter field will show the results of the
information. Don't know if this is the proper way to do it.

strWhere = "qryTaps.WorkPlan=""" & strMon & _
""" AND qryTaps.Archive=False" & _
" AND qrytaps.Supervisor=""" & Me.cboloc & """"

The name of the main report is called: rptTaps. The record source is: qryTaps.
No filter showing. Filter on load = yes. In the detail section I have the
supervisor name and his department.

I have a subreport in the Detail section called "rptTapsSub". The record
source is also called: qryTaps. On the Data Tab, The SourceObject is: Report.
rptTapsSub. Link Master/Child is: Supervisor;Workplan. Filter on empty.
Master = Yes. Enabled = Yes

Here's what's supposed to happen. When I click on the Print Command, the
strWhere statement is generated. I believe it is supposed to produce all the
records from the qryTaps that match the strWhere criteria and show them in
the rptTapsSub subreport.

This is where the problem happens. If I have 3 records, it will show the
three records. It will also generate 3 reports with the exact same
information and that's what I'm trying to avoid. Now if there's enough
information to display/print then there is room on the report then fine,
another page is ok.

The final goal is to either Print or Email these reports.

There are two other subreports also. So on load it does a select case that
will hide the other subreports if I don't need them.

I do have a Supervisor table called tblSupervisor. There is no relation set
up in the tblSupervisor.

I hope this was enough information and as detailed as I think I can be.


Again, Thanks for the help..

Please don't use the term "form" when talking about reports and subreports. I
assume you don't mean form. Also, I think you mean the main and sub reports
have the same Record Source not control source.

If you don't want your information to repeat, move the subreport to a header
or get rid of the detailed records in the main report with a totals query as
the Record Source.

If you can't figure this out, come back with more information about your
tables and data and how you want them to appear in your report.

I guess you're correct. The information for both the main form letter and the
three sub forms are coming from the same control source. A query. When i

[quoted text clipped - 14 lines]

 

[Duane Hookom]

This seems unconventional. Why do you need a subreport based on the same
information as is available in your main report? The detail section of your
main report can render the same information as your subreport.

--
Duane Hookom
Microsoft Access MVP

Thanks for reading this and helping me out. I really appreciate it. I've only
been working with Access about 1 1/2yrs. So, I'm great full for any help

Sorry about the terminology. I do have a tendency to get them mixed up.

I don't know how detailed you want me to be, so here it is.

I have one report. It is a form letter where I can have one "form" and add
different things to it. Like a mass mailing letter. I'm trying to use the
same report/subreport for 3 things.

I use one query called: qryTaps. That query consist of:
StaffId
Lname
Fname
WorkPlan
WorkRec
IntDue
IntRec
FinalDue
FinalRec
Archive
About 4 other fields that I don't need.
Supervisor
Location
AssistMan
UnitMan

And that's it for the query.

I use a form for generating the report. The fields are List55 which consists
of WorkPlan - FinalRec. A Month group called grpMonth. A department group
that groups those in a certain department for selection.
And a combo box with the names of the department people.

Say for example I choose "WorkPlan" = January where the archive field is
false and the supervisor name is "Tom"

Here's the code that does that. I believe this produces a filter because when
I look at the report, the filter field will show the results of the
information. Don't know if this is the proper way to do it.

strWhere = "qryTaps.WorkPlan=""" & strMon & _
""" AND qryTaps.Archive=False" & _
" AND qrytaps.Supervisor=""" & Me.cboloc & """"

The name of the main report is called: rptTaps. The record source is: qryTaps.
No filter showing. Filter on load = yes. In the detail section I have the
supervisor name and his department.

I have a subreport in the Detail section called "rptTapsSub". The record
source is also called: qryTaps. On the Data Tab, The SourceObject is: Report.
rptTapsSub. Link Master/Child is: Supervisor;Workplan. Filter on empty.
Master = Yes. Enabled = Yes

Here's what's supposed to happen. When I click on the Print Command, the
strWhere statement is generated. I believe it is supposed to produce all the
records from the qryTaps that match the strWhere criteria and show them in
the rptTapsSub subreport.

This is where the problem happens. If I have 3 records, it will show the
three records. It will also generate 3 reports with the exact same
information and that's what I'm trying to avoid. Now if there's enough
information to display/print then there is room on the report then fine,
another page is ok.

The final goal is to either Print or Email these reports.

There are two other subreports also. So on load it does a select case that
will hide the other subreports if I don't need them.

I do have a Supervisor table called tblSupervisor. There is no relation set
up in the tblSupervisor.

I hope this was enough information and as detailed as I think I can be.


Again, Thanks for the help..

Please don't use the term "form" when talking about reports and subreports. I
assume you don't mean form. Also, I think you mean the main and sub reports
have the same Record Source not control source.

If you don't want your information to repeat, move the subreport to a header
or get rid of the detailed records in the main report with a totals query as
the Record Source.

If you can't figure this out, come back with more information about your
tables and data and how you want them to appear in your report.

I guess you're correct. The information for both the main form letter and the
three sub forms are coming from the same control source. A query. When i

[quoted text clipped - 14 lines]

I hope this kind of explains it.

 

[Afrosheen via AccessMonster.com]

Thanks Duane for getting back to me. I'll have another look at it. As I was
telling a friend the person I'm doing the DB for wants it done by Fri. [which
it isn't going to be]. I was saying that because of that then you have a
tendency to do the wrong things to get it done and not the right way. The old
saying "Never enough time to do it right the first time, but always enough
time to do it right the second time."

The difference in the subreports are: sub1 - "WorkPlan". Sub2 - "IntDue".
sub3 - "FinalDue".

Like I said, I'll recheck it out.
Thanks..

This seems unconventional. Why do you need a subreport based on the same
information as is available in your main report? The detail section of your
main report can render the same information as your subreport.

Thanks for reading this and helping me out. I really appreciate it. I've only
been working with Access about 1 1/2yrs. So, I'm great full for any help

[quoted text clipped - 89 lines]

 

[Afrosheen via AccessMonster.com]

I finally found out what I was doing wrong. Thanks for suggesting that I look
at it again.

Thanks Duane for getting back to me. I'll have another look at it. As I was
telling a friend the person I'm doing the DB for wants it done by Fri. [which
it isn't going to be]. I was saying that because of that then you have a
tendency to do the wrong things to get it done and not the right way. The old
saying "Never enough time to do it right the first time, but always enough
time to do it right the second time."

The difference in the subreports are: sub1 - "WorkPlan". Sub2 - "IntDue".
sub3 - "FinalDue".

Like I said, I'll recheck it out.
Thanks..

This seems unconventional. Why do you need a subreport based on the same
information as is available in your main report? The detail section of your

[quoted text clipped - 5 lines]