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?

You'll need to choose a username for the site, which only take a couple of moments (here). After that, you can post your question and our members will help you out.
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,415
    Duane Hookom
    Jul 24, 2003
  2. Kristy McCool

    Enter Parameter Value

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

    Enter Parameter Value for Format

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

    "Enter Parameter Value"

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

    "Enter Parameter Value"

    David G, Oct 9, 2003, in forum: Microsoft Access Reports
    Replies:
    0
    Views:
    253
    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:
    279
    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:
    337
  8. Ken Monk

    Group Totals and Grand Totals on each page

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