' PART 1 of 2
Option Explicit
'Behind ThisOutlookSession
Public WithEvents oMnuTrackerSub0 As Office.CommandBarButton
Public WithEvents oMnuTrackerSub1 As Office.CommandBarButton
Public WithEvents oMnuTrackerSub2 As Office.CommandBarButton
Public WithEvents oMnuTrackerSub3 As Office.CommandBarButton
Public WithEvents oMnuTrackerSub4 As Office.CommandBarButton
Public WithEvents oMnuTrackerSub5 As Office.CommandBarButton
Public WithEvents oMnuTrackerSub6 As Office.CommandBarButton
Public WithEvents oMnuTrackerSub7 As Office.CommandBarButton
Public WithEvents oMnuTrackerSub8 As Office.CommandBarButton
Public WithEvents oMnuTrackerSub9 As Office.CommandBarButton
Public WithEvents oMnuTrackerSub10 As Office.CommandBarButton
Public WithEvents oMnuTrackerSub11 As Office.CommandBarButton
Public WithEvents oMnuTrackerSub12 As Office.CommandBarButton
Public WithEvents oMnuTrackerSub13 As Office.CommandBarButton
Public WithEvents oMnuTrackerSub14 As Office.CommandBarButton
Public WithEvents oMnuTrackerAdd As Office.CommandBarButton
Public arInfo_Close As Label
Public connectionString As String
Public quitting As Boolean
Private Sub SyncMnuTracker1Button(btn As Office.CommandBarButton)
Set oMnuTrackerSub1 = btn
If btn Is Nothing Then
MsgBox "Sync. of '" & btn.Caption & "' button event failed!", vbCritical + vbOKOnly
End If
End Sub
Public Sub Application_MAPILogonComplete()
Dim arStatus As Office.CommandBar
Dim CBtxt_arStatus As Office.CommandBarControl
Dim arMenu As Office.CommandBarPopup
Dim currentMenuBar As Office.CommandBar
Dim oCBmnuTools As Office.CommandBarPopup
Dim oCBmnuAddToTrackerMain As Office.CommandBarPopup
Dim oCBButtons(100) As Controls
Dim oCBmnuTrackerAdd As Office.CommandBarButton
'<ADD A MENU ITEM>
Set currentMenuBar = Application.ActiveExplorer.CommandBars.ActiveMenuBar
currentMenuBar.Reset
Set arMenu = currentMenuBar.Controls.Add(msoControlPopup, 1)
Set oCBmnuAddToTrackerMain = arMenu.Controls.Add(msoControlPopup, 1)
Set oCBmnuTrackerAdd = arMenu.Controls.Add(msoControlButton, 1)
Set arStatus = Application.ActiveExplorer.CommandBars(Application.ActiveExplorer.CommandBars.Count)
If Not arStatus.name = "AR Tracker Status ToolBar" Then
Set arStatus = Application.ActiveExplorer.CommandBars.Add("AR Tracker Status ToolBar", msoBarTop, False, True)
Set CBtxt_arStatus = arStatus.Controls.Add(1)
End If
Set CBtxt_arStatus = arStatus.FindControl(1)
'Set oCBmnuTools = Application.ActiveExplorer.CommandBars("Menu Bar").Controls("&Tools")
'Set oCBmnuAddToTrackerMain = Application.ActiveExplorer.CommandBars("Menu Bar").FindControl(msoControlPopup, 1, "888", True, True)
''oCBmnuTools.Reset
'If TypeName(oCBmnuAddToTrackerMain) = "Nothing" Then
' Set oCBmnuAddToTrackerMain = oCBmnuTools.Controls.Add(msoControlPopup, 1)
'End If
'Set oCBmnuTracker1 = oCBmnuAddToTrackerMain.Controls.Add(msoControlButton, 1, "888", , False)
With Application.ActiveExplorer.CommandBars("AR Tracker Status ToolBar")
.Left = 200
.Visible = True
End With
With arMenu
.BeginGroup = True
.Caption = "A&R Tracker"
.Enabled = True
.Visible = True
End With
With oCBmnuAddToTrackerMain
.BeginGroup = True
.Caption = "Add to AR Tracker"
.Enabled = True
'.Style = msoControlCustom
'.Tag = "888"
.Visible = True
End With
With oCBmnuTrackerAdd
.BeginGroup = True
.Caption = "Add Database to this list..."
.Enabled = True
.Style = msoControlCustom
.Visible = True
End With
With CBtxt_arStatus
.BeginGroup = False
.Width = 2000
.Caption = "AR Tracker Status: Ready"
.Tag = "AR Tracker Status ToolBar"
.Enabled = True
.Visible = True
End With
If Not restarting Then
'Set oMnuTrackerSub1 = oCBmnuTracker1 ' Set buttons to have WithEvents
Set oMnuTrackerAdd = oCBmnuTrackerAdd
Call Populate_CB_Array(oCBmnuAddToTrackerMain)
'Call SyncMnuTracker1Button(oCBmnuTracker1)
'</ADD A MENU ITEM>
End If
End Sub
Private Sub oMnuTrackerAdd_Click(ByVal Ctrl As Office.CommandBarButton, CancelDefault As Boolean)
DBadd.Show
End Sub
Private Sub oMnuTrackerSub0_Click(ByVal Ctrl As Office.CommandBarButton, CancelDefault As Boolean)
Call myClick_Event(Ctrl)
End Sub
Private Sub oMnuTrackerSub1_Click(ByVal Ctrl As Office.CommandBarButton, CancelDefault As Boolean)
Call myClick_Event(Ctrl)
End Sub
Private Sub oMnuTrackerSub2_Click(ByVal Ctrl As Office.CommandBarButton, CancelDefault As Boolean)
Call myClick_Event(Ctrl)
End Sub
Private Sub oMnuTrackerSub3_Click(ByVal Ctrl As Office.CommandBarButton, CancelDefault As Boolean)
Call myClick_Event(Ctrl)
End Sub
Private Sub oMnuTrackerSub4_Click(ByVal Ctrl As Office.CommandBarButton, CancelDefault As Boolean)
Call myClick_Event(Ctrl)
End Sub
Private Sub oMnuTrackerSub5_Click(ByVal Ctrl As Office.CommandBarButton, CancelDefault As Boolean)
Call myClick_Event(Ctrl)
End Sub
Private Sub oMnuTrackerSub6_Click(ByVal Ctrl As Office.CommandBarButton, CancelDefault As Boolean)
Call myClick_Event(Ctrl)
End Sub
Private Sub oMnuTrackerSub7_Click(ByVal Ctrl As Office.CommandBarButton, CancelDefault As Boolean)
Call myClick_Event(Ctrl)
End Sub
Private Sub oMnuTrackerSub8_Click(ByVal Ctrl As Office.CommandBarButton, CancelDefault As Boolean)
Call myClick_Event(Ctrl)
End Sub
Private Sub oMnuTrackerSub9_Click(ByVal Ctrl As Office.CommandBarButton, CancelDefault As Boolean)
Call myClick_Event(Ctrl)
End Sub
Private Sub oMnuTrackerSub10_Click(ByVal Ctrl As Office.CommandBarButton, CancelDefault As Boolean)
Call myClick_Event(Ctrl)
End Sub
Private Sub oMnuTrackerSub11_Click(ByVal Ctrl As Office.CommandBarButton, CancelDefault As Boolean)
Call myClick_Event(Ctrl)
End Sub
Private Sub oMnuTrackerSub12_Click(ByVal Ctrl As Office.CommandBarButton, CancelDefault As Boolean)
Call myClick_Event(Ctrl)
End Sub
Private Sub oMnuTrackerSub13_Click(ByVal Ctrl As Office.CommandBarButton, CancelDefault As Boolean)
Call myClick_Event(Ctrl)
End Sub
Private Sub oMnuTrackerSub14_Click(ByVal Ctrl As Office.CommandBarButton, CancelDefault As Boolean)
Call myClick_Event(Ctrl)
End Sub