P
pierre
Hi all,
I have a form where a user can select records with listbox
Also he can filter what he want (menu with mouse right click )
I want to export exactly what the user see on his screen to an external
file.
Private Sub cmdExport_Click()
On Error GoTo Err_cmdExport_Click
Dim rst As Recordset
Dim qdf As New QueryDef
Dim strsql As String
Set rst = Forms!frmExport!frmExportSF.Form.RecordsetClone
Set qdf = rst.CopyQueryDef->Gives me the error Unauthorize
operation for that type of object
strsql = qdf.SQL
DoCmd.TransferText acExportDelim, "exportBM", strsql, "test"
How come i have this error?
Regards
I have a form where a user can select records with listbox
Also he can filter what he want (menu with mouse right click )
I want to export exactly what the user see on his screen to an external
file.
Private Sub cmdExport_Click()
On Error GoTo Err_cmdExport_Click
Dim rst As Recordset
Dim qdf As New QueryDef
Dim strsql As String
Set rst = Forms!frmExport!frmExportSF.Form.RecordsetClone
Set qdf = rst.CopyQueryDef->Gives me the error Unauthorize
operation for that type of object
strsql = qdf.SQL
DoCmd.TransferText acExportDelim, "exportBM", strsql, "test"
How come i have this error?
Regards