cnn.Open "Driver=Microsoft Access Driver (*.mdb);dbq=" & sTmp, , sTmp1
sqlstr = "select * from Dbsj"
recc.Open sqlstr, cnn
With recc
.CursorType = adOpenKeyset
.LockType = adLockOptimistic
.AddNew
.Fields("Dbsjh").Value = .RecordCount + 1
.Fields("Dbsjzs").Value = Now
.Fields("Dbsjnr").Value = Trim$(Text2.Text)
.Fields("Dbsjtx").Value = recN
.Fields("Dbsjjhwc").Value = str1
.Update
.UpdateBatch adAffectAllChapters
End With
你的连接字符串好怪cnnstr = " provider=Microsoft.jet.OLEDB.4.0;Data Source=" & App.Path & "\database\user.mdb;Jet OLEDB:Database Password=buct"
cnn1.Open cnnstr
sqlstr = "select * from Dbsj"
recc.Open sqlstr, cnn
With recc
.CursorType = adOpenKeyset
.LockType = adLockOptimistic
.AddNew
.Fields("Dbsjh").Value = .RecordCount + 1
.Fields("Dbsjzs").Value = Now
.Fields("Dbsjnr").Value = Trim$(Text2.Text)
.Fields("Dbsjtx").Value = recN
.Fields("Dbsjjhwc").Value = str1
.Update
.UpdateBatch adAffectAllChapters
End With
你的连接字符串好怪cnnstr = " provider=Microsoft.jet.OLEDB.4.0;Data Source=" & App.Path & "\database\user.mdb;Jet OLEDB:Database Password=buct"
cnn1.Open cnnstr
解决方案 »
- 视频动态检测,找黑点的问题
- VB:使用activemovie关于视频/画面
- 与usb端口连接的手机通讯用什么控件呢
- Adodc控件和文本框绑定的控件的问题
- 刚学vb,问个很入门的问题?
- 高分求购VB打印问题
- vb学到这个程度,该怎么学???虚心请教啊!!!
- 4333d这个是一个比较难的问题 关于MTS事务!! 分也不多 50分!!
- 急救呀!!!
- 我在http://jszb.jsagri.gov.cn/vb/default.htm中看到一个需要的程序,点旁边的“DOWNLOAD”,可是它“不理”我,我真的很需要这几个程序,怎么办?
- SQL数据库的移动
- 这里贴出一个系统托盘程序模块!请大家看看怎么调用它!
sqlstr = "select * from Dbsj"
recc.Open sqlstr, cnn
With recc
.CursorType = adOpenKeyset
.LockType = adLockOptimistic
.AddNew
.Fields("Dbsjh").Value = .RecordCount + 1
.Fields("Dbsjzs").Value = Now
.Fields("Dbsjnr").Value = Trim$(Text2.Text)
.Fields("Dbsjtx").Value = recN
.Fields("Dbsjjhwc").Value = str1
.Update
.UpdateBatch adAffectAllChapters
End With
你的连接字符串好怪cnnstr = " provider=Microsoft.jet.OLEDB.4.0;Data Source=" & App.Path & "\database\user.mdb;Jet OLEDB:Database Password=buct"
cnn1.Open cnnstr
sqlstr = "select * from Dbsj"
recc.Open sqlstr, cnn
With recc
.CursorType = adOpenKeyset
.LockType = adLockOptimistic
.AddNew
.Fields("Dbsjh").Value = .RecordCount + 1
.Fields("Dbsjzs").Value = Now
.Fields("Dbsjnr").Value = Trim$(Text2.Text)
.Fields("Dbsjtx").Value = recN
.Fields("Dbsjjhwc").Value = str1
.Update
.UpdateBatch adAffectAllChapters
End With
你的连接字符串好怪cnnstr = " provider=Microsoft.jet.OLEDB.4.0;Data Source=" & App.Path & "\database\user.mdb;Jet OLEDB:Database Password=buct"
cnn1.Open cnnstr
这样的写法是不正确的,刚打开的时候RecordCount取出来的数值是不正确的,不是你希望的数值
这条语句有问题,.RecordCount得到的不是你需要的结果。
sqlstr = "select * from Dbsj"
recc.CursorType = adOpenKeyset
recc.LockType = adLockOptimistic
recc.Open sqlstr, cnn
With recc
.AddNew
.Fields("Dbsjh").Value = .RecordCount + 1
.Fields("Dbsjzs").Value = Now
.Fields("Dbsjnr").Value = Trim$(Text2.Text)
.Fields("Dbsjtx").Value = recN
.Fields("Dbsjjhwc").Value = str1
.Update
.UpdateBatch adAffectAllChapters
End With