📄 frmfixdeposit2.frm
字号:
EndProperty
ForeColor = &H00FFFFFF&
Height = 210
Index = 5
Left = 240
TabIndex = 5
Top = 2040
Width = 945
End
Begin VB.Label lbl
AutoSize = -1 'True
BackStyle = 0 'Transparent
Caption = "姓名:"
BeginProperty Font
Name = "宋体"
Size = 10.5
Charset = 134
Weight = 400
Underline = 0 'False
Italic = 0 'False
Strikethrough = 0 'False
EndProperty
ForeColor = &H00FFFFFF&
Height = 210
Index = 4
Left = 240
TabIndex = 4
Top = 1560
Width = 525
End
Begin VB.Label lbl
AutoSize = -1 'True
BackStyle = 0 'Transparent
Caption = "请将用户所填的存款表中的数据,填入下表中!"
BeginProperty Font
Name = "宋体"
Size = 10.5
Charset = 134
Weight = 400
Underline = 0 'False
Italic = 0 'False
Strikethrough = 0 'False
EndProperty
ForeColor = &H00FFFFFF&
Height = 210
Index = 0
Left = 1920
TabIndex = 3
Top = 720
Width = 4410
End
Begin VB.Line line
BorderColor = &H00FFFFFF&
BorderWidth = 2
Index = 1
X1 = 0
X2 = 8160
Y1 = 960
Y2 = 960
End
Begin VB.Label lbl
AutoSize = -1 'True
BackStyle = 0 'Transparent
Caption = "存款"
BeginProperty Font
Name = "华文新魏"
Size = 15.75
Charset = 134
Weight = 400
Underline = 0 'False
Italic = 0 'False
Strikethrough = 0 'False
EndProperty
ForeColor = &H00FFFFFF&
Height = 315
Index = 2
Left = 3720
TabIndex = 2
Top = 240
Width = 630
End
Begin VB.Line line
BorderColor = &H00FFFFFF&
BorderWidth = 2
Index = 0
X1 = -120
X2 = 8040
Y1 = 600
Y2 = 600
End
Begin VB.Label lbl
AutoSize = -1 'True
BackStyle = 0 'Transparent
Caption = "Second"
BeginProperty Font
Name = "宋体"
Size = 10.5
Charset = 134
Weight = 700
Underline = 0 'False
Italic = 0 'False
Strikethrough = 0 'False
EndProperty
ForeColor = &H00FFFFFF&
Height = 210
Index = 1
Left = 120
TabIndex = 1
Top = 360
Width = 720
End
Begin VB.Label lbl
AutoSize = -1 'True
BackStyle = 0 'Transparent
Caption = "第二步"
BeginProperty Font
Name = "宋体"
Size = 10.5
Charset = 134
Weight = 700
Underline = 0 'False
Italic = 0 'False
Strikethrough = 0 'False
EndProperty
ForeColor = &H00FFFFFF&
Height = 210
Index = 3
Left = 7200
TabIndex = 0
Top = 360
Width = 675
End
End
Attribute VB_Name = "frmFixDeposit2"
Attribute VB_GlobalNameSpace = False
Attribute VB_Creatable = False
Attribute VB_PredeclaredId = True
Attribute VB_Exposed = False
Dim nowTime As String
Dim FetchTime As String
'响应 "上一步" 按钮
Private Sub cmdBack_Click()
Unload Me
frmFixDeposit1.Show
End Sub
'响应 "取消" 按钮
Private Sub cmdCancel_Click()
Unload Me
End Sub
'响应 "下一步按钮"
Private Sub cmdNext_Click()
nowTime = Now
FetchTime = nowTime
'''''''''''''''''''''''''''''''''''''''''''''''''''''''''''''''''''
'判断输入的正确性↓
'''''''''''''''''''''''''''''''''''''''''''''''''''''''''''''''''''
For i = 0 To 5
If txt(i).Text = "" Then
MsgBox "请将各项填写完整", vbExclamation, "提示"
Exit Sub
End If
Next i
If Len(txt(0).Text) > 12 Then
MsgBox "姓名不能长于12位英文或6位中文", vbExclamation, "提示"
Exit Sub
End If
If Len(txt(1).Text) > 20 Then
MsgBox "电话号码不得长于20位", vbExclamation, "提示"
Exit Sub
End If
If Len(txt(2).Text) > 25 Then
MsgBox "身份证号码不得长于25位", vbExclamation, "提示"
Exit Sub
End If
If Len(txt(3).Text) > 50 Then
MsgBox "住址不得50个英文或25个中文", vbExclamation, "提示"
Exit Sub
End If
If Len(txt(4).Text) > 8 Then
MsgBox "金额不得大于8位", vbExclamation, "提示"
Exit Sub
End If
If Len(txt(5).Text) > 2 Then
MsgBox "存期不得长于2位", vbExclamation, "提示"
Exit Sub
End If
''''''''''''''''''''''''''''''''''判断用户的金额输入是否为数字↓
Dim theMoney As Double
Dim errMoney As Boolean
errMoney = True
On Error GoTo err2
theMoney = CDbl(txt(4).Text)
errMoney = False
err2:
If errMoney Then
MsgBox "请确存款金额为数字", vbExclamation, "提示"
Exit Sub
End If
'''''''''''''''''''''''''''''''''判断用户的存期输入是否为数字↓
Dim theDate As Double
Dim errDate As Boolean
errDate = True
On Error GoTo err1
theDate = CDbl(txt(5).Text)
errDate = False
err1:
If errDate Then
MsgBox "请确存期为数字", vbExclamation, "提示"
Exit Sub
End If
''''''''''''''''''''''''''''''''''''''''''''''''''''''''''''''''''
'如果用户输入正确↓
''''''''''''''''''''''''''''''''''''''''''''''''''''''''''''''''''
'''''''''''''''''''''''''根据日期自动生成账号↓
frmFixDeposit3.txt(0).Text = "F" + Format(nowTime, "yyyy") + Format(nowTime, "mm") + Format(nowTime, "dd") + Format(nowTime, "hh") + Format(nowTime, "nn") + Format(nowTime, "ss")
'''''''''''''''''''''''''将数据传到第三步的面板↓
For i = 0 To 5
frmFixDeposit3.txt(i + 1).Text = frmFixDeposit2.txt(i).Text
Next i
Mid(FetchTime, 1, 4) = (CDbl(frmFixDeposit2.txt(5).Text) + CDbl(Format(nowTime, "yyyy")))
frmFixDeposit3.txt(7).Text = nowTime
If CDbl(txt(5).Text) = 1 Then
frmFixDeposit3.txt(8).Text = percentage1
ElseIf CDbl(txt(5).Text) = 2 Then
frmFixDeposit3.txt(8).Text = percentage2
ElseIf CDbl(txt(5).Text) >= 3 And CDbl(txt(5).Text) < 5 Then
frmFixDeposit3.txt(8).Text = percentage3
ElseIf CDbl(txt(5).Text) >= 5 And CDbl(txt(5).Text) < 8 Then
frmFixDeposit3.txt(8).Text = percentage5
ElseIf CDbl(txt(5).Text) >= 8 Then
frmFixDeposit3.txt(8).Text = percentage8
End If
frmFixDeposit3.txt(9).Text = FetchTime
frmFixDeposit3.txt(10).Text = userName
frmFixDeposit4.theNowTime = nowTime
''''''''''''''''''''''''''''''''''''''''''''''
Unload Me
frmFixDeposit3.Show
End Sub
⌨️ 快捷键说明
复制代码
Ctrl + C
搜索代码
Ctrl + F
全屏模式
F11
切换主题
Ctrl + Shift + D
显示快捷键
?
增大字号
Ctrl + =
减小字号
Ctrl + -