还有一段代码:
Dim MyRS1 As Recordset
Set MyDB = OpenDatabase(gsDatabase, False, False, gsConnect) 接下来我怎么通过MyDB获得里面有多少个dbf表并写入Combo里面。
Dim MyRS1 As Recordset
Set MyDB = OpenDatabase(gsDatabase, False, False, gsConnect) 接下来我怎么通过MyDB获得里面有多少个dbf表并写入Combo里面。
Sub AddDbfFile(Path As String)
Dim tPath As String, tFile As String
tPath = IIf(Right(Path, 1) = "\", Path, Path & "\")tFile = Dir(tPath & "*.dbf")
If tFile <> "" Then
Combo1.AddItem tFile
Do
tFile = Dir()
If tFile <> "" Then
Combo1.AddItem tFile
End If
Loop Until tFile = ""
End If
Dim Db As Database, Tbs As TableDefs
Dim i As IntegerSet Db = DBEngine.OpenDatabase(CurDir, False, False, "FoxPro 2.5;")
Set Tbs = Db.TableDefsIf Tbs.Count > 0 Then
For i = 0 To Tbs.Count - 1
Combo1.AddItem Tbs(i).Name
Next
End If