我的语句是这样的: Dim i As Integer ssql = "select * from ksct" adors.Open ssql, adoconn adors.MoveFirst With adors If Not .BOF Or Not .EOF Then For i = 1 To 10 qqq = .Fields("zkzh") qhjpd = .Fields("pd") If qhjpd = False Then MsgBox qhjpd Set adoconn = CreateObject("adodb.connection") Set adors = CreateObject("ADODB.Recordset") adoconn.Open "provider=msdasql;DRIVER=Microsoft Visual FoxPro Driver;UID=;Deleted=yes;Null=no;Collate=Machine;BackgroundFetch=no;Exclusive=No;SourceType=DBF;SourceDB=D:\;" ssql = "update ksct set wordcj=1 where zkzh='" & Form1.qqq & " ' " adors.Open ssql, adoconn, 3, 3 Else MsgBox qhjpd Kill "d:\word.doc" FileCopy "d:\kspf\1200010101\word.doc", "d:\word.doc" wordtt = .Fields("word") frmMain.Show '调用一个窗体 End If .MoveNext Next
End If End With可是frmMain.Show 执行后就直接退出来了,他不返回到FOR中去呀
Dim i As Integer
ssql = "select * from ksct"
adors.Open ssql, adoconn
adors.MoveFirst
With adors
If Not .BOF Or Not .EOF Then
For i = 1 To 10
qqq = .Fields("zkzh")
qhjpd = .Fields("pd")
If qhjpd = False Then
MsgBox qhjpd
Set adoconn = CreateObject("adodb.connection")
Set adors = CreateObject("ADODB.Recordset")
adoconn.Open "provider=msdasql;DRIVER=Microsoft Visual FoxPro Driver;UID=;Deleted=yes;Null=no;Collate=Machine;BackgroundFetch=no;Exclusive=No;SourceType=DBF;SourceDB=D:\;"
ssql = "update ksct set wordcj=1 where zkzh='" & Form1.qqq & " ' "
adors.Open ssql, adoconn, 3, 3
Else
MsgBox qhjpd
Kill "d:\word.doc"
FileCopy "d:\kspf\1200010101\word.doc", "d:\word.doc"
wordtt = .Fields("word")
frmMain.Show '调用一个窗体
End If
.MoveNext
Next
End If
End With可是frmMain.Show 执行后就直接退出来了,他不返回到FOR中去呀
for i=1 to 3
frmMain.Show 1
next i