?? 庫存查詢.frm
字號:
VERSION 5.00
Begin VB.Form main_kcgl_kccx
BackColor = &H00C0C0C0&
BorderStyle = 1 'Fixed Single
Caption = "庫存管理——【庫存查詢】"
ClientHeight = 4425
ClientLeft = 315
ClientTop = 2400
ClientWidth = 10170
Icon = "庫存查詢.frx":0000
LinkTopic = "Form1"
MaxButton = 0 'False
MinButton = 0 'False
ScaleHeight = 4425
ScaleWidth = 10170
StartUpPosition = 1 '所有者中心
Begin VB.Data Data1
Caption = "Data1"
Connect = "Access"
DatabaseName = "D:\VB數(shù)據(jù)庫開發(fā)實例解析\程序\醫(yī)藥進銷存管理系統(tǒng)\yyjxc.mdb"
DefaultCursorType= 0 '缺省游標
DefaultType = 2 '使用 ODBC
Exclusive = 0 'False
Height = 345
Left = -345
Options = 0
ReadOnly = 0 'False
RecordsetType = 1 'Dynaset
RecordSource = "kc"
Top = 915
Visible = 0 'False
Width = 1140
End
Begin VB.Frame Frame1
Caption = "請選擇查詢條件"
Height = 630
Left = 45
TabIndex = 4
Top = 60
Width = 6270
Begin VB.TextBox Text1
BackColor = &H80000000&
Height = 300
Left = 2085
TabIndex = 6
Top = 210
Width = 4125
End
Begin VB.ComboBox Combo1
Height = 300
ItemData = "庫存查詢.frx":000C
Left = 120
List = "庫存查詢.frx":000E
Style = 2 'Dropdown List
TabIndex = 5
Top = 210
Width = 1965
End
End
Begin VB.CommandButton Command1
Caption = "查詢"
Height = 435
Left = 6375
TabIndex = 2
Top = 195
Width = 1245
End
Begin VB.CommandButton Command3
Caption = "退出"
Height = 435
Left = 8880
TabIndex = 1
Top = 195
Width = 1245
End
Begin VB.CommandButton Command2
Caption = "刪除"
Height = 435
Left = 7620
TabIndex = 0
Top = 195
Width = 1245
End
Begin VB.PictureBox DBGrid1
Height = 3615
Left = 30
ScaleHeight = 3555
ScaleWidth = 10005
TabIndex = 3
Top = 735
Width = 10065
End
End
Attribute VB_Name = "main_kcgl_kccx"
Attribute VB_GlobalNameSpace = False
Attribute VB_Creatable = False
Attribute VB_PredeclaredId = True
Attribute VB_Exposed = False
Private Sub Form_Activate()
' 向combo1添加查詢項目列表
Combo1.AddItem ("商品名稱")
Combo1.AddItem ("簡稱")
Combo1.AddItem ("批號")
Combo1.ListIndex = 0
End Sub
Private Sub Form_Load()
Data1.DatabaseName = App.Path & "\yyjxc.mdb" '自動識別數(shù)據(jù)庫路徑
End Sub
Private Sub Form_Unload(Cancel As Integer)
frm_main.Enabled = True
End Sub
Private Sub Command1_Click()
'查詢庫存信息
Data1.RecordSource = "select * from kc where (kc." & Combo1.Text & " " & "like " + Chr(34) + Text1.Text + "*" + Chr(34) + ")"
Data1.Refresh
End Sub
Private Sub Command2_Click() '刪除庫存信息
On Error Resume Next
Data1.Recordset.Delete
Data1.Refresh
Data2.Refresh
End Sub
Private Sub Command3_Click()
frm_main.Enabled = True
Unload Me
End Sub
?? 快捷鍵說明
復制代碼
Ctrl + C
搜索代碼
Ctrl + F
全屏模式
F11
切換主題
Ctrl + Shift + D
顯示快捷鍵
?
增大字號
Ctrl + =
減小字號
Ctrl + -