[AccessD] Close All Forms

Barbara Ryan BarbaraRyan at cox.net
Fri Aug 19 13:51:50 CDT 2005


I have used the following code successfully in Access 97 to close all forms when a specific function key is pressed.  However, in Access 2002, this code causes the error box to appear (with the 2 options to send an error report to Microsoft or not) and then closes Access.  Does anyone know why?

    Function CloseAllForms()
        Dim i As Integer
        ' Loop through the collection of open forms and close them (except for the main menu)
        If Forms.Count > 0 Then
            For i = Forms.Count - 1 To 0 Step -1
                If Forms(i).Name <> "frmMainMenu" Then
                    DoCmd.Close acForm, Forms(i).Name
                End If
            Next i
        End If
    End Function

Thanks,
Barb Ryan




More information about the AccessD mailing list