Results 1 to 4 of 4
  1. #1
    Join Date
    Oct 2010
    Posts
    2

    Unanswered: help with this access prolblem

    I am supposed create a new standard module named basAntiquesGeneralProcedures and add two procedures to it. The first procedure should print rptEmployeeSalaryDetail, and the second procedure should print rptEmployeeSalarySummary. so i come up with this and I keep getting a compile error. can anyone help me


    Public Sub PrintReport()
    DoCmd.OpenReport "rptEmployeeSalaryDetail", acViewNormal, , , acWindowNormal, ""





    End Sub

  2. #2
    Join Date
    Feb 2004
    Location
    One Flump in One Place
    Posts
    14,912
    There's nothing wrong with what you have posted.
    You need to give more details about the error. What is the error? When do you get it? Does it give you a "Debug" option? If so, what line is highlighted when you click it?
    Testimonial:
    pootle flump
    ur codings are working excelent.

  3. #3
    Join Date
    Oct 2010
    Posts
    2

    answer

    when i run it it gives me a run time error 2501 the Open repot action was canceled.
    when I debug it just goes to the line
    DoCmd.OpenReport "rptEmployee Salary Summary Report", acViewNormal, , , acWindowNormal, ""

  4. #4
    Join Date
    Feb 2004
    Location
    One Flump in One Place
    Posts
    14,912
    The error is with the report then. Is there any code running on open\ load\ format?
    Testimonial:
    pootle flump
    ur codings are working excelent.

Posting Permissions

  • You may not post new threads
  • You may not post replies
  • You may not post attachments
  • You may not edit your posts
  •