exit sub 当然退出的是该语句所在的sub了要全部退出就用 END 结束本进程
解决方案 »
- 我想把access97改为SQL2000,但不知程序怎么改,谁能帮我改一下?
- 判断SQL数据库是否存在问题
- 一台打印机打两种格式
- 急:关于用VB读取ACCESS数据出现的问题。。。
- insert 语句的一个语法问题!请赐教!
- 紧急求助:一个服务器的用户如何访问另一个服务器上的sqlserver2000? up分分!!
- vb做视频处理怎么这么慢呀!!大家都是用什么办法做的呀,给的思路好不好???
- 求这样一个控件(vb)
- 打好包的VB程序,安装时报错!!!
- 如何用inet下载http内容(在线等待)
- 请教:语句"open filename for binary as #1"含义?
- 有没有这样的函数
Declare a function named ValidateText return Boolean.Private Function ValidateText As Boolean
'Init ValidateText
ValidateText = False(Thie statement can be omited)
If Txt_Q = "" Then
MsgBox "必须录入!", , "检查输入"
Exit Function
End If
'...
ValidateText = True
End FunctionPrivate Sub Command1_Click()
If ValidateText = False then Exit Sub
End Sub
If Txt_Q = "" Then
MsgBox "必须录入!", , "检查输入"
Exit Sub
End If
If Txt选项(0) = "" Then
MsgBox "不能为空!", , "检查输入"
Exit Sub
End If
If Txt选项(1) = "" Then
MsgBox "不能为空!", , "检查输入"
Exit Sub
End If
If Txt选项(2) = "" Then
MsgBox "不能为空!", , "检查输入"
Exit Sub
End If
If Txt选项(3) = "" And Txt选项(4) <> "" Then
MsgBox "不能为空!", , "检查输入"
Exit Sub
End If
End Sub
a=false
a=test()
if a = false then exit sub
a=10
b=20
...
end sub
过程为
private Function test() as boolean
If Txt_Q = "" Then
MsgBox "必须录入!", , "检查输入"
Exit Function
End If
If Txt选项(0) = "" Then
MsgBox "不能为空!", , "检查输入"
Exit Function
End If
If Txt选项(1) = "" Then
MsgBox "不能为空!", , "检查输入"
Exit Function
End If
If Txt选项(2) = "" Then
MsgBox "不能为空!", , "检查输入"
Exit Sub
End If
If Txt选项(3) = "" And Txt选项(4) <> "" Then
MsgBox "不能为空!", , "检查输入"
Exit Function
End If
test=true
end Function
exit sub只是退出当前过程,你的要求可以定义函数,假如只要有个文本框为空就返回false,否则返回true,可以如下:
private Function test() as Boolean
If Txt_Q = "" Then
MsgBox "必须录入!", , "检查输入"
text=False
Exit Function
End If
If Txt选项(0) = "" Then
MsgBox "不能为空!", , "检查输入"
text=False
Exit Function
End If
If Txt选项(1) = "" Then
MsgBox "不能为空!", , "检查输入"
text=False
Exit Function
End If
If Txt选项(2) = "" Then
MsgBox "不能为空!", , "检查输入"
text=False
Exit Function
End If
If Txt选项(3) = "" And Txt选项(4) <> "" Then
MsgBox "不能为空!", , "检查输入"
text=False
Exit Function
End If
test=true
end Function然后这样调用
private sub command1_click()
if not test() then exit sub
a=10
b=20
...
end sub
If Txt_Q = "" Then
MsgBox "必须录入!", , "检查输入"
test=False '每个if都要加上这句
Exit Sub
End If
If Txt选项(0) = "" Then
MsgBox "不能为空!", , "检查输入"
test=False
Exit Sub
……………………
End Function然后在
private sub command1_click()
if test=False then
exit sub
End if a=10
b=20
...
end sub你试试看!