frm库存修改.frm

这是一个啤酒销售系统的软件

VERSION 5.00
Begin VB.Form frm库存修改 
   Caption         =   "库存"
   ClientHeight    =   3510
   ClientLeft      =   1110
   ClientTop       =   345
   ClientWidth     =   5520
   LinkTopic       =   "Form2"
   MDIChild        =   -1  'True
   ScaleHeight     =   3510
   ScaleWidth      =   5520
   Begin VB.CommandButton C4 
      Caption         =   "最后一个"
      Height          =   375
      Left            =   4440
      TabIndex        =   12
      Top             =   1560
      Width           =   975
   End
   Begin VB.CommandButton C3 
      Caption         =   "第一个"
      Height          =   375
      Left            =   4440
      TabIndex        =   11
      Top             =   1200
      Width           =   975
   End
   Begin VB.CommandButton C2 
      Caption         =   "下一个"
      Height          =   375
      Left            =   4440
      TabIndex        =   10
      Top             =   840
      Width           =   975
   End
   Begin VB.CommandButton C1 
      Caption         =   "上一个"
      Height          =   375
      Left            =   4440
      TabIndex        =   9
      Top             =   480
      Width           =   975
   End
   Begin VB.CommandButton cmdClose 
      Caption         =   "关闭(&C)"
      Height          =   300
      Left            =   4440
      TabIndex        =   8
      Top             =   2400
      Width           =   975
   End
   Begin VB.CommandButton cmdUpdate 
      Caption         =   "更新(&U)"
      Height          =   300
      Left            =   3240
      TabIndex        =   7
      Top             =   2505
      Width           =   975
   End
   Begin VB.CommandButton cmdRefresh 
      Caption         =   "刷新(&R)"
      Height          =   300
      Left            =   2160
      TabIndex        =   6
      Top             =   2505
      Width           =   975
   End
   Begin VB.CommandButton cmdDelete 
      Caption         =   "删除(&D)"
      Height          =   300
      Left            =   1080
      TabIndex        =   5
      Top             =   2505
      Width           =   975
   End
   Begin VB.CommandButton cmdAdd 
      Caption         =   "添加(&A)"
      Height          =   300
      Left            =   0
      TabIndex        =   4
      Top             =   2505
      Width           =   975
   End
   Begin VB.Data Data1 
      Align           =   2  'Align Bottom
      Connect         =   "Access"
      DatabaseName    =   "C:\啤酒数据库\BEER.MDB"
      DefaultCursorType=   0  '缺省游标
      DefaultType     =   2  '使用 ODBC
      Exclusive       =   0   'False
      Height          =   345
      Left            =   0
      Options         =   0
      ReadOnly        =   0   'False
      RecordsetType   =   1  'Dynaset
      RecordSource    =   "库存"
      Top             =   3165
      Visible         =   0   'False
      Width           =   5520
   End
   Begin VB.TextBox txtFields 
      DataField       =   "数量"
      DataSource      =   "Data1"
      Height          =   405
      Index           =   1
      Left            =   1200
      TabIndex        =   3
      Top             =   1320
      Width           =   2775
   End
   Begin VB.TextBox txtFields 
      DataField       =   "序列号"
      DataSource      =   "Data1"
      Height          =   405
      Index           =   0
      Left            =   1200
      TabIndex        =   1
      Top             =   600
      Width           =   2775
   End
   Begin VB.Label lblLabels 
      Caption         =   "数量:"
      Height          =   255
      Index           =   1
      Left            =   480
      TabIndex        =   2
      Top             =   1440
      Width           =   975
   End
   Begin VB.Label lblLabels 
      Caption         =   "序列号:"
      Height          =   255
      Index           =   0
      Left            =   480
      TabIndex        =   0
      Top             =   720
      Width           =   975
   End
End
Attribute VB_Name = "frm库存修改"
Attribute VB_GlobalNameSpace = False
Attribute VB_Creatable = False
Attribute VB_PredeclaredId = True
Attribute VB_Exposed = False
Private Sub cmdAdd_Click()
  Data1.Recordset.AddNew
End Sub

Private Sub cmdDelete_Click()
  '如果删除记录集的最后一条记录
  '记录或记录集中唯一的记录
  Data1.Recordset.Delete
  Data1.Recordset.MoveNext
End Sub

Private Sub cmdRefresh_Click()
  '这仅对多用户应用程序才是需要的
  Data1.Refresh
End Sub

Private Sub cmdUpdate_Click()
  Data1.UpdateRecord
  Data1.Recordset.Bookmark = Data1.Recordset.LastModified
End Sub

Private Sub cmdClose_Click()
  Unload Me
End Sub
Private Sub c1_Click()
C2.Enabled = True
C4.Enabled = True
If Data1.Recordset.BOF Then
C1.Enabled = False
C3.Enabled = False
C2.SetFocus
Else
Data1.Recordset.MovePrevious
End If
End Sub

Private Sub c2_Click()
C1.Enabled = True
C3.Enabled = True
If Data1.Recordset.EOF Then
C2.Enabled = False
C4.Enabled = False
C1.SetFocus
Else
Data1.Recordset.MoveNext
End If
End Sub

Private Sub c3_Click()
C2.Enabled = True
C4.Enabled = True
Data1.Recordset.MoveFirst
C1.Enabled = False
C3.Enabled = False
End Sub

Private Sub c4_Click()
C1.Enabled = True
C3.Enabled = True
Data1.Recordset.MoveLast
C2.Enabled = False
C4.Enabled = False
End Sub

Private Sub Data1_Error(DataErr As Integer, Response As Integer)
  '这就是放置错误处理代码的地方
  '如果想忽略错误，注释掉下一行代码
  '如果想捕捉错误，在这里添加错误处理代码
  MsgBox "数据错误事件命中错误：" & Error$(DataErr)
  Response = 0  '忽略错误
End Sub

Private Sub Data1_Reposition()
  Screen.MousePointer = vbDefault
  On Error Resume Next
  '这将显示当前记录位置
  '为动态集和快照
  Data1.Caption = "记录：" & (Data1.Recordset.AbsolutePosition + 1)
  '对于 Table 对象，当记录集创建后并使用下面的行时，
  '必须设置 Index 属性
  'Data1.Caption = "记录：" & (Data1.Recordset.RecordCount * (Data1.Recordset.PercentPosition * 0.01)) + 1
End Sub

Private Sub Data1_Validate(Action As Integer, Save As Integer)
  '这是放置验证代码的地方
  '当下面的动作发生时，调用这个事件
  Select Case Action
    Case vbDataActionMoveFirst
    Case vbDataActionMovePrevious
    Case vbDataActionMoveNext
    Case vbDataActionMoveLast
    Case vbDataActionAddNew
    Case vbDataActionUpdate
    Case vbDataActionDelete
    Case vbDataActionFind
    Case vbDataActionBookmark
    Case vbDataActionClose
  End Select
  Screen.MousePointer = vbHourglass
End Sub