Visual Basic 4 Unleashed/Visual_Basic_4_Unleashed_SAMS_Publishing_1995.iso/source/chap27/frm327.frm

Visual Basic Form | 1995-09-28 | 8.1 KB | 279 lines

VERSION 4.00
Begin VB.Form form3
   Caption         =   "Bound Form"
   ClientHeight    =   4785
   ClientLeft      =   1980
   ClientTop       =   1860
   ClientWidth     =   6690
   Height          =   5190
   Left            =   1920
   LinkTopic       =   "Form1"
   ScaleHeight     =   4785
   ScaleWidth      =   6690
   Top             =   1515
   Width           =   6810
   Begin VB.CommandButton cmdadd
      Caption         =   "&Add"
      Height          =   295
      Left            =   3780
      TabIndex        =   23
      Top             =   4080
      Width           =   1215
   End
   Begin VB.CommandButton cmdrefresh
      Caption         =   "&Refresh"
      Height          =   295
      Left            =   2400
      TabIndex        =   22
      Top             =   4080
      Width           =   1215
   End
   Begin VB.CommandButton cmdupdate
      Caption         =   "&Update "
      Height          =   295
      Left            =   900
      TabIndex        =   21
      Top             =   4080
      Width           =   1215
   End
   Begin VB.ComboBox comfield
      Height          =   315
      Left            =   1560
      Style           =   2  'Dropdown List
      TabIndex        =   19
      Top             =   3120
      Visible         =   0   'False
      Width           =   1875
   End
   Begin VB.TextBox txtcomments
      DataField       =   "Comments"
      DataSource      =   "Data1"
      Height          =   285
      Left            =   1560
      MultiLine       =   -1  'True
      TabIndex        =   17
      Top             =   2280
      Width           =   4635
   End
   Begin VB.TextBox txtnotes
      DataField       =   "Notes"
      DataSource      =   "Data1"
      Height          =   285
      Left            =   1560
      MultiLine       =   -1  'True
      TabIndex        =   15
      Top             =   2700
      Width           =   4635
   End
   Begin VB.TextBox txtdescription
      DataField       =   "Description"
      DataSource      =   "Data1"
      Height          =   285
      Left            =   1560
      MultiLine       =   -1  'True
      TabIndex        =   13
      Top             =   1860
      Width           =   4635
   End
   Begin VB.TextBox txtpubid
      DataField       =   "PubID"
      DataSource      =   "Data1"
      Height          =   285
      Left            =   1560
      MultiLine       =   -1  'True
      TabIndex        =   11
      Top             =   180
      Width           =   855
   End
   Begin VB.TextBox txtisbn
      DataField       =   "ISBN"
      DataSource      =   "Data1"
      Height          =   285
      Left            =   1560
      MultiLine       =   -1  'True
      TabIndex        =   9
      Top             =   600
      Width           =   1635
   End
   Begin VB.TextBox txtyear
      DataField       =   "Year Published"
      DataSource      =   "Data1"
      Height          =   315
      Left            =   5040
      MultiLine       =   -1  'True
      TabIndex        =   7
      Top             =   180
      Width           =   855
   End
   Begin VB.CheckBox chkeof
      Caption         =   "EOF Reached"
      Enabled         =   0   'False
      Height          =   295
      Left            =   2340
      TabIndex        =   6
      Top             =   3660
      Width           =   1875
   End
   Begin VB.CheckBox chkbof
      Caption         =   "BOF Reached"
      Enabled         =   0   'False
      Height          =   295
      Left            =   180
      TabIndex        =   5
      Top             =   3660
      Width           =   1875
   End
   Begin VB.CommandButton cmdexit
      Caption         =   "E&xit"
      Height          =   295
      Left            =   5220
      TabIndex        =   4
      Top             =   4080
      Width           =   1215
   End
   Begin VB.Data Data1
      Align           =   1  'Align Top
      BOFAction       =   1  'BOF
      Caption         =   "Data Control"
      Connect         =   "Access"
      DatabaseName    =   "biblio.mdb"
      EOFAction       =   2  'Add New
      Exclusive       =   0   'False
      Height          =   300
      Left            =   0
      Options         =   0
      ReadOnly        =   -1  'True
      RecordsetType   =   1  'Dynaset
      RecordSource    =   ""
      Top             =   0
      Visible         =   0   'False
      Width           =   6690
   End
   Begin VB.TextBox txtsubject
      DataField       =   "Subject"
      DataSource      =   "Data1"
      Height          =   285
      Left            =   1560
      MultiLine       =   -1  'True
      TabIndex        =   3
      Top             =   1440
      Width           =   4635
   End
   Begin VB.TextBox txttitle
      DataField       =   "Title"
      DataSource      =   "Data1"
      Height          =   285
      Left            =   1560
      MultiLine       =   -1  'True
      TabIndex        =   2
      Top             =   1020
      Width           =   4635
   End
   Begin VB.Label Label1
      Caption         =   "Order by"
      Height          =   285
      Index           =   7
      Left            =   180
      TabIndex        =   20
      Top             =   3120
      Visible         =   0   'False
      Width           =   1215
   End
   Begin VB.Label Label1
      Caption         =   "Comments"
      Height          =   285
      Index           =   6
      Left            =   180
      TabIndex        =   18
      Top             =   2280
      Width           =   1215
   End
   Begin VB.Label Label1
      Caption         =   "Notes"
      Height          =   285
      Index           =   5
      Left            =   180
      TabIndex        =   16
      Top             =   2700
      Width           =   1215
   End
   Begin VB.Label Label1
      Caption         =   "Description"
      Height          =   285
      Index           =   4
      Left            =   180
      TabIndex        =   14
      Top             =   1860
      Width           =   1215
   End
   Begin VB.Label Label1
      Caption         =   "Pub. ID"
      Height          =   285
      Index           =   3
      Left            =   180
      TabIndex        =   12
      Top             =   180
      Width           =   1215
   End
   Begin VB.Label Label1
      Caption         =   "ISBN"
      Height          =   285
      Index           =   2
      Left            =   180
      TabIndex        =   10
      Top             =   600
      Width           =   1215
   End
   Begin VB.Label Label1
      Caption         =   "Year Published"
      Height          =   285
      Index           =   1
      Left            =   3660
      TabIndex        =   8
      Top             =   180
      Width           =   1215
   End
   Begin VB.Label Label2
      Caption         =   "Subject"
      Height          =   285
      Left            =   180
      TabIndex        =   1
      Top             =   1440
      Width           =   1215
   End
   Begin VB.Label Label1
      Caption         =   "Title"
      Height          =   285
      Index           =   0
      Left            =   180
      TabIndex        =   0
      Top             =   1020
      Width           =   1215
   End
Attribute VB_Name = "form3"
Attribute VB_Creatable = False
Attribute VB_Exposed = False
Option Explicit
Private Sub cmdExit_Click()
Unload Me
Set form3 = Nothing
End Sub
Private Sub Data1_Reposition()
If Data1.Recordset.BOF = True Then
    chkbof.Value = vbChecked
    chkbof.Value = vbUnchecked
End If
If Data1.Recordset.EOF = True Then
    chkeof.Value = vbChecked
    chkeof.Value = vbUnchecked
End If
End Sub
Private Sub Form_Load()
    Dim filepath As String
    filepath = "\source\chp27\"
    Data1.DatabaseName = filepath & "biblio.mdb"
    Data1.RecordSource = "select * From titles order by pubid ,[year published]"
    Data1.Refresh
    Data1.Align = 2
End Sub