PC Review

Thread Tools Rate Thread

page totals fails with "enter parameter value"

barret bondon
Posts: n/a
      23rd Jan 2011
Trying to get counts in the bottom of each page of a report; cut and pasted
from MS and lots of sites, but get
requests for a parameter when the report opens.

I have of course a text box in the footer with " = txtpageSum ", and I get
a request for this as the parameter value

Option Compare Database
Dim txtpageSum As Integer

Private Sub PageFooterSection_Print(Cancel As Integer, PrintCount As
If PrintCount = 1 Then
' txtpageSum = txtpageSum + ExtendedPrice
' txtPageQuantity = txtPageQuantity + Quantity
txtpageSum = 22 'test; keeping it simple
End If
End Sub

Private Sub PageHeaderSection_Print(Cancel As Integer, _
PrintCount As Integer)
txtpageSum = 0
' txtPageQuantity = 0
End Sub

Reply With Quote

Thread Tools
Rate This Thread
Rate This Thread:

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

BB code is On
Smilies are On
[IMG] code is On
HTML code is Off
Trackbacks are On
Pingbacks are On
Refbacks are Off

Similar Threads
Thread Thread Starter Forum Replies Last Post
Pivot Totals: Group totals different from Grand totals PsyberFox Microsoft Excel Misc 1 13th Feb 2008 07:16 PM
Windows Explorer fails and fails and fails... Bill Windows Vista General Discussion 30 10th Jun 2007 04:57 AM
error STOP:0x0000007B (parameter, parameter, parameter, parameter) robert35 Microsoft Access Getting Started 1 15th Dec 2004 04:28 PM
Windows update fails, freezes, fails to logon on hotmail, fails to send mail from outlook express, windows update errors, router settings, "MTU , Partial Loss of Internet Connection, and Performance" stevan Windows XP General 0 9th Aug 2004 07:08 PM
Print 16 entries per page with sub totals & totals Brian Microsoft Excel Misc 1 8th Oct 2003 01:16 AM




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