Footer only to appear once!

[Marshall Barton]

What? Invisible subreport?? I have no idea what you are
talking about.

Just guessing, but the extra copies are usually caused by
the report's record source query joining to a table that uis
not used in the report.

 

[Bob Vance]

Marshall, Worked out why I was getting 8 pages , its because I had 8 clients
owing so hence the number tp print BUT my controls set to the query are not
printing any infomation, where would I start...............Thanks Bob

What? Invisible subreport?? I have no idea what you are
talking about.

Just guessing, but the extra copies are usually caused by
the report's record source query joining to a table that uis
not used in the report.
--
Marsh
MVP [MS Access]

Thanks Marshall, just added tha sub reportto that name and made it
Invisible, But why would I be getting 8 copies of each
report!

"Marshall Barton" wrote.

 

[Bob Vance]

Alls Kool ,going great thanks Marshall

Marshall, Worked out why I was getting 8 pages , its because I had 8
clients owing so hence the number tp print BUT my controls set to the
query are not printing any infomation, where would I
start...............Thanks Bob

What? Invisible subreport?? I have no idea what you are
talking about.

Just guessing, but the extra copies are usually caused by
the report's record source query joining to a table that uis
not used in the report.
--
Marsh
MVP [MS Access]

Thanks Marshall, just added tha sub reportto that name and made it
Invisible, But why would I be getting 8 copies of each
report!

"Marshall Barton" wrote.
Bob Vance wrote:

Thanks Marshall , I copied my Report that was working and made Record
Source
to my query like in batch print , made your changes , I am getting 8
reports
for the same Client all the same! also I am getting Enter parameter for
tbPreviousInvoiceAmount and SubChildOwnerPaidAmount
Apart from that all works Good............Regards Bob

Private Sub Spacer_Format(Cancel As Integer, FormatCount As Integer)


Dim FooterTop As Long
FooterTop = PAPERHEIGHT - BOTTOMMARGIN _
- Me.OwnerFooter.Height
If Me.Top >= FooterTop Then
Me.pgEject.Visible = True
Else
Me.pgEject.Visible = False
Me.Spacer.Height = FooterTop - Me.Top
End If
End Sub


Parameter prompts come from your use of a field name that is
not in the report's record source. The unknown field name
might be in the report's record source query, Sorting and
Grouping or in a text box's control source. This issue has
nothing to do with the code that positions the footer.

 

[Marshall Barton]

Alls Kool ,going great thanks Marshall

Great news. You even figured it out before I haf a chance
to see the problem. You must be getting fairly good at this
stuff ;-)

 

[Bob Vance]

Thanks Marshall, Can you explain this, I have another db the same as The one
I have been working on to get that report going. So I copied the db deleted
all the tables and imported all the tables from my other db, Now this db is
showing the bottom footer at the top of the next page on all client reports,
As you said before is this just something that might happen and cant get
around
Regards Bob

 

[Marshall Barton]

Thanks Marshall, Can you explain this, I have another db the same as The one
I have been working on to get that report going. So I copied the db deleted
all the tables and imported all the tables from my other db, Now this db is
showing the bottom footer at the top of the next page on all client reports,
As you said before is this just something that might happen and cant get
around

Check the Margin settings in Page Setup to make sure they
agree with the numbers we used in the calculations.

 

[Bob Vance]

That will do it!!!!!!! Thanks Bob

Check the Margin settings in Page Setup to make sure they
agree with the numbers we used in the calculations.