7,763
社区成员
发帖
与我相关
我的任务
分享
If Len(Dir(App.path & "\busdata\" & Trim(rs0.Fields(0)) & "VEHID.txt")) = 0 Then '如果不存在该文件,则创建并写入
Dim strTemp3 As String
Dim i3 As Integer
Open App.path & "\busdata\" & Trim(rs0.Fields(0)) & "VEHID.txt" For Output As #3
rs3.MoveFirst
While Not rs3.EOF
strTemp3 = rs3.Fields(0)
Dim rs4 As New ADODB.Recordset
rs4.Open "select ... ", cn, adOpenKeyset, adLockOptimistic
If rs4.Fields(0) < 1800 Then Print #3, strTemp3
Set rs4 = Nothing '记录集不能在打开的状态下再打开,要在open之前先close关闭它
rs3.MoveNext
Wend
Close #3
End If
Private Sub Command1_Click()
Dim cn As New ADODB.Connection, rs3 As New ADODB.Recordset, strTemp3 As String
cn.ConnectionString = "Provider=Microsoft.Jet.OLEDB.4.0;Data Source=" & App.Path & "\考试题.mdb;Persist Security Info=False"
cn.Open
Open App.Path & "\VEHID.txt" For Append As #3
'这里使用Append 方式打开比较好,可以不需要上面的: '如果不存在该文件,则创建并写入,可以自动创建文件,并且是给文件末尾写入内容
rs3.Open "Select * From 题库", cn, 3, 2
Do While Not rs3.EOF
strTemp3 = rs3.Fields(0)
Write #3, strTemp3 '顺序文件中应该是:写入指令 Write,读取指令 Input
rs3.MoveNext
Loop
Close #3 '写入后必须关闭文件
MsgBox "操作成功!"
End Sub
Dim strTemp3 As String
Dim i3 As Integer
'Open App.Path & "\busdata\" & Trim(rs0.Fields(0)) & "VEHID.txt" For Output As #3
Open App.Path & "\busdata\" & Trim(rs0.Fields(0)) & "VEHID.txt" For Append As #3
'这里使用Append 方式打开比较好,可以不需要上面的: '如果不存在该文件,则创建并写入,可以自动创建文件,并且是给文件末尾写入内容
rs3.MoveFirst
While Not rs3.EOF
strTemp3 = rs3.Fields(0)
Dim rs4 As New ADODB.Recordset
rs4.Open "select ... ", cn, adOpenKeyset, adLockOptimistic
'If rs4.Fields(0) < 1800 Then Print #3, strTemp3
If rs4.Fields(0) < 1800 Then Write #3, strTemp3 '顺序文件中应该是:写入指令 Write,读取指令 Input
Close #3 '写入后必须关闭文件
Set rs4 = Nothing '记录集不能在打开的状态下再打开,要在open之前先close关闭它
rs3.MoveNext
Wend
Close #3
这样修改应该可以了吧。