📄 frmreturning3.frm
字号:
VERSION 5.00
Begin VB.Form frmreturning
BorderStyle = 1 'Fixed Single
Caption = "Book Returning Form"
ClientHeight = 5160
ClientLeft = 45
ClientTop = 330
ClientWidth = 9975
Icon = "frmreturning3.frx":0000
LinkTopic = "Form1"
LockControls = -1 'True
MaxButton = 0 'False
MDIChild = -1 'True
MinButton = 0 'False
ScaleHeight = 5160
ScaleWidth = 9975
Begin VB.Frame frareturning
Caption = "Return Details"
BeginProperty Font
Name = "MS Sans Serif"
Size = 12
Charset = 0
Weight = 400
Underline = 0 'False
Italic = 0 'False
Strikethrough = 0 'False
EndProperty
ForeColor = &H80000007&
Height = 5055
Left = 120
TabIndex = 0
Top = 0
Width = 9735
Begin VB.CommandButton Command1
Caption = "Compute Total Amount"
Height = 375
Left = 1680
TabIndex = 34
Top = 3720
Width = 1935
End
Begin VB.ListBox lstbooks
BackColor = &H8000000F&
Height = 3765
Left = 7560
Sorted = -1 'True
TabIndex = 32
Top = 600
Width = 2055
End
Begin VB.Data datreturn
Caption = "datreturn"
Connect = "Access"
DatabaseName = "C:\LIBRARY\Library.mdb"
DefaultCursorType= 0 'DefaultCursor
DefaultType = 2 'UseODBC
Exclusive = 0 'False
Height = 345
Left = 120
Options = 0
ReadOnly = 0 'False
RecordsetType = 1 'Dynaset
RecordSource = "Returned Books"
Top = 3600
Visible = 0 'False
Width = 1140
End
Begin VB.Data datborrowedtable
Caption = "datborrowedtable"
Connect = "Access"
DatabaseName = "C:\LIBRARY\Library.mdb"
DefaultCursorType= 0 'DefaultCursor
DefaultType = 2 'UseODBC
Exclusive = 0 'False
Height = 345
Left = 120
Options = 0
ReadOnly = 0 'False
RecordsetType = 1 'Dynaset
RecordSource = "circulationtable"
Top = 3840
Visible = 0 'False
Width = 1140
End
Begin VB.Data datbookinfo
Caption = "datbookinfo"
Connect = "Access"
DatabaseName = "C:\LIBRARY\Library.mdb"
DefaultCursorType= 0 'DefaultCursor
DefaultType = 2 'UseODBC
Exclusive = 0 'False
Height = 345
Left = 120
Options = 0
ReadOnly = 0 'False
RecordsetType = 1 'Dynaset
RecordSource = "bookdetails"
Top = 3360
Visible = 0 'False
Width = 1140
End
Begin VB.Data datborrowed
Caption = "datborrowedquery"
Connect = "Access"
DatabaseName = "C:\LIBRARY\Library.mdb"
DefaultCursorType= 0 'DefaultCursor
DefaultType = 2 'UseODBC
Exclusive = 0 'False
Height = 345
Left = 120
Options = 0
ReadOnly = 0 'False
RecordsetType = 1 'Dynaset
RecordSource = "borrowedbooksquery"
Top = 3120
Visible = 0 'False
Width = 1140
End
Begin VB.ComboBox cbobookname
Height = 315
Left = 1680
Style = 2 'Dropdown List
TabIndex = 31
Top = 480
Width = 2055
End
Begin VB.CommandButton cmdsave
Caption = "&Save"
Height = 375
Left = 3600
Style = 1 'Graphical
TabIndex = 30
Top = 4560
Width = 1095
End
Begin VB.Frame Frame2
Caption = "Borrower details"
Height = 3855
Left = 4080
TabIndex = 17
Top = 480
Width = 3375
Begin VB.TextBox txtbid
DataField = "studentID"
DataSource = "datborrowed"
Enabled = 0 'False
Height = 285
Left = 1440
TabIndex = 23
Top = 1920
Width = 1695
End
Begin VB.TextBox txtfn
DataField = "studentFName"
DataSource = "datborrowed"
Enabled = 0 'False
Height = 285
Left = 1440
TabIndex = 22
Top = 840
Width = 1695
End
Begin VB.TextBox txtbaddress
DataField = "address"
DataSource = "datborrowed"
Enabled = 0 'False
Height = 285
Left = 1440
TabIndex = 21
Top = 2280
Width = 1695
End
Begin VB.TextBox txtsn
DataField = "studentSName"
DataSource = "datborrowed"
Enabled = 0 'False
Height = 285
Left = 1440
TabIndex = 20
Top = 1200
Width = 1695
End
Begin VB.TextBox txttotal
Alignment = 1 'Right Justify
DataField = "totalamount"
DataSource = "datborrowed"
Enabled = 0 'False
Height = 285
Left = 1440
TabIndex = 19
Text = "0"
Top = 2640
Width = 1695
End
Begin VB.TextBox txttn
DataField = "student3rdname"
DataSource = "datborrowed"
Enabled = 0 'False
Height = 285
Left = 1440
TabIndex = 18
Top = 1560
Width = 1695
End
Begin VB.Label lblbid
Caption = "Borrower ID"
Height = 255
Index = 0
Left = 240
TabIndex = 29
Top = 1920
Width = 1095
End
Begin VB.Label lblfn
Caption = "First Name"
Height = 255
Left = 240
TabIndex = 28
Top = 840
Width = 1095
End
Begin VB.Label lblbaddress
Caption = "Borrower Adress"
Height = 375
Left = 240
TabIndex = 27
Top = 2280
Width = 1095
End
Begin VB.Label lblsn
Caption = "Second Name"
Height = 255
Left = 240
TabIndex = 26
Top = 1200
Width = 1095
End
Begin VB.Label lbltotal
Caption = "Total Charge"
Height = 255
Left = 240
TabIndex = 25
Top = 2760
Width = 1095
End
Begin VB.Label lbltn
Caption = "Third Name"
Height = 255
Left = 240
TabIndex = 24
Top = 1560
Width = 1095
End
End
Begin VB.TextBox txtbookid
DataField = "bookID"
DataSource = "datborrowed"
Enabled = 0 'False
Height = 285
Left = 1680
TabIndex = 8
Top = 960
Width = 2055
End
Begin VB.TextBox txtdateb
DataField = "dateborrowed"
DataSource = "datborrowed"
Enabled = 0 'False
Height = 285
Left = 1680
TabIndex = 7
Top = 1680
Width = 2055
End
Begin VB.TextBox txtdatetor
DataField = "datetoreturn"
DataSource = "datborrowed"
Enabled = 0 'False
Height = 285
Left = 1680
TabIndex = 6
Top = 2040
Width = 2055
End
Begin VB.TextBox txtisbn
DataField = "isbn"
DataSource = "datborrowed"
Enabled = 0 'False
Height = 285
Left = 1680
TabIndex = 5
Top = 1320
Width = 2055
End
Begin VB.TextBox txtdater
Height = 285
Left = 1680
TabIndex = 4
Top = 2400
Width = 2055
End
Begin VB.TextBox txtamount
Alignment = 1 'Right Justify
DataField = "chargelevied"
DataSource = "datborrowed"
Enabled = 0 'False
Height = 285
Left = 1560
TabIndex = 3
Text = "Kshs."
Top = 3240
Width = 975
End
Begin VB.CommandButton cmdexit
Caption = "E&xit"
Height = 375
⌨️ 快捷键说明
复制代码
Ctrl + C
搜索代码
Ctrl + F
全屏模式
F11
切换主题
Ctrl + Shift + D
显示快捷键
?
增大字号
Ctrl + =
减小字号
Ctrl + -