Try Troubleshooter.

After compile/compact, remake the ACCDE and try again on that ACCDE. If it still gives the error, what is the code behind the button to open the report? (Look on your ACCDB and post the code)

Code

Private Sub OpenOutput_Click()
'
' Open the report, query or form.  if opening a report, open it in preview mode.
'

On Error GoTo ErrHandler

Dim stDocName, stCriteria As String
Dim datStartDate As Variant
Dim datEndDate As Variant
Dim intUserID As Integer
Dim intCountSchools As Integer

    If IsNull(Me!SelectOutput) Then
        MsgBox "From the drop-down menu, please select a report to open.", vbOKOnly, "Information Required"
    Else
        stDocName = Forms!frmreports_SUsers!SelectOutput.Column(1)
        datStartDate = Me.BegDate
        datEndDate = Me.EndDate
        If Me!SelectOutput.Column(4) = True And (IsNull(Me!BegDate) Or IsNull(Me!EndDate)) Then
            MsgBox "A beginning and end date are required.", vbOKOnly, "Information Required"
            Me.BegDate.SetFocus
            Exit Sub
        Else
            If Me.BegDate > Me.EndDate Then
                MsgBox "The beginning date must be before the ending date.", vbOKOnly, "Error"
                Me.BegDate.SetFocus
                Exit Sub
            End If
        End If
    End If

    If Me!SelectOutput.Column(5) = True And (IsNull(Me!PrevBegDate) Or IsNull(Me!PrevEndDate)) Then
        MsgBox "A beginning and end date are required.", vbOKOnly, "Information Required"
            Me.PrevBegDate.SetFocus
            Exit Sub
    Else
        If Me.PrevBegDate > Me.PrevEndDate Then
            MsgBox "The beginning date must be before the ending date.", vbOKOnly, "Error"
            Me.PrevBegDate.SetFocus
            Exit Sub
        End If
    End If
    
    intCountSchools = CountSelectedSchools
    If intCountSchools < 1 Then
        MsgBox "You have not selected any schools for this report.", vbOKOnly, "Information Required"
        Exit Sub
    End If
    
    Select Case Me!SelectOutput.Column(1)
        Case "frmCaseloadDemographics", "frmCaseloadPerformance"
            If Me.lstCohortSemesters.ItemsSelected.Count = 0 Then
                MsgBox "Please select one or more cohort semesters to include in this report.", vbOKOnly, "Information Required"
                Exit Sub
            End If
    End Select

    If IsNull(Me!SelectOutput.Column(7)) = False Then
        stCriteria = Me!SelectOutput.Column(7)
    End If
            
    If Me!SelectOutput.Column(3) = "report" Then
        DoCmd.Minimize
        intUserID = ValidateUserID
        If DLookup("SuppressReportTipPopUp", "tblUsers", "UserID = " & intUserID) = False Then
            DoCmd.OpenForm "frmReportTip"
        End If
        DoCmd.OpenReport stDocName, acViewPreview, , , acWindowNormal, datStartDate & " to " & datEndDate
    ElseIf Me!SelectOutput.Column(3) = "query" Then
        DoCmd.OpenQuery stDocName
    ElseIf Me!SelectOutput.Column(3) = "form" Then
        DoCmd.Minimize
        DoCmd.OpenForm stDocName, , , , , , datStartDate & " to " & datEndDate
    End If

ExitHere: Exit Sub

ErrHandler:
    If Err.Number = 2501 Then
        ' Report was cancelled and that's okay.  Skip over and reopen the reports form so the user can enter wider parameters.
        DoCmd.OpenForm "frmReports_SUsers"
    Else
        MsgBox "Oops! It looks like there has been an error. The error is number " & Err.Number & ": " & Err.Description & " in " & _
        VBE.ActiveCodePane.CodeModule & " in OpenOutput_Click. The program will now attempt to resume normally.", vbOKOnly, "Error"
        Resume ExitHere
    End If
    
End Sub

The VBE object has no value if if the VBA Editor has never been opened.  Since an .accde file cannot open the VB editor, VBE.ActiveCodePane.CodeModule has no value, and will never do.  You need to use the literal name in your code:

     Err.Description & " in MyLiteralModuleNameHere in OpenOutput_Click. ... "

Nice observation, Kevin... thank you! Is this why my procedure throws the error when the user clicks the command button in the accde?

Kevin, after correcting the module reference in my error trapping code, the error trapping now works well. I'm still getting a run time error #91 Object variable or with block variable not set when I try to run a report. I also corrected one variable that I don't think I DIM'd. That did not fix the issue, either. I wonder if my db is corrupted; although the accdb does work as expected, it fails when I convert it to an accde. The only thing that fails is this command button.

That is NOT why the error occurs.  The actual error is stored in Err.Number and Err.Description.  But you can't see them because of another error (caused by the use of VBE).

More importantly, you cannot afford to have errors occurring inside the error handler itself, which defeats the purpose of having error handlers in the first place.  In my old job, all my error handlers contained only procedures.  E.g.:

     ErrHandler:
          HandleAppError()
          RecordAppError()
          ...

And those procedures also have their own error handlers, so that no error would ever be left unhandled.

You also need a way to record errors too, such as storing error numbers and messages in a table so you can review them later.

You may be quite right that I need to develop better error-handling habits. However, I changed the VBE reference for all the procedures in this module. The error number and description are now given. It is not helping me... perhaps I am just not "getting" it, but I don't see my error in the code. And it runs fine in the accdb. Would you mind helping me with that part of the problem? I'd love your feedback on what is causing run time error #91. Thanks so much!

If error 91 is unhandled, it can only occur inside the error handler -- the only part in your procedure that isn't handled by On Error.  As I suggested earlier, put your entire error-handling code inside another procedure, and use On Error there too, so you can trap the error.

Hi Jennifer
I have found in the paste that this error can be caused by an event in your VBA code that has no executable code.  I suggest looking at your code from recent modification either in a Form or Report where you created some VBA code and check where you went to create some code and changed your mind without deleting the event.

If you have done a lot of new Forms and or Reports then create a new Db and move in your tables and queries all together then your Form 2 or 3 at a time.  Create your ACCDE file and see if the error re-occurs.  If so check these form events for events if no executables code within them and delete.  Recompile and keep doing so.