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 27 28 29 30 31 32 33 34 35 36 37 38 39 40 41 42 43 44 45 46 47 48 49 50 51 52 53 54 55 56 57 58 59 60 61 62 63 64 65 66 67 68 69 70 71 72 73 74 75 76 77 78 79 80
| ' Constante globale
Const TBL_TOOLBAR = "tblVisibleToolbars"
' --------------------------------------------------------
' Masque la fenêtre de base de données
' --------------------------------------------------------
Sub HideDBwindow()
DoCmd.SelectObject acTable, , True
DoCmd.RunCommand acCmdWindowHide
End Sub
' --------------------------------------------------------
' Affiche la fenêtre de base de données
' --------------------------------------------------------
Sub ShowDBwindow()
DoCmd.SelectObject acTable, , True
End Sub
' --------------------------------------------------------
' Masque les barres de menu/outils
' --------------------------------------------------------
Sub HideMenus()
Dim db As DAO.Database, rs As DAO.Recordset
EnumVisibleToolBars
Set db = CurrentDb
Set rs = db.OpenRecordset(TBL_TOOLBAR)
Do While Not rs.EOF
DoCmd.ShowToolbar rs("Toolbar"), acToolbarNo
rs.MoveNext
Loop
End Sub
' --------------------------------------------------------
' Reaffiche les barres de menu/outils
' --------------------------------------------------------
Sub ShowMenus()
Dim db As DAO.Database, rs As DAO.Recordset
Set db = CurrentDb
Set rs = db.OpenRecordset(TBL_TOOLBAR)
Do While Not rs.EOF
DoCmd.ShowToolbar rs("Toolbar"), acToolbarWhereApprop
rs.MoveNext
Loop
End Sub
' --------------------------------------------------------
' Recense les barres de menu/outils visibles
' dans la table dont le nom est donné par
' la constante globale TBL_TOOLBAR
' --------------------------------------------------------
Sub EnumVisibleToolBars()
Dim db As DAO.Database, rs As DAO.Recordset
Dim oCmdBar As Object
Dim cntBars As Long, arrBars() As String
Dim l As Long
cntBars = -1
For Each oCmdBar In Access.Application.CommandBars
If oCmdBar.Visible = True And oCmdBar.Enabled = True Then
cntBars = cntBars + 1
ReDim Preserve arrBars(0 To cntBars)
arrBars(cntBars) = oCmdBar.Name
End If
Next
If cntBars > -1 Then
Set db = CurrentDb
db.Execute "DELETE FROM " & TBL_TOOLBAR
Set rs = db.OpenRecordset(TBL_TOOLBAR)
For l = 0 To cntBars
rs.AddNew
rs("Toolbar") = arrBars(l)
rs.Update
Next
rs.Close
End If
End Sub |
Partager