New Page with Multiple Comments

[EddieLampert]

I have a series of dated comments in the Detail section of a report. The
comments are related to companies. I want to force a new page when all the
comments for that company are done. When I click force new page after
section, I get each dated comment on its own, separate page. How do I make it
to where a new page starts for each company, but with multiple comments on
each page? Thanks for any help.

 

[Duane Hookom]

Remove the force new page from its current section and add it to company
footer section.

 

[EddieLampert]

The company is not in the detail section. Access is only allowing the force
new page in the detail section. Thanks again.

 

[NoodNutt]

G'day Eddie

Create a Header/Footer for CompanyName, Place the CompanyName
Control/TextField in the Header, in the footerSection select "force new page
after section".

HTH
Mark.

 

[EddieLampert]

Thanks Mark. Still having the problem. I have multiple fields in the page
header that relate to each company, and I have the comments in the Detail
section of the report. Any insight?

 

[Duane Hookom]

Did you create a company footer section as suggested by both Mark and me? I'm
not sure what your Page Header has to do with your issue.

 

[EddieLampert]

There is already a header and footer. The only place I can force new page is
in the Detail section.

 

[NoodNutt]

Eddie

Looks like your not using rationality.

Page header should only reflect page headings eg "Name", "Date" etc.....

Details section includes just that, the details eg Controls.Name etc.....

You should put all of your comments into a subReport, this would then auto
expand/shrink the section for your comments.

My guess is your table structure is not quite right, your table structure
should include a seperate table that houses all the comments made,
particlulary if there are multiple comments made about a record over
different dates.

tblComments
RecordID = ForeignKey (Long Integer, Duplicates OK)
txtCommentDate = Date/Time
txtComment = Memo

If comments are short, (less than 255 Characters then possibly use
TextField) but if they are complex drawn out conclusions then Memo is the
way to go.

Tie the RecordID to the PrimaryKey (Unique Identifier) for your CompanyID,
then select a one-to-many relationship showing all the records from
tblComments where RecordID equals.

HTH
Mark.



Go back to your query design and start from there, create a subQuery for all
the comments using your uniqKey to tie them together.

 

[NoodNutt]

Oops!

Clarification

Tie the RecordID to the PrimaryKey (Unique Identifier) for your CompanyID,
then select a one-to-many relationship showing all the records from
tblComments where RecordID equals.

Should read

Tie the RecordID to the PrimaryKey (Unique Identifier) for your CompanyID,
then select a one-to-many relationship showing all the records from
tblYourCompanyTable and only those from tblComments where RecordID equals.

My Bad, sorry

Mark.

 

[Duane Hookom]

Why do you think you can't force new page in the section header or footer?
The property is there available for you.

 

[Evi]

Eddie, the others aren't referring to the Page or Report header and footer-
they are talking about a Group Footer.
To get a Group Gooter
Click the Sorting/Grouping button on the Toolbar in the Report's Design View
Choose your Company field in the Field column
Below that you will see a grid with Group Header, Group Footer.
Choose Yes next to Group Footer (I would also suggest that you have a Group
Header)
A new Section will appear on your report with a name similar to Company
Footer, Company Header in the grey section bar
Slide your Company name controls into the Company Header section.
Click on the grey bar above the Company Footer section.
Click Properties
Choose Force New Page - After Section

Evi