Total Pages for Report inside MsgBox (Access2000)

Collapse
X
Collapse
 
  • Page of 1
  • Time
  • Show
Clear All
new posts
Previous template Next
  • Dash Dad
    New Member
    • Oct 2006
    • 1
    #1

    Total Pages for Report inside MsgBox (Access2000)

    I have a button on a form that will open a label report and print ALL the labels without filtering. I want to be able to put the total number of pages that will be printed inside a MsgBox (so that the user can add the correct number of Label Sheets to the printer).

    Thanks!
    Tags: None
    • willakawill
      Top Contributor
      • Oct 2006
      • 1646
      #2
      Originally posted by Dash Dad
      I have a button on a form that will open a label report and print ALL the labels without filtering. I want to be able to put the total number of pages that will be printed inside a MsgBox (so that the user can add the correct number of Label Sheets to the printer).

      Thanks!

      Divide the number of records by the number of labels per sheet

      rsRecordset.Rec ordCount / LabelsPerSheet

        Comment

        Previous template Next
        Working...