page totals fails with "enter parameter value"

Discussion in 'Microsoft Access Reports' started by barret bondon, Jan 23, 2011.

  1. 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
    Integer)
    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
     
    barret bondon, Jan 23, 2011
    #1
    1. Advertisements

Want to reply to this thread or ask your own question?

It takes just 2 minutes to sign up (and it's free!). Just click the sign up button to choose a username and then you can ask your own questions on the forum.
Similar Threads
  1. khinester

    Group Totals and Totals

    khinester, Aug 11, 2003, in forum: Microsoft Access Reports
    Replies:
    0
    Views:
    213
    khinester
    Aug 11, 2003
  2. Robert Raley

    Totals and gran totals for subreports

    Robert Raley, Dec 11, 2004, in forum: Microsoft Access Reports
    Replies:
    3
    Views:
    210
    Larry Linson
    Dec 12, 2004
  3. Guest

    Weekly totals and monthly totals

    Guest, Jul 15, 2005, in forum: Microsoft Access Reports
    Replies:
    1
    Views:
    261
    Guest
    Jul 15, 2005
  4. Oscar

    Group Totals and Report Totals

    Oscar, Jul 26, 2006, in forum: Microsoft Access Reports
    Replies:
    2
    Views:
    241
    lewie
    Jul 26, 2006
  5. Ken Monk

    Group Totals and Grand Totals on each page

    Ken Monk, Apr 8, 2014, in forum: Microsoft Access Reports
    Replies:
    3
    Views:
    489
    Access Developer
    Apr 10, 2014
Loading...

Share This Page