删除按钮的错误?? 这段代码有问题,当记录集为空时,myrs.movenext是会出错的,所以你应该判断是否为空再填入数据! 解决方案 » 免费领取超大流量手机卡,每月29元包185G流量+100分钟通话, 中国电信官方发货 Private Sub Command5_Click()myrs.DeleteIf myrs.EOF Then if not myrs.bof then myrs.MoveLast else exit sub endifElsemyrs.MoveNextEnd IfForm3.Text1.Text = myrs.Fields(1)Form3.Text2.Text = myrs.Fields(2)Form3.Text3.Text = myrs.Fields(3)Form3.Text4.Text = myrs.Fields(4)Form3.Text5.Text = myrs.Fields(5)Form3.Text6.Text = myrs.Fields(6)Form3.Text7.Text = myrs.Fields(7)Form3.Text8.Text = myrs.Fields(8)Form3.Text9.Text = myrs.Fields(9)Form3.Text10.Text = myrs.Fields(10)Form3.Text11.Text = myrs.Fields(11) Private Sub Command5_Click()on error goto err_exitmyrs.DeleteIf myrs.EOF Then if not myrs.bof then myrs.MoveLast else exit sub endifElsemyrs.MoveNextEnd IfForm3.Text1.Text = myrs.Fields(1)Form3.Text2.Text = myrs.Fields(2)Form3.Text3.Text = myrs.Fields(3)Form3.Text4.Text = myrs.Fields(4)Form3.Text5.Text = myrs.Fields(5)Form3.Text6.Text = myrs.Fields(6)Form3.Text7.Text = myrs.Fields(7)Form3.Text8.Text = myrs.Fields(8)Form3.Text9.Text = myrs.Fields(9)Form3.Text10.Text = myrs.Fields(10)Form3.Text11.Text = myrs.Fields(11)......err_exit:end sub 令一方法:Private Sub Command5_Click()myrs.DeleteIf myrs.recordcount = 0 then exit subIf myrs.EOF Thenmyrs.MoveLastElsemyrs.MoveNextEnd If...... 还有,为了明确记录已经删空,上立可以改为:If myrs.recordcount = 0 then Form3.Text1.Text = ""Form3.Text2.Text = ""......Form3.Text11.Text = ""exit subend if...... 多谢你的帮助。可是我认为根本不是“空”的原因。而是eof的原因。还是不行呀。对了。你有email吗?我把我的程序发给你。你全面的给我检查一下吧。多谢。 一个简单的MSFlexGrid1 的问题,请帮助解决一下,谢谢! vb连接SQL时如何列出数据库名 vb打包本机安装出错:不能启动主程序 小问题,在线等,会的快来帮忙啊!!!!!!!!!!! 请教关于复制粘贴问题 说服老板免费送100M邮箱给所有网民,散分 搞图像的请看:http://www.skycn.net/soft/12024.html 如何在Picture控件中保存绘制的图像 图片的录入问题 自編ActiveX控件在网頁中用時﹐安裝在出現問題﹖ 关于SQL Server远程连接的问题 如何做一个setup可将分离的数据库直接附加到sql server2000上?
myrs.Delete
If myrs.EOF Then
if not myrs.bof then
myrs.MoveLast
else
exit sub
endif
Else
myrs.MoveNext
End If
Form3.Text1.Text = myrs.Fields(1)
Form3.Text2.Text = myrs.Fields(2)
Form3.Text3.Text = myrs.Fields(3)
Form3.Text4.Text = myrs.Fields(4)
Form3.Text5.Text = myrs.Fields(5)
Form3.Text6.Text = myrs.Fields(6)
Form3.Text7.Text = myrs.Fields(7)
Form3.Text8.Text = myrs.Fields(8)
Form3.Text9.Text = myrs.Fields(9)
Form3.Text10.Text = myrs.Fields(10)
Form3.Text11.Text = myrs.Fields(11)
on error goto err_exit
myrs.Delete
If myrs.EOF Then
if not myrs.bof then
myrs.MoveLast
else
exit sub
endif
Else
myrs.MoveNext
End If
Form3.Text1.Text = myrs.Fields(1)
Form3.Text2.Text = myrs.Fields(2)
Form3.Text3.Text = myrs.Fields(3)
Form3.Text4.Text = myrs.Fields(4)
Form3.Text5.Text = myrs.Fields(5)
Form3.Text6.Text = myrs.Fields(6)
Form3.Text7.Text = myrs.Fields(7)
Form3.Text8.Text = myrs.Fields(8)
Form3.Text9.Text = myrs.Fields(9)
Form3.Text10.Text = myrs.Fields(10)
Form3.Text11.Text = myrs.Fields(11)
......
err_exit:
end sub
Private Sub Command5_Click()
myrs.Delete
If myrs.recordcount = 0 then exit sub
If myrs.EOF Then
myrs.MoveLast
Else
myrs.MoveNext
End If
......
If myrs.recordcount = 0 then
Form3.Text1.Text = ""
Form3.Text2.Text = ""
......
Form3.Text11.Text = ""
exit sub
end if
......