📄 frmabout.frm
字号:
VERSION 5.00
Begin VB.Form frmrela
BorderStyle = 1 'Fixed Single
Caption = "户籍关系表"
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 = "机关"
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 = "关系表"
Connect = "Access"
DatabaseName = "F:\常驻人口户籍管理系统(2)\DB2.MDB"
DefaultCursorType= 0 '缺省游标
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 = "登记机关"
Height = 255
Left = 120
TabIndex = 4
Top = 3600
Width = 735
End
Begin VB.Label Label4
Caption = "身份号码"
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 = "家庭关系"
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
⌨️ 快捷键说明
复制代码
Ctrl + C
搜索代码
Ctrl + F
全屏模式
F11
切换主题
Ctrl + Shift + D
显示快捷键
?
增大字号
Ctrl + =
减小字号
Ctrl + -