Tools/WinSN5.0Ver.iso/PVb5.0/VB/SAMPLES/PGUIDE/MSFLEXGD/FFLEX.FRM

Visual Basic Form | 1997-01-20 | 6.0 KB | 195 lines

VERSION 5.00
Object = "{5E9E78A0-531B-11CF-91F6-C2863C385E30}#1.0#0"; "MSFLXGRD.OCX"
Object = "{F9043C88-F6F2-101A-A3C9-08002B2F49FB}#1.1#0"; "COMDLG32.OCX"
Begin VB.Form Form1
   BorderStyle     =   1  'Fixed Single
   Caption         =   "FlexGrid
   ClientHeight    =   3930
   ClientLeft      =   1740
   ClientTop       =   1770
   ClientWidth     =   8235
   LinkTopic       =   "Form1"
   MaxButton       =   0   'False
   MinButton       =   0   'False
   ScaleHeight     =   3930
   ScaleWidth      =   8235
   Begin VB.Data Data1
      Caption         =   "Data1"
      Connect         =   "Access"
      DatabaseName    =   "C:\Program Files\DevStudio\VB\Biblio.mdb"
      DefaultCursorType=   0  '
      DefaultType     =   2  '
 ODBC
      Exclusive       =   0   'False
      Height          =   375
      Left            =   6360
      Options         =   0
      ReadOnly        =   0   'False
      RecordsetType   =   2  'Snapshot
      RecordSource    =   "Title Author"
      Top             =   3240
      Visible         =   0   'False
      Width           =   1815
   End
   Begin MSFlexGridLib.MSFlexGrid flex
      Bindings        =   "fFlex.frx":0000
      DragIcon        =   "fFlex.frx":0010
      Height          =   3135
      Left            =   120
      TabIndex        =   0
      Top             =   600
      Width           =   6135
      _ExtentX        =   10821
      _ExtentY        =   5530
      Cols            =   3
      FixedCols       =   0
      BackColorFixed  =   0
      ForeColorFixed  =   16776960
      GridColor       =   -2147483630
      HighLight       =   2
      SelectionMode   =   1
      AllowUserResizing=   1
      BorderStyle     =   0
   End
   Begin MSComDlg.CommonDialog CommonDialog1
      Left            =   6480
      Top             =   2640
      _ExtentX        =   847
      _ExtentY        =   847
      FontSize        =   8.49966e-19
   End
   Begin VB.Image Image1
      Height          =   1440
      Left            =   3720
      Picture         =   "fFlex.frx":0452
      Stretch         =   -1  'True
      Top             =   600
      Width           =   4215
   End
   Begin VB.Label Label1
      Alignment       =   2  'Center
      BackColor       =   &H00FFFFFF&
      BorderStyle     =   1  'Fixed Single
      Caption         =   "
      ForeColor       =   &H00808080&
      Height          =   735
      Left            =   6600
      TabIndex        =   2
      Top             =   0
      Width           =   1335
   End
   Begin VB.Label lblTitle
      Alignment       =   2  'Center
      BackColor       =   &H00000000&
      Caption         =   "Flex
      BeginProperty Font
         Name            =   "
         Size            =   21.75
         Charset         =   134
         Weight          =   700
         Underline       =   0   'False
         Italic          =   0   'False
         Strikethrough   =   0   'False
      EndProperty
      ForeColor       =   &H000000FF&
      Height          =   615
      Left            =   120
      TabIndex        =   1
      Top             =   0
      Width           =   6135
   End
Attribute VB_Name = "Form1"
Attribute VB_GlobalNameSpace = False
Attribute VB_Creatable = False
Attribute VB_PredeclaredId = True
Attribute VB_Exposed = False
Option Explicit
Private Sub flex_DragDrop(Source As VB.Control, X As Single, Y As Single)
    If flex.Tag = "" Then Exit Sub
    flex.Redraw = False
    flex.ColPosition(Val(flex.Tag)) = flex.MouseCol
    DoSort
    flex.Redraw = True
End Sub
Private Sub flex_MouseDown(Button As Integer, Shift As Integer, X As Single, Y As Single)
    flex.Tag = ""
    If flex.MouseRow <> 0 Then Exit Sub
    flex.Tag = Str(flex.MouseCol)
    flex.Drag 1
End Sub
Private Sub Form_Load()
On Error GoTo FormLoad_Err

  Data1.DatabaseName = CurDir & "\biblio.mdb"
  Data1.Refresh
  flex.Redraw = False
  DoInitialSettings
  DoSql
  DoSort
  flex.Redraw = True
FormLoad_Exit:
Exit Sub
FormLoad_Err:
    '
 3024
    If Err = 3024 Then
        '
 CommonDialog
        With CommonDialog1
          .DialogTitle = "
 biblio.mdb
          .Filter = "(*.mdb)|*.mdb"
          .InitDir = CurDir
          .filename = "biblio.mdb"
          .Flags = cdlOFNExplorer Or cdlOFNFileMustExist Or cdlOFNPathMustExist
          .ShowOpen
          '
          If .filename <> "" Then
            '
 biblio.mdb
            If Right(UCase(.filename), Len("biblio.mdb")) = "BIBLIO.MDB" Then
            Data1.DatabaseName = .filename
            End If
            Resume
          Else
            Unload Me
          End If
        End With
    ElseIf Err <> 0 Then '
        MsgBox "
" & Err.Description
        End
    End If
    Resume FormLoad_Exit
End Sub
Sub DoInitialSettings()
    Dim i%
    flex.Row = 0
    flex.ColAlignment(0) = 7
    For i = 0 To flex.Cols - 1
        flex.Col = i
        flex.CellFontSize = 14
        flex.CellAlignment = 4

        flex.MergeCol(i) = True     '
        flex.ColWidth(i) = 2000     '
    Next i
    flex.MergeCells = flexMergeRestrictColumns
End Sub
Sub DoSql()
    Dim mysql$
    mysql$ = "SELECT "
    mysql = mysql & "Publishers.[Company Name], "
    mysql = mysql & "Authors.Author, "
    mysql = mysql & "Titles.Title "
    mysql = mysql & "FROM Authors INNER JOIN "
    mysql = mysql & "(Publishers INNER JOIN ([title author] INNER JOIN Titles ON [title author].ISBN = Titles.ISBN) ON Publishers.PubID = Titles.PubID) "
    mysql = mysql & "ON Authors.Au_ID = [title author].Au_ID "
    Data1.RecordSource = mysql
End Sub
Sub DoSort()
    flex.Col = 0
    flex.ColSel = flex.Cols - 1
    flex.Sort = 1 '
End Sub