publishers.frm

《VB6数据库开发指南》所有的例程的源码

VERSION 5.00
Begin VB.Form frmSelectPublisher 
   BackColor       =   &H00C0C0C0&
   Caption         =   "Chapter 5.7 Example - Publishers"
   ClientHeight    =   2715
   ClientLeft      =   1095
   ClientTop       =   1530
   ClientWidth     =   4470
   BeginProperty Font 
      Name            =   "MS Sans Serif"
      Size            =   8.25
      Charset         =   0
      Weight          =   700
      Underline       =   0   'False
      Italic          =   0   'False
      Strikethrough   =   0   'False
   EndProperty
   LinkTopic       =   "Form2"
   PaletteMode     =   1  'UseZOrder
   ScaleHeight     =   2715
   ScaleWidth      =   4470
   Begin VB.CommandButton cmdCancel 
      Cancel          =   -1  'True
      Caption         =   "Cancel"
      BeginProperty Font 
         Name            =   "MS Sans Serif"
         Size            =   8.25
         Charset         =   0
         Weight          =   400
         Underline       =   0   'False
         Italic          =   0   'False
         Strikethrough   =   0   'False
      EndProperty
      Height          =   495
      Left            =   3120
      TabIndex        =   2
      Top             =   2100
      Width           =   1215
   End
   Begin VB.ListBox lstPublishers 
      BeginProperty Font 
         Name            =   "MS Sans Serif"
         Size            =   8.25
         Charset         =   0
         Weight          =   400
         Underline       =   0   'False
         Italic          =   0   'False
         Strikethrough   =   0   'False
      EndProperty
      Height          =   1815
      Left            =   120
      Sorted          =   -1  'True
      TabIndex        =   1
      Top             =   120
      Width           =   4215
   End
   Begin VB.CommandButton cmdOK 
      Caption         =   "OK"
      Default         =   -1  'True
      BeginProperty Font 
         Name            =   "MS Sans Serif"
         Size            =   8.25
         Charset         =   0
         Weight          =   400
         Underline       =   0   'False
         Italic          =   0   'False
         Strikethrough   =   0   'False
      EndProperty
      Height          =   495
      Left            =   1740
      TabIndex        =   0
      Top             =   2100
      Width           =   1215
   End
End
Attribute VB_Name = "frmSelectPublisher"
Attribute VB_GlobalNameSpace = False
Attribute VB_Creatable = False
Attribute VB_PredeclaredId = True
Attribute VB_Exposed = False
Option Explicit

Const BIBLIO_PATH = "D:\Program Files\Microsoft Visual Studio\VB6\Biblio.MDB"

Private Sub Form_Load()
    Dim dbfTemp As Database, recTemp As Recordset
    Dim strSQL As String
    
    On Error GoTo LoadError
        Set dbfTemp = Workspaces(0).OpenDatabase(BIBLIO_PATH)
        strSQL = "SELECT [PubID], [Company Name] FROM [Publishers]"
        Set recTemp = dbfTemp.OpenRecordset(strSQL)
        
        If recTemp.RecordCount Then
            recTemp.MoveFirst
            Do Until recTemp.EOF
                If Not IsNull(recTemp![Company Name]) Then
                    lstPublishers.AddItem recTemp![Company Name]
                Else
                    lstPublishers.AddItem ""
                End If
                lstPublishers.ItemData(lstPublishers.NewIndex) = recTemp![PubID]
                recTemp.MoveNext
            Loop
        Else
            MsgBox "There are no publishers in the database.", vbCritical
            End
        End If
    On Error GoTo 0
Exit Sub

LoadError:
    MsgBox Err.Description, vbCritical
    End
End Sub

Private Sub cmdOK_Click()
    If lstPublishers.ListIndex > -1 Then
        frmMain.SelectedPubID = lstPublishers.ItemData(lstPublishers.ListIndex)
        Me.Hide
    Else
        MsgBox "You have not selected a publisher", vbExclamation
    End If
End Sub
Private Sub List1_DblClick()
    cmdOK_Click
End Sub
Private Sub cmdCancel_Click()
    frmMain.SelectedPubID = 0
    Me.Hide
End Sub