1 2 3 4 5 6 7 8 9 10 11 12 13 14 15 16 17 18 19 20 21 22 23 24 25 26
|
Dim obj As AccessObject
For Each obj In CurrentData.AllTables
If obj.IsLoaded Then
DoCmd.Close obj.Type, obj.Name, acSaveYes
End If
Next
For Each obj In CurrentData.AllQueries
If obj.IsLoaded Then
DoCmd.Close obj.Type, obj.Name, acSaveYes
End If
Next
For Each obj In CurrentProject.AllForms
If obj.IsLoaded Then
DoCmd.Close obj.Type, obj.Name, acSaveYes
End If
Next
For Each obj In CurrentProject.AllReports
If obj.IsLoaded Then
DoCmd.Close obj.Type, obj.Name, acSaveYes
End If
Next |
Partager