主题：[求助]关于导出数据

Dim Filter As String
With e.Form.Controls("单位查找")
    If .Value IsNot Nothing Then
        If Filter > "" Then
            Filter = Filter & " And "
        End If
        Filter = Filter & "使用单位名称 like '%" & .Value & "%'"
    End If
End With
With e.Form.Controls("出厂编号查找")
    If .Value IsNot Nothing Then
        If Filter > "" Then
            Filter = Filter & " And "
        End If
        Filter = Filter & "出厂编号 like '%" & .Value & "%'"
    End If
End With

If Filter > "" Then
    Tables("基本信息表").Filter = Filter
End If
Dim dlg As New SaveFileDialog '定义一个新的SaveFileDialog
dlg.Filter= "Access文件|*.mdb" '设置筛选器
If dlg.ShowDialog = DialogResult.Ok Then '如果用户单击了确定按钮
    If FileSys.FileExists(dlg.FileName) Then
        FileSys.DeleteFile(dlg.FileName, 2, 2)
    End If
    Dim ex As New Exporter
    ex.SourceTableName = "基本信息表" '指定导出表
    ex.Filter = filter
    ex.filepath = dlg.FileName  '指定目标文件
    ex.Filter = Filter
    ex.Export() '开始导出
End If

代码* 改成 %可以,谢谢老师

如果按条件筛选后,再用复选框选择, 这段代码怎样加上去. 因为筛选符合行,要分二个步走.

Dim idx As String = "-1,"

For Each r As Row In Tables("基本信息表").GetCheckedRows

    idx &= r("_Identify") & ","

Next

Tables("基本信息表").filter = "_Identify in (" & idx.trim(",") & ")"

Tables("基本信息表").filter = iif(Filter > "", "(" & Filter & ") and _Identify in (" & idx.trim(",") & ")", "_Identify in (" & idx.trim(",") & ")")

还是不行，

Tables("基本信息表").filter = "_Identify in (" & idx.trim(",") & ")"改成Tables("基本信息表").filter = iif(Filter > "", "(" & Filter & ") and _Identify in (" & idx.trim(",") & ")", "_Identify in (" & idx.trim(",") & ")")

没有弹出复选框选择，导出的数据还是钩选前的数据。

下载信息  [文件大小：   下载次数： ]

点击浏览该文件:管理项目1.rar