Dim cnn1 As ADODB.Connection
Dim rst As ADODB.Recordset
Dim cnnstr As String
Dim intUserNum As Integer
Set cnn1 = New ADODB.Connection
bolstu = Truecnnstr = " provider=Microsoft.jet.OLEDB.4.0;Data Source=" & App.Path & "\database\experiment.mdb;Jet OLEDB:Database Password=buct"
cnn1.Open cnnstrSet rst = New ADODB.Recordset
rst.CursorType = adOpenKeyset
rst.LockType = adLockOptimistic
rst.Open "select * from classdo", cnn1Do Until rst.EOF
MsgBox rst.Fields(0)
rst.MoveNext
Looprst.Close
cnn1.Close
Dim rst As ADODB.Recordset
Dim cnnstr As String
Dim intUserNum As Integer
Set cnn1 = New ADODB.Connection
bolstu = Truecnnstr = " provider=Microsoft.jet.OLEDB.4.0;Data Source=" & App.Path & "\database\experiment.mdb;Jet OLEDB:Database Password=buct"
cnn1.Open cnnstrSet rst = New ADODB.Recordset
rst.CursorType = adOpenKeyset
rst.LockType = adLockOptimistic
rst.Open "select * from classdo", cnn1Do Until rst.EOF
MsgBox rst.Fields(0)
rst.MoveNext
Looprst.Close
cnn1.Close
解决方案 »
- 请问vb datagrid里数据导入到EXCEL问题
- 哪里有MSDN的程序员手册
- vb 打印程序怎么做
- 如何删除某一字段中的重复纪录
- SQL Server2000数据库恢复时提示用户登陆失败的问题!在线急等!
- 求指导,程序效率提高
- 请问vb有没有复制类的语句
- 怎样将.doc、.xls等文件转换成.html文件?有这样的windows API函数吗?
- 程序在vb环境下run正常,但是编译成exe后执行报错,什么canot find installable ISAM.怎么处理?
- 关于标签控件LABEL的问题!
- 谁能告诉我: 公制单位,屏幕象素,打印机象素三者之间的比例关系?
- 征求对非法错误的外理方法
改为:
rs技术.CursorLocation = adUseClient
rs技术.Open rstj , conjsfw, adOpenDynamic, adLockBatchOptimistic
rs技术.MoveFirst '**************
For i = 0 To rs技术.RecordCount - 1
序号 = ""
序号 = Trim(rs技术.Fields![序号])
安装派工单.PrintReport
Unload 安装派工单
rs技术.MoveNext
Next i
+
你已经把 rs技术释放了,哪里还有rs技术?
dim rs技术 as new adodb.recordset
set rs技术=new recordset '增加这句
rs技术.CursorLocation = adUseClient将 rs技术.Open rstj , conjsfw, adOpenDynamic, adLockBatchOptimistic
改为:rs技术.Open rstj , conjsfw, adOpenKeyset, adLockReadOnly
For i = 0 To rs技术.RecordCount - 1
序号 = ""
序号 = Trim(rs技术.Fields![序号])
安装派工单.PrintReport
Unload 安装派工单
rs技术.MoveNext
Next i
do while not rs.eof
.....
loop
do while not rs.eof
.....
loop
Dim rst As ADODB.Recordset
Dim cnnstr As String
Dim intUserNum As Integer
Set cnn1 = New ADODB.Connection
bolstu = Truecnnstr = " provider=Microsoft.jet.OLEDB.4.0;Data Source=" & App.Path & "\database\experiment.mdb;Jet OLEDB:Database Password=buct"
cnn1.Open cnnstrSet rst = New ADODB.Recordset
rst.CursorType = adOpenKeyset
rst.LockType = adLockOptimistic
rst.Open "select * from classdo", cnn1Do Until rst.EOF
MsgBox rst.Fields(0)
rst.MoveNext
Looprst.Close
cnn1.Close