frmallreaders.frm

实现某班级的图书信息管理

VERSION 5.00
Object = "{00028C01-0000-0000-0000-000000000046}#1.0#0"; "DBGRID32.OCX"
Begin VB.Form FrmAllReaders 
   Caption         =   "读者信息浏览"
   ClientHeight    =   2055
   ClientLeft      =   60
   ClientTop       =   345
   ClientWidth     =   5415
   LinkTopic       =   "Form1"
   MDIChild        =   -1  'True
   ScaleHeight     =   2055
   ScaleWidth      =   5415
   Begin VB.Data datAllreaders 
      Caption         =   "Data1"
      Connect         =   "Access 2000;"
      DatabaseName    =   "D:\Documents and Settings\Administrator\桌面\LibraryDataBase\LibraryDB.mdb"
      DefaultCursorType=   0  'DefaultCursor
      DefaultType     =   2  'UseODBC
      Exclusive       =   0   'False
      Height          =   375
      Left            =   1320
      Options         =   0
      ReadOnly        =   0   'False
      RecordsetType   =   1  'Dynaset
      RecordSource    =   "ReaderMessage"
      Top             =   3600
      Visible         =   0   'False
      Width           =   2055
   End
   Begin MSDBGrid.DBGrid DBGridreaders 
      Bindings        =   "FrmAllReaders.frx":0000
      Height          =   2055
      Left            =   0
      OleObjectBlob   =   "FrmAllReaders.frx":001C
      TabIndex        =   0
      Top             =   0
      Width           =   5415
   End
End
Attribute VB_Name = "FrmAllReaders"
Attribute VB_GlobalNameSpace = False
Attribute VB_Creatable = False
Attribute VB_PredeclaredId = True
Attribute VB_Exposed = False

Private Sub DBGridreaders_RowColChange(LastRow As Variant, ByVal LastCol As Integer)

    FrmRegister.cmbSelectReader = DBGridreaders.Columns(0)
    FrmRegister.TxtReaderName = DBGridreaders.Columns(1)
    
End Sub

 '************************************************************************
     '本窗本用于浏览读者信息
 '*************************************************************************Private Sub Form_Activate()

    


Private Sub Form_Load()
    
    FrmAllReaders.Height = 2550
    FrmAllReaders.Width = 5505
    
    Me.Top = 0
    Me.Left = 0

    InitializeDataPath
    
    datAllreaders.DatabaseName = DataPath '取得BookMessage的数据路径
    datAllreaders.RecordSource = "SELECT readermessage.readerindex,readername,count(readermessage.readerindex) as btime,age,sex,duty " _
    & " from readermessage left join borrowmessage on readermessage.readerindex = borrowmessage.readerindex" _
    & " group by readermessage.readerindex,readername,age,sex,duty "
    datAllreaders.Refresh
End Sub

Private Sub Form_Resize()
    
    DBGridreaders.Height = FrmAllReaders.ScaleHeight
    DBGridreaders.Width = FrmAllReaders.ScaleWidth
    
End Sub