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

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

* 全部改成 %

 

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

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

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

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

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

你勾选哪些行，就导出哪些行啊，自己认认真真看懂代码啊，自己修改成自己需要的啊。

变灰的原因，如果你用的是试用版，就是你试用期到了；如果你购买的是正版，就应该是你的激活码不正确造成的。

Dim idx As String = "-1,"

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

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

Next

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

 失效指什么？帮你写的导出的代码，就是只是导出勾选的行而已啊。

Dim idx As String = "-1,"

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

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

Next

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