导出代码如下:
Private Sub cmdext_Click()
On Error GoTo Err_cmdext_Click
'这里将使用DAO来改变查询的SQL语句,必须先在“工具”→“引用”中选择
'Microsoft DAO 3.6 Object Library.
'================================
Dim qdf As DAO.QueryDef
Dim strSQL, strWhere As String
strWhere = Me.sub_mov.Form.Filter
If strWhere = "" Then
strSQL = "select * from statu_mov"
Else
strSQL = "select * from statu_mov where " & strWhere
End If
Set qdf = CurrentDb.QueryDefs("ext_mov")
qdf.SQL = strSQL
qdf.Close