Visual Basic Controls/Visual Basic Controls.iso/vbcontrol/gridex/frmtable.frm

Visual Basic Form | 1998-01-03 | 8.1 KB | 257 lines

VERSION 5.00
Object = "{F9043C88-F6F2-101A-A3C9-08002B2F49FB}#1.1#0"; "COMDLG32.OCX"
Begin VB.Form frmTableview
   BorderStyle     =   3  'Fixed Dialog
   Caption         =   "Format Table View"
   ClientHeight    =   3090
   ClientLeft      =   930
   ClientTop       =   2070
   ClientWidth     =   7185
   BeginProperty Font
      Name            =   "Tahoma"
      Size            =   8.25
      Charset         =   0
      Weight          =   400
      Underline       =   0   'False
      Italic          =   0   'False
      Strikethrough   =   0   'False
   EndProperty
   Icon            =   "frmTableview.frx":0000
   LinkTopic       =   "Form1"
   MaxButton       =   0   'False
   MinButton       =   0   'False
   ScaleHeight     =   3090
   ScaleWidth      =   7185
   ShowInTaskbar   =   0   'False
   StartUpPosition =   2  'CenterScreen
   Begin MSComDlg.CommonDialog cdlFont
      Left            =   6630
      Top             =   2790
      _ExtentX        =   847
      _ExtentY        =   847
      _Version        =   327681
   End
   Begin VB.CommandButton cmdCancel
      Caption         =   "Cancel"
      Height          =   375
      Left            =   6060
      TabIndex        =   13
      Top             =   630
      Width           =   1035
   End
   Begin VB.CommandButton cmdOK
      Caption         =   "OK"
      Height          =   330
      Left            =   6075
      TabIndex        =   12
      Top             =   240
      Width           =   1020
   End
   Begin VB.Frame fraSet
      Caption         =   "Grid Lines"
      Height          =   765
      Index           =   2
      Left            =   120
      TabIndex        =   2
      Top             =   2145
      Width           =   5700
      Begin VB.ComboBox cboGridlines
         Height          =   315
         ItemData        =   "frmTableview.frx":000C
         Left            =   1470
         List            =   "frmTableview.frx":0017
         Style           =   2  'Dropdown List
         TabIndex        =   11
         Top             =   210
         Width           =   1830
      End
      Begin VB.CheckBox chkgrouphead
         Caption         =   "Shade group headings"
         Height          =   210
         Left            =   3480
         TabIndex        =   10
         Top             =   270
         Value           =   1  'Checked
         Width           =   1965
      End
      Begin VB.Label lblGridlines
         Caption         =   "Grid line style:"
         Height          =   285
         Index           =   0
         Left            =   180
         TabIndex        =   9
         Top             =   315
         Width           =   2325
      End
   End
   Begin VB.Frame fraSet
      Caption         =   "Rows"
      Height          =   885
      Index           =   1
      Left            =   120
      TabIndex        =   1
      Top             =   1125
      Width           =   5700
      Begin VB.CheckBox chknewrow
         Caption         =   "Show ""new item"" row"
         Height          =   210
         Left            =   3465
         TabIndex        =   8
         Top             =   585
         Width           =   1890
      End
      Begin VB.CheckBox chkAllowed
         Caption         =   "Allow in-cell editing"
         Height          =   210
         Left            =   3465
         TabIndex        =   7
         Top             =   255
         Value           =   1  'Checked
         Width           =   1890
      End
      Begin VB.CommandButton cmdfont
         Caption         =   "Font..."
         Height          =   345
         Index           =   1
         Left            =   225
         TabIndex        =   4
         Top             =   330
         Width           =   1080
      End
      Begin VB.Label lblcurrfont
         BorderStyle     =   1  'Fixed Single
         Caption         =   "Current font"
         Height          =   285
         Index           =   1
         Left            =   1470
         TabIndex        =   6
         Top             =   345
         Width           =   1845
      End
   End
   Begin VB.Frame fraSet
      Caption         =   "Column headings"
      Height          =   885
      Index           =   0
      Left            =   120
      TabIndex        =   0
      Top             =   120
      Width           =   5700
      Begin VB.CommandButton cmdfont
         Caption         =   "Font..."
         Height          =   345
         Index           =   0
         Left            =   210
         TabIndex        =   3
         Top             =   345
         Width           =   1080
      End
      Begin VB.Label lblcurrfont
         BorderStyle     =   1  'Fixed Single
         Caption         =   "Current font"
         Height          =   285
         Index           =   0
         Left            =   1455
         TabIndex        =   5
         Top             =   360
         Width           =   1845
      End
   End
Attribute VB_Name = "frmTableview"
Attribute VB_GlobalNameSpace = False
Attribute VB_Creatable = False
Attribute VB_PredeclaredId = True
Attribute VB_Exposed = False
Option Explicit
Dim m_OK As Boolean
Dim f(0 To 1) As Font
Dim m_Changed As Boolean
Dim m_Colors(0 To 1) As Long
Public Sub FormatGrid(gr As GridEX)
    m_OK = False
    Set f(0) = gr.ColumnHeaderFont
    Set f(1) = gr.Font
    m_Colors(0) = gr.ForeColorHeader
    m_Colors(1) = gr.ForeColor
    SetFontCaptions
    chknewrow.Value = IIf(gr.AllowAddNew, vbChecked, vbUnchecked)
    chkAllowed.Value = IIf(gr.AllowEdit, vbChecked, vbUnchecked)
    If gr.GridLines Then
        cboGridlines.ListIndex = 0
    Else
        cboGridlines.ListIndex = 1
    End If
    If gr.BackColorRowGroup = vbButtonFace Then
        chkgrouphead.Value = vbChecked
    Else
        chkgrouphead.Value = vbUnchecked
    End If
    Show 1
    If m_OK Then
        Set gr.ColumnHeaderFont = f(0)
        Set gr.Font = f(1)
        gr.ForeColorHeader = m_Colors(0)
        gr.ForeColor = m_Colors(1)
        gr.AllowEdit = (chkAllowed.Value = vbChecked)
        frmMain.AllowAddNew (chknewrow.Value = vbChecked)
        gr.GridLines = cboGridlines.ItemData(cboGridlines.ListIndex)
        gr.BackColorRowGroup = IIf(chkgrouphead.Value = vbChecked, vbButtonFace, vbWindowBackground)
    End If
    Unload Me
End Sub
Private Sub SetFontCaptions()
Dim i As Integer
    For i = 0 To 1
        With f(i)
            lblcurrfont(i).FontBold = .Bold
            lblcurrfont(i).FontItalic = .Italic
            lblcurrfont(i).FontName = .Name
            lblcurrfont(i).FontStrikethru = .Strikethrough
            lblcurrfont(i).FontUnderline = .Underline
            lblcurrfont(i).Caption = CInt(f(i).Size) & " pt. " & f(i).Name
        End With
        lblcurrfont(i).ForeColor = m_Colors(i)
    Next
End Sub
Private Sub cmdCancel_Click()
    Hide
End Sub
Private Sub cmdfont_Click(Index As Integer)
    cdlFont.CancelError = True
    On Error GoTo cmdFont_exit
    With cdlFont
        .FontBold = f(Index).Bold
        .FontItalic = f(Index).Italic
        .FontName = f(Index).Name
        .FontSize = f(Index).Size
        .FontStrikethru = f(Index).Strikethrough
        .FontUnderline = f(Index).Underline
        .Color = m_Colors(Index)
        .Flags = cdlCFEffects Or cdlCFForceFontExist Or cdlCFScreenFonts
        .ShowFont
        f(Index).Bold = .FontBold
        f(Index).Italic = .FontItalic
        f(Index).Name = .FontName
        f(Index).Size = .FontSize
        f(Index).Strikethrough = .FontStrikethru
        f(Index).Underline = .FontUnderline
        m_Colors(Index) = .Color
        SetFontCaptions
        m_Changed = True
    End With
cmdFont_exit:
    Exit Sub
End Sub
Private Sub cmdOK_Click()
    m_OK = True
    Hide
End Sub
Private Sub chkAllowed_Click()
    If chkAllowed.Value = vbChecked Then
        chknewrow.Enabled = True
    Else
        chknewrow.Enabled = False
        chknewrow.Value = vbUnchecked
    End If
End Sub