exporting query

  • Thread starter Thread starter PF
  • Start date Start date
P

PF

Hi!

I have a form where the data source is a query.

The user is changing the data source on the form regularly as he apply
filter and different criteria

Each time he ask a new filter selection, the sql string is rebuild and the
form is
actualised with that sql string.

I want to export the data on that form.

What i do is i create a query with dbs.CreateQueryDef(strNomSql, strSql)
Then i transfer that query with docmd.transferspreadshheet

Is there a way to do the same thing without creating the qdf file?

Pierre
 
AGAST!! WHY are you letting users change anything. That
makes them the programer and you the clean up. I would
write a query for each of his filter selection, modify the
form(and check boxes or option buttons and attached each
of his filter selections to a check box or option button.
then he can select what he wants and nothing is changed.
 
Back
Top