A Microsoft Office (Excel, Word) forum. OfficeFrustration

If this is your first visit, be sure to check out the FAQ by clicking the link above. You may have to register before you can post: click the register link above to proceed. To start viewing messages, select the forum that you want to visit from the selection below.

Go Back   Home » OfficeFrustration forum » Microsoft Access » Setting Up & Running Reports
Site Map Home Register Authors List Search Today's Posts Mark Forums Read  

Footer only to appear once!



 
 
Thread Tools Display Modes
  #41  
Old September 25th, 2008, 09:11 PM posted to microsoft.public.access.reports
Marshall Barton
external usenet poster
 
Posts: 5,361
Default Footer only to appear once!

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 Vance wrote:

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.

  #42  
Old September 27th, 2008, 10:45 PM posted to microsoft.public.access.reports
Bob Vance
external usenet poster
 
Posts: 726
Default Footer only to appear once!

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" wrote in message
...
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 Vance wrote:

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.



  #43  
Old September 28th, 2008, 12:58 AM posted to microsoft.public.access.reports
Bob Vance
external usenet poster
 
Posts: 726
Default Footer only to appear once!

Alls Kool ,going great thanks Marshall

"Bob Vance" wrote in message
...
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" wrote in message
...
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 Vance wrote:

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.





  #44  
Old September 28th, 2008, 05:57 PM posted to microsoft.public.access.reports
Marshall Barton
external usenet poster
 
Posts: 5,361
Default Footer only to appear once!

Bob Vance wrote:

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 ;-)

--
Marsh
MVP [MS Access]
  #45  
Old September 29th, 2008, 11:15 PM posted to microsoft.public.access.reports
Bob Vance
external usenet poster
 
Posts: 726
Default Footer only to appear once!

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" wrote in message
...
Bob Vance wrote:

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 ;-)

--
Marsh
MVP [MS Access]



  #46  
Old September 30th, 2008, 12:53 AM posted to microsoft.public.access.reports
Marshall Barton
external usenet poster
 
Posts: 5,361
Default Footer only to appear once!

Bob Vance wrote:

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.

--
Marsh
MVP [MS Access]
  #47  
Old September 30th, 2008, 02:36 AM posted to microsoft.public.access.reports
Bob Vance
external usenet poster
 
Posts: 726
Default Footer only to appear once!

That will do it!!!!!!! Thanks Bob
"Marshall Barton" wrote in message
...
Bob Vance wrote:

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.

--
Marsh
MVP [MS Access]



 




Thread Tools
Display Modes

Posting Rules
You may not post new threads
You may not post replies
You may not post attachments
You may not edit your posts

vB code is On
Smilies are On
[IMG] code is Off
HTML code is Off
Forum Jump


All times are GMT +1. The time now is 03:07 PM.


Powered by vBulletin® Version 3.6.4
Copyright ©2000 - 2024, Jelsoft Enterprises Ltd.
Copyright ©2004-2024 OfficeFrustration.
The comments are property of their posters.