RLI: Transferspreadsheet method with variable query

  • Thread starter Thread starter Guest
  • Start date Start date
G

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
 
Hello Rob.

Rob said:
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?
Click to expand...

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.
 
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
Wolfgang Kais said:
Hello Rob.

Rob said:
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?
Click to expand...

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.
Click to expand...
 
Back
Top