Footer only to appear once!

  • Thread starter Thread starter Bob Vance
  • Start date Start date
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.
 
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

Marshall Barton said:
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]


Bob said:
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.
Click to expand...
Click to expand...
 
Alls Kool ,going great thanks Marshall :)

Bob Vance said:
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

Marshall Barton said:
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]


Bob said:
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.
Click to expand...
Click to expand...
Click to expand...
 
Bob said:
Alls Kool ,going great thanks Marshall :)
Click to expand...

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 ;-)
 
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
 
Bob said:
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
Click to expand...


Check the Margin settings in Page Setup to make sure they
agree with the numbers we used in the calculations.
 
That will do it!!!!!!! Thanks Bob
Marshall Barton said:
Check the Margin settings in Page Setup to make sure they
agree with the numbers we used in the calculations.
Click to expand...
 
Back
Top