Access 2007

  • Thread starter Thread starter Guest
  • Start date Start date
G

Guest

How I can use to print the total amount in the last page in a report in
Access 2007 as:
If (Pages)>1 Then
[Totals] print to the last page
Else [Totals] print to the first page
End If
 
well, i don't know how different Access2007 is, but have you tried putting
the [Totals] control in the ReportFooter section? the section should print
at the end of the report, whether it be one page or 10 pages, or a hundred
pages, or...

hth
 
Dear Tina,
Thank you for your reply. It’s the same also to Access 2007 but my question
remain as I need to put the total of the invoice in the last page and in a
specific position.



tina said:
well, i don't know how different Access2007 is, but have you tried putting
the [Totals] control in the ReportFooter section? the section should print
at the end of the report, whether it be one page or 10 pages, or a hundred
pages, or...

hth


Timothy Langaster said:
How I can use to print the total amount in the last page in a report in
Access 2007 as:
If (Pages)>1 Then
[Totals] print to the last page
Else [Totals] print to the first page
End If
Click to expand...
Click to expand...
 
Timothy Langaster said:
Dear Tina,
Thank you for your reply. It's the same also to Access 2007 but my
question
remain as I need to put the total of the invoice in the last page and in a
specific position.
Click to expand...

It is always considerate if you give the entire requirements in your initial
question, so people do not waste time giving you answers that you
immediately reject and add an additional requirement (in this case "and in a
specific position").

A Total for the entire Report must needs be calculated in the Report Footer.
You can set the Visible property of that Control to No, and then put your
code in the Print event of the Page Footer to test and copy it there.

If [Page] = [Pages] Then
Me.txtPageFootTotal = Me.txtReportFootTotal
Me.txtPageFootTotal.Visible = True
End If

That's air code, untested, but I suspect it will work if you change the
"txtPageFootTotal" and "Me.txtReportFootTotal" to your Control names.

Larry Linson
Microsoft Access MVP
 
Dear Larry Linson

Thank you for your email reply.
I can’t understand what is the “txtPageFootTotal “and “txtReportFootTotal
“and how I can use it.
Please be so kind to explain me as I am novice in this matter.
Thank you for your cooperation.

Larry Linson said:
Timothy Langaster said:
Dear Tina,
Thank you for your reply. It's the same also to Access 2007 but my
question
remain as I need to put the total of the invoice in the last page and in a
specific position.
Click to expand...

It is always considerate if you give the entire requirements in your initial
question, so people do not waste time giving you answers that you
immediately reject and add an additional requirement (in this case "and in a
specific position").

A Total for the entire Report must needs be calculated in the Report Footer.
You can set the Visible property of that Control to No, and then put your
code in the Print event of the Page Footer to test and copy it there.

If [Page] = [Pages] Then
Me.txtPageFootTotal = Me.txtReportFootTotal
Me.txtPageFootTotal.Visible = True
End If

That's air code, untested, but I suspect it will work if you change the
"txtPageFootTotal" and "Me.txtReportFootTotal" to your Control names.

Larry Linson
Microsoft Access MVP
Click to expand...
 
As I said in the original post... you should replace those with the names of
the TextBoxControls you create in the "Page Footer" and the "Report Footer".

The TextBox in the Report Footer would have a Control Source that Sums the
value and, if you don't want it displayed there, set its Visible property to
No, The TextBox in the Page Footer would be unbound... the code shown would
set its value, only on the very last page.

The code shown, again as I said in the original post, should be in the Print
event of the Page Footer.

I don't know how I can make this any simpler or more explicit. If you have
other _specific_ questions, post back here to ask.

Larry Linson
Microsoft Access MVP

Timothy Langaster said:
Dear Larry Linson

Thank you for your email reply.
I can't understand what is the "txtPageFootTotal "and "txtReportFootTotal
"and how I can use it.
Please be so kind to explain me as I am novice in this matter.
Thank you for your cooperation.

Larry Linson said:
Timothy Langaster said:
Dear Tina,
Thank you for your reply. It's the same also to Access 2007 but my
question
remain as I need to put the total of the invoice in the last page and
in a
specific position.
Click to expand...

It is always considerate if you give the entire requirements in your
initial
question, so people do not waste time giving you answers that you
immediately reject and add an additional requirement (in this case "and
in a
specific position").

A Total for the entire Report must needs be calculated in the Report
Footer.
You can set the Visible property of that Control to No, and then put your
code in the Print event of the Page Footer to test and copy it there.

If [Page] = [Pages] Then
Me.txtPageFootTotal = Me.txtReportFootTotal
Me.txtPageFootTotal.Visible = True
End If

That's air code, untested, but I suspect it will work if you change the
"txtPageFootTotal" and "Me.txtReportFootTotal" to your Control names.

Larry Linson
Microsoft Access MVP
Click to expand...
Click to expand...
 
Thank you very much Larry,
You are very clear now.
Have a nice day.



Larry Linson said:
As I said in the original post... you should replace those with the names of
the TextBoxControls you create in the "Page Footer" and the "Report Footer".

The TextBox in the Report Footer would have a Control Source that Sums the
value and, if you don't want it displayed there, set its Visible property to
No, The TextBox in the Page Footer would be unbound... the code shown would
set its value, only on the very last page.

The code shown, again as I said in the original post, should be in the Print
event of the Page Footer.

I don't know how I can make this any simpler or more explicit. If you have
other _specific_ questions, post back here to ask.

Larry Linson
Microsoft Access MVP

Timothy Langaster said:
Dear Larry Linson

Thank you for your email reply.
I can't understand what is the "txtPageFootTotal "and "txtReportFootTotal
"and how I can use it.
Please be so kind to explain me as I am novice in this matter.
Thank you for your cooperation.

Larry Linson said:
message Dear Tina,
Thank you for your reply. It's the same also to Access 2007 but my
question
remain as I need to put the total of the invoice in the last page and
in a
specific position.

It is always considerate if you give the entire requirements in your
initial
question, so people do not waste time giving you answers that you
immediately reject and add an additional requirement (in this case "and
in a
specific position").

A Total for the entire Report must needs be calculated in the Report
Footer.
You can set the Visible property of that Control to No, and then put your
code in the Print event of the Page Footer to test and copy it there.

If [Page] = [Pages] Then
Me.txtPageFootTotal = Me.txtReportFootTotal
Me.txtPageFootTotal.Visible = True
End If

That's air code, untested, but I suspect it will work if you change the
"txtPageFootTotal" and "Me.txtReportFootTotal" to your Control names.

Larry Linson
Microsoft Access MVP
Click to expand...
Click to expand...
Click to expand...
 
Back
Top