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. Duane Hookom

    Re: ENTER PARAMETER VALUE when running report

    Duane Hookom, Jul 24, 2003, in forum: Microsoft Access Reports
    Replies:
    0
    Views:
    4,358
    Duane Hookom
    Jul 24, 2003
  2. Kristy McCool

    Enter Parameter Value

    Kristy McCool, Aug 26, 2003, in forum: Microsoft Access Reports
    Replies:
    4
    Views:
    356
    Kristy McCool
    Aug 26, 2003
  3. Confused

    Enter Parameter Value for Format

    Confused, Aug 29, 2003, in forum: Microsoft Access Reports
    Replies:
    1
    Views:
    452
    Allen Browne
    Aug 29, 2003
  4. David G

    "Enter Parameter Value"

    David G, Oct 9, 2003, in forum: Microsoft Access Reports
    Replies:
    0
    Views:
    291
    David G
    Oct 9, 2003
  5. David G

    "Enter Parameter Value"

    David G, Oct 9, 2003, in forum: Microsoft Access Reports
    Replies:
    0
    Views:
    204
    David G
    Oct 9, 2003
  6. Brad

    Stop 'Enter Parameter Value' after cancelling

    Brad, Nov 6, 2003, in forum: Microsoft Access Reports
    Replies:
    1
    Views:
    241
    Larry Linson
    Nov 6, 2003
  7. Matt

    Enter Parameter Value - Error (in Report)

    Matt, Jan 12, 2004, in forum: Microsoft Access Reports
    Replies:
    1
    Views:
    300
  8. Ken Monk

    Group Totals and Grand Totals on each page

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