?? frmabout.frm
字號(hào):
VERSION 5.00
Begin VB.Form frmrela
BorderStyle = 1 'Fixed Single
Caption = "戶籍關(guān)系表"
ClientHeight = 5910
ClientLeft = 45
ClientTop = 330
ClientWidth = 7680
LinkTopic = "Form1"
MaxButton = 0 'False
MinButton = 0 'False
ScaleHeight = 5910
ScaleWidth = 7680
StartUpPosition = 3 '窗口缺省
Begin VB.TextBox Text1
BackColor = &H80000018&
DataField = "地址"
DataSource = "Data1"
Height = 270
Index = 12
Left = 1440
Locked = -1 'True
TabIndex = 24
Top = 4320
Width = 4215
End
Begin VB.TextBox Text1
BackColor = &H80000018&
DataField = "機(jī)關(guān)"
DataSource = "Data1"
Height = 270
Index = 11
Left = 1440
Locked = -1 'True
TabIndex = 23
Top = 3600
Width = 4215
End
Begin VB.TextBox Text1
BackColor = &H80000018&
DataField = "num3"
DataSource = "Data1"
Height = 270
Index = 10
Left = 3840
Locked = -1 'True
TabIndex = 22
Top = 3000
Width = 1815
End
Begin VB.TextBox Text1
BackColor = &H80000018&
DataField = "性別3"
DataSource = "Data1"
Height = 270
Index = 9
Left = 2760
Locked = -1 'True
TabIndex = 21
Top = 3000
Width = 735
End
Begin VB.TextBox Text1
BackColor = &H80000018&
DataField = "name3"
DataSource = "Data1"
Height = 270
Index = 8
Left = 1440
Locked = -1 'True
TabIndex = 20
Top = 3000
Width = 975
End
Begin VB.TextBox Text1
BackColor = &H80000018&
DataField = "rel3"
DataSource = "Data1"
Height = 270
Index = 7
Left = 120
TabIndex = 19
Top = 3000
Width = 735
End
Begin VB.TextBox Text1
BackColor = &H80000018&
DataField = "num2"
DataSource = "Data1"
Height = 270
Index = 6
Left = 3840
Locked = -1 'True
TabIndex = 18
Top = 2280
Width = 1815
End
Begin VB.TextBox Text1
BackColor = &H80000018&
DataField = "性別2"
DataSource = "Data1"
Height = 270
Index = 5
Left = 2760
Locked = -1 'True
TabIndex = 17
Top = 2280
Width = 735
End
Begin VB.TextBox Text1
BackColor = &H80000018&
DataField = "name2"
DataSource = "Data1"
Height = 270
Index = 4
Left = 1440
Locked = -1 'True
TabIndex = 16
Top = 2280
Width = 975
End
Begin VB.TextBox Text1
BackColor = &H80000018&
DataField = "rel2"
DataSource = "Data1"
Height = 270
Index = 3
Left = 120
Locked = -1 'True
TabIndex = 15
Top = 2280
Width = 735
End
Begin VB.TextBox Text1
BackColor = &H80000018&
DataField = "num1"
DataSource = "Data1"
Height = 270
Index = 2
Left = 3840
Locked = -1 'True
TabIndex = 14
Top = 1440
Width = 1815
End
Begin VB.TextBox Text1
BackColor = &H80000018&
DataField = "性別1"
DataSource = "Data1"
Height = 270
Index = 1
Left = 2760
Locked = -1 'True
TabIndex = 13
Top = 1440
Width = 735
End
Begin VB.CommandButton Command4
Caption = "返回主頁"
Height = 495
Left = 5760
TabIndex = 12
Top = 5160
Width = 1215
End
Begin VB.CommandButton Command3
Caption = "保存記錄"
Height = 495
Left = 4080
TabIndex = 11
Top = 5160
Width = 1215
End
Begin VB.CommandButton Command2
Caption = "更正記錄"
Height = 495
Left = 2280
TabIndex = 10
Top = 5160
Width = 1215
End
Begin VB.TextBox Text14
DataField = "name0"
DataSource = "Data1"
Height = 495
Left = 4080
TabIndex = 9
Top = 6480
Width = 1215
End
Begin VB.CommandButton Command1
Caption = "查詢戶主"
Height = 495
Left = 600
TabIndex = 8
Top = 5160
Width = 1215
End
Begin VB.Data Data1
Caption = "關(guān)系表"
Connect = "Access"
DatabaseName = "F:\常駐人口戶籍管理系統(tǒng)(2)\DB2.MDB"
DefaultCursorType= 0 '缺省游標(biāo)
DefaultType = 2 '使用 ODBC
Exclusive = 0 'False
Height = 525
Left = 960
Options = 0
ReadOnly = 0 'False
RecordsetType = 1 'Dynaset
RecordSource = "rela"
Top = 6480
Width = 2175
End
Begin VB.TextBox Text1
BackColor = &H80000018&
DataField = "name1"
DataSource = "Data1"
Height = 270
Index = 0
Left = 1440
Locked = -1 'True
TabIndex = 6
Top = 1440
Width = 975
End
Begin VB.Label Label8
Caption = "家庭住址"
Height = 255
Left = 120
TabIndex = 7
Top = 4320
Width = 735
End
Begin VB.Label Label5
Caption = "戶主"
Height = 255
Left = 120
TabIndex = 5
Top = 1440
Width = 495
End
Begin VB.Label Label7
Caption = "登記機(jī)關(guān)"
Height = 255
Left = 120
TabIndex = 4
Top = 3600
Width = 735
End
Begin VB.Label Label4
Caption = "身份號(hào)碼"
Height = 255
Left = 3720
TabIndex = 3
Top = 960
Width = 735
End
Begin VB.Label Label3
Caption = "性別"
Height = 255
Left = 2760
TabIndex = 2
Top = 960
Width = 375
End
Begin VB.Label Label2
Caption = "姓名"
Height = 255
Left = 1320
TabIndex = 1
Top = 840
Width = 495
End
Begin VB.Label Label1
Caption = "家庭關(guān)系"
Height = 255
Left = 120
TabIndex = 0
Top = 840
Width = 855
End
End
Attribute VB_Name = "frmrela"
Attribute VB_GlobalNameSpace = False
Attribute VB_Creatable = False
Attribute VB_PredeclaredId = True
Attribute VB_Exposed = False
Private Sub Command1_Click()
Dim s As String
Dim Number As String
s = "戶主名"
Number = InputBox(s, "輸入提示", "")
Data1.Recordset.FindFirst "name0='" & Number & "'"
If Data1.Recordset.NoMatch Then
s = MsgBox("無此戶主！", vbOKOnly, "提示")
End If
End Sub
Private Sub Command2_Click() '更新記錄
Dim i As Integer
For i = 0 To 12
Text1(i).Locked = False
Next
Text1(0).SetFocus
Command1.Enabled = False
Command2.Enabled = False
Command3.Enabled = True
Command4.Enabled = False
End Sub
Private Sub Command3_Click() '保存記錄
Dim i As Integer
If IsAdd Then '如果是true，加入新記錄
Data1.Recordset.AddNew
Else
Data1.Recordset.Edit '如果是false，則
End If
Data1.Recordset.Update
Data1.Recordset.MoveFirst
For i = 0 To 12
Text1(i).Locked = True
Next
Command1.Enabled = True
Command2.Enabled = True
Command4.Enabled = True
End Sub
Private Sub Command4_Click()
frmMain.Show
frmrela.Hide
End Sub
?? 快捷鍵說明
復(fù)制代碼
Ctrl + C
搜索代碼
Ctrl + F
全屏模式
F11
切換主題
Ctrl + Shift + D
顯示快捷鍵
?
增大字號(hào)
Ctrl + =
減小字號(hào)
Ctrl + -