Results 1 to 4 of 4
  1. #1
    Ray67 is offline Competent Performer
    Windows XP Access 2003
    Join Date
    Jul 2011
    Posts
    338

    Compile Error Sub or function not defined

    Hello

    I'm getting error with reports. Not sure what i'm doing wrong.

    Private Sub Report_Close()
    DoCmd.Close acForm, "F_MonthlyFee Settlement Reconciling"

    End Sub


    Private Sub Report_Open(Cancel As Integer)
    ' Set public variable to true to indicate that the report
    ' is in the Open event
    bInReportOpenEvent = True


    ' Open F_MonthlyFee Settlement Reconciling
    DoCmd.OpenForm "F_MonthlyFee Settlement Reconciling", , , , , acDialog


    ' Cancel Report if User Clicked the Cancel Button
    If IsLoaded("F_MonthlyFee Settlement Reconciling") = False Then Cancel = True


    ' Set public variable to false to indicate that the
    ' Open event is completed
    bInReportOpenEvent = False

    DoCmd.Close acQuery, "Q_ReflectedlastMonth"

    End Sub




    Thank you

  2. #2
    pbaldy's Avatar
    pbaldy is offline Who is John Galt?
    Windows XP Access 2007
    Join Date
    Feb 2010
    Location
    Nevada, USA
    Posts
    22,521
    On what line? IsLoaded is not a built-in function, if it's there.
    Paul (wino moderator)
    MS Access MVP 2007-2019
    www.BaldyWeb.com

  3. #3
    Ray67 is offline Competent Performer
    Windows XP Access 2003
    Join Date
    Jul 2011
    Posts
    338
    i got it. i was missing my Modules coding. Thank you

  4. #4
    pbaldy's Avatar
    pbaldy is offline Who is John Galt?
    Windows XP Access 2007
    Join Date
    Feb 2010
    Location
    Nevada, USA
    Posts
    22,521
    No problem.
    Paul (wino moderator)
    MS Access MVP 2007-2019
    www.BaldyWeb.com

Please reply to this thread with any new information or opinions.

Similar Threads

  1. Replies: 4
    Last Post: 06-08-2012, 09:08 AM
  2. Compile error: code or function not defined
    By GeorgeBrown in forum Access
    Replies: 1
    Last Post: 09-19-2011, 10:25 AM
  3. Compile error: Variable not defined
    By HarryScofs in forum Access
    Replies: 8
    Last Post: 07-25-2011, 09:06 AM
  4. Compile error. Sub of function not defined
    By plavookins in forum Reports
    Replies: 7
    Last Post: 04-22-2011, 10:15 AM
  5. Replies: 23
    Last Post: 03-26-2009, 06:50 PM

Posting Permissions

  • You may not post new threads
  • You may not post replies
  • You may not post attachments
  • You may not edit your posts
  •  
Other Forums: Microsoft Office Forums