export form current record source

[chriske911]

how can I refer to a form's current record source as rercordset to
export to a excel sheet or whatever?
I want to use the form's recordset with all of the filters applied as
is
so I cannot point to a query with parameters as I do not know what
filters are used

I have tried to use me.recordsetclone but it gives me an error:
"An expression you entered is the wrong data type for one of the
arguments."

thnx

 

[Dirk Goldgar]

how can I refer to a form's current record source as rercordset to
export to a excel sheet or whatever?
I want to use the form's recordset with all of the filters applied as
is
so I cannot point to a query with parameters as I do not know what
filters are used

I have tried to use me.recordsetclone but it gives me an error:
"An expression you entered is the wrong data type for one of the
arguments."

The OutputTo method can be called to export the active object, as for
example:

DoCmd.OutputTo _
acOutputForm, _
, _
acFormatXLS, _
"C:\Temp\" & Me.Name & ".xls"

 

[chriske911]

Dirk Goldgar expressed precisely :

The OutputTo method can be called to export the active object, as for
example:

DoCmd.OutputTo _
acOutputForm, _
, _
acFormatXLS, _
"C:\Temp\" & Me.Name & ".xls"

I get exactly the same error message this way

this is my code:

DoCmd.OutputTo acOutputForm, Form_frmEstHDR, acFormatXLS, FileName

filename is a variable that is pointing to a UNC path where the user's
documents reside

thnx

 

[Dirk Goldgar]

Dirk Goldgar expressed precisely :



I get exactly the same error message this way

this is my code:

DoCmd.OutputTo acOutputForm, Form_frmEstHDR, acFormatXLS, FileName

No, that's wrong. In the first place, if a value is supplied for the
second argument of the OutputTo method, is should be a string that gives
the name of the object, not a reference to the object itself. In the
second place, to export the active object you must not specify *any*
second argument. See the example I posted. Try this:

DoCmd.OutputTo acOutputForm, , acFormatXLS, FileName

 

[chriske911]

Dirk Goldgar pretended :

No, that's wrong. In the first place, if a value is supplied for the
second argument of the OutputTo method, is should be a string that gives
the name of the object, not a reference to the object itself. In the
second place, to export the active object you must not specify *any*
second argument. See the example I posted. Try this:

DoCmd.OutputTo acOutputForm, , acFormatXLS, FileName

yep, that was it
did try that before though, but the strange thing I have had before
that it isn't working in debug mode but it did in user mode

thnx