RLI: Transferspreadsheet method with variable query

[Guest]

I have a continuous form based on a query.
When i apply a variable filter on this form is it possible to parse the
filtered queryresults to the Transferspreadsheet method as a query?


Thanks for any help
RLI

 

[Wolfgang Kais]

Hello Rob.

I have a continuous form based on a query.
When i apply a variable filter on this form is it possible to parse the
filtered queryresults to the Transferspreadsheet method as a query?

No, you can't pass the filter to the TranferSpreadsheet method.
But your code can modify/create a query in the database, e.g.
using a QueryDef object and set it's sql property to
"Select * from [YourQuery] Where " & Me.Filter
After closing the QueryDef object, you can export the new query.

 

[Rob]

Thank you Wolfgang for your reply,
Mean while i found another option... i exported the row id's to a temporairy
table on which i created a normal non variable query. That does the trick.
I did not think of your solution, it migth be better....i will give it a try,

Thanks,
Rob

Hello Rob.

I have a continuous form based on a query.
When i apply a variable filter on this form is it possible to parse the
filtered queryresults to the Transferspreadsheet method as a query?

No, you can't pass the filter to the TranferSpreadsheet method.
But your code can modify/create a query in the database, e.g.
using a QueryDef object and set it's sql property to
"Select * from [YourQuery] Where " & Me.Filter
After closing the QueryDef object, you can export the new query.