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. |
|
|
Thread Tools | Display Modes |
#41
|
|||
|
|||
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
|
|||
|
|||
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
|
|||
|
|||
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
|
|||
|
|||
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
|
|||
|
|||
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
|
|||
|
|||
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
|
|||
|
|||
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 | |
|
|