Still having problems with columns and footers

  • Thread starter Thread starter anonymous
  • Start date Start date
A

anonymous

I would like to have a page footer that shows up at the
end of each group and not on each page.
I tried using the group footer for this but the problem is
that it wants to follow the page setup, which has columns
(the footer does not).

I attempted using subreports to fix this problem both with
columns following down, then across and accross, then
down, but the information just didn't want to match up
with the rest.

This is driving me crazy.

I want one of two things.
1) A code (with full instructions, please) on how to
constrict the columns ONLY to the group header and the
details.
My header contains One text box and One label that is
meant to follow three columns down the page.
My Details also contains one text box that contains a
field and another that contains a code. It is also meant
to follow three columns in a specific order.
OR
2) A code (with full instructions, yes, I am a moron) on
how to make the page footer (if possible)to only show up
at the end of each group.

My footer is static and does not contain dynamic
information. It is simply there for signatures and
confirmation once printed.

I am also using Access 97.

Once again, ANY help/suggestions will be GREATLY
appreciated.
 
"anonymous" wrote
I would like to have a page footer that shows up at the
end of each group and not on each page.
Click to expand...

By definition, a Page Footer is a footer for a page, not for a Group. It may
be possible to make the page footer invisible except on pages where there
would be a Group Footer. But it will still be located at the bottom of the
page, not immediately after the Group's Detail records.
I tried using the group footer for this but the problem is
that it wants to follow the page setup, which has columns
(the footer does not).
Click to expand...

You are free to design the group footer in any way you desire. The only
thing to which I can think you may be referring is that some of the Wizards
may organize a group footer in this manner. Open the Report in design view,
and change the design of the footer to whatever form you prefer.
I attempted using . . .
Click to expand...
This is driving me crazy.
Click to expand...

I fear you are "driving yourself crazy" by focusing in on only one approach
to solving the problem, that is not the proper one, and not recognizing that
Access' reporting puts control in the hands of you, the developer. You are
desiring to _force_ Access reporting to work in some preconceived way, when
there is an easy, natural way for it to work.
I want one of two things.
1) A code (with full instructions, please)
on how to constrict the columns ONLY
to the group header and the details.
Click to expand...

This is unnecessary. You do many things with code in Reports, but formatting
the sections isn't one of them. You move the objects (Controls, Labels,
etc.) around _visually_ for this purpose.
2) A code (with full instructions, yes, I
am a moron) on how to make the page
footer (if possible)to only show up
at the end of each group.
Click to expand...

As I described earlier, you might be able to do this with some code
manipulating the Visible properties, but it would be counter-productive.

Sounds to me as if you would benefit from some basic training in Report
design. A good book for the raw novice is "Microsoft Access <versionnumber>
Step by Step" from Microsoft Press. There is also some training material
available, free, at the Office Online site,
http://office.microsoft.com/home/default.aspx?Origin=EC010227091033&CTT=2.

Larry Linson
.. Microsoft Access MVP
 
-----Original Message-----
By definition, a Page Footer is a footer for a page, not for a Group. It may
be possible to make the page footer invisible except on pages where there
would be a Group Footer. But it will still be located at the bottom of the
page, not immediately after the Group's Detail records.
Click to expand...

This is exactly what I want. I would like the Group
Footer at the bottom of the page (not directly
after/below), but at the end of the group and before the
next group begins on the following page. Is this
possible? If it is, how would I go about doing it?

I'm a novice and started using Access at work, and I like
it.
 
Caveats:

You will not conveniently be able to sum or average or count over the group
in the page footer, but you can pick those up from invisible controls in the
group footer.

Create a group footer with all the aggregate controls that you will want
shown in the page footer (Sum, Count, etc.). Set their Visible property to
No. You will never show these.

Create the controls you want in the Page Footer. For any that should show
the aggregate values from the Group Footer, create unbound Controls. Set all
Controls' Visible Property to No. Set the ForceNewPage property to After
Section.

In the Print Event of the Group Footer, set the Visible property of each
control in the Page Footer to True.

In the Print Event of the Group Header, set the Visible property of each
Control in the Page Footer to False.

In the Print Event of the Page Footer, set the value of the unbound Controls
to the value of their counterpart Controls in the Group Footer.

This worked for me on a test report based on a Query joining the Categories
and Products Table of the sample Northwind database that comes with Access.
I've posted it in the "Other Examples" list at http://accdevel.tripod.com,
so you can take a close look at what I've done.

Larry Linson
Microsoft Access MVP
 
Back
Top