Private Sub Command1_Click()
Dim rs As New ADODB.Recordset
Set rs = dbe.rskc
answer = MsgBox("sure?", vbOKCancel, "sure")
If answer = vbOK Then
if len(text1.text)=0 then msgbox("on",vbCritical,"error")End If
Exit Sub
With rs
.AddNew
.Fields("name").Value = Text1.Text
.Fields("sex").Value = Text2.Text
.Fields("age").Value = Text3.Text
.Fields("work").Value = Text4.Text
.Update
End With
End If
End Sub错误,缺少:=
Dim rs As New ADODB.Recordset
Set rs = dbe.rskc
answer = MsgBox("sure?", vbOKCancel, "sure")
If answer = vbOK Then
if len(text1.text)=0 then msgbox("on",vbCritical,"error")End If
Exit Sub
With rs
.AddNew
.Fields("name").Value = Text1.Text
.Fields("sex").Value = Text2.Text
.Fields("age").Value = Text3.Text
.Fields("work").Value = Text4.Text
.Update
End With
End If
End Sub错误,缺少:=
解决方案 »
- 用Setup Factory 6.0打包出现的问题?
- VB中有个Form,怎么把它设为“总是在最前方”
- 紧急求救 我用vb6.0 access2000数据库连接 求救 在线等!
- 再问一个打包问题:vb + sql server
- 请问mscomm32控件的rthreshold的属性应如何设置为妥
- 急用,关于收费系统中打印的问题
- 高手速速来帮忙`急啊`
- 用VB做在WEB上面用ocx时,获得UserControl内的所有文本框
- 请问VB里有没有10进制与16进制互相转换的函数
- 怎么在ADO中使用索引(seek)?
- 给你大家一个新鲜的阿,请进
- 如何让Replace(Trim(MCIStatus) = "stopped"返回值为true?
改为
if len(text1.text) = 0 then msgbox "on",vbcritical, "error"
Dim rs As New ADODB.Recordset
Set rs = dbe.rskc
answer = MsgBox("sure?", vbOKCancel, "sure")
If answer = vbOK Then
'if len(text1.text)=0 then msgbox "on",vbCritical,"error"
if len(text1.text)=0 then
msgbox "on",vbCritical,"error"
End If
End If
Exit Sub
With rs
.AddNew
.Fields("name").Value = Text1.Text
.Fields("sex").Value = Text2.Text
.Fields("age").Value = Text3.Text
.Fields("work").Value = Text4.Text
.Update
End With
End If
End Sub
同C、Java里的一对花括号{}一样
同C、Java里的一对花括号{}一样
1.end if 前换行
2.把msgbox的括号去掉
在 msgbox 语句下面面加 Exit Sub
Exit Sub
上面的退出过程应该在if语句里面吧。不然就算你把endif去掉了,那个退出过程总要运行。你那还不是一个效果,就是多了个提示么。
改为
if len(text1.text)=0 then
msgbox "on",vbCritical,"error"
Exit Sub
End If
Private Sub Command1_Click()
Dim rs As New ADODB.Recordset
Set rs = dbe.rskc
answer = MsgBox("sure?", vbOKCancel, "sure")
If answer = vbOK Then
If Len(text1.Text) = 0 Then
MsgBox "on", vbCritical, "error"
Exit Sub
Else
With rs
.AddNew
.Fields("name").Value = text1.Text
.Fields("sex").Value = Text2.Text
.Fields("age").Value = Text3.Text
.Fields("work").Value = Text4.Text
.Update
End With
End If
End If
End Sub
你的代码太乱了,你看看是不是这样的。
exit sub这一句发错位置了吧,要不然就像楼上有位说的一样,只是增加了一个msgbox,有错与否都要执行数据的添加
Private Sub Command1_Click()
Dim rs As New ADODB.Recordset
Set rs = dbe.rskc
answer = MsgBox("sure?", vbOKCancel, "sure")
If answer = vbOK Then
If Len(text1.Text) = 0 Then
MsgBox "on", vbCritical, "error"
elseif len(text2.text)= 0 then
msgbox "on",vbcritical,"error"
Exit Sub
end if
Else
With rs
.AddNew
.Fields("name").Value = text1.Text
.Fields("sex").Value = Text2.Text
.Fields("age").Value = Text3.Text
.Fields("work").Value = Text4.Text
.Update
End With
End If
End Sub还是:Private Sub Command1_Click()
Dim rs As New ADODB.Recordset
Set rs = dbe.rskc
answer = MsgBox("sure?", vbOKCancel, "sure")
If answer = vbOK Then
If Len(text1.Text) = 0 Then
MsgBox "on", vbCritical, "error"
elseif len(text2.text)= 0 then
msgbox "on",vbcritical,"error"
Exit Sub
Else
With rs
.AddNew
.Fields("name").Value = text1.Text
.Fields("sex").Value = Text2.Text
.Fields("age").Value = Text3.Text
.Fields("work").Value = Text4.Text
.Update
End With
End If
end if
End Sub
那个end if 放在哪里?
Dim rs As New ADODB.Recordset
Set rs = dbe.rskc
answer = MsgBox("sure?", vbOKCancel, "sure")
If answer = vbOK Then
If Len(Text1.Text) = 0 Then
MsgBox "no", vbCritical, "error"
ElseIf Len(Text2.Text) = 0 Then
MsgBox "f", vbCritical, "error"
Exit SubElse
With rs
.AddNew
.Fields("name").Value = Text1.Text.Update
End With
End If
End If
End Sub这样写就实现了,但是出现了一个问题,text1和TEXT2都有内容时,添加到数据库的只有TEXT1,而TEXT2里面的内容就添加不进
你不是只用了.Fields("name").Value = Text1.Text 么...
Private Sub Command1_Click()
Dim rs As New ADODB.Recordset
Set rs = dbe.rskc
answer = MsgBox("sure?", vbOKCancel, "sure")
If answer = vbOK Then
If Len(Text1.Text) = 0 Then
MsgBox "no", vbCritical, "error"
ElseIf Len(Text2.Text) = 0 Then
MsgBox "f", vbCritical, "error"
Exit Sub
Else
With rs
.AddNew
.Fields("name").Value = Text1.Text
.Fields("sex").Value = Text2.Text
.Update
End With
End If
End If
End Sub这里的exit sub要不要的结果都是一样的,不要也可以
,连问题都找不出还说别人基本语句没掌握