customizing excel export

[Andreas Wöckl]

Hi!

I have the following problem: Im my access forms I have a lot of custom
filters for the users - so they can filter in a criteria they like - often
they would need the output to take this data to excel (for example for using
the data in a word circular letter. I have the possibility in VBA to use the
following:
DoCmd.OutputTo acOutputServerView, "qry_excel_export", acFormatXLS
But I would need to add an sql where condition because i have to filter
this query dynamic - can any one help me!

best regards

andres wöckl

 

[Tom Wickerath]

Hi Andreas,

Query by Form is a very powerful technique, and one of the most requested features. I
have sent a sample DB to your e-mail address. It includes the ability to export the
search results to Excel.

Tom
__________________________________

Hi!

I have the following problem: Im my access forms I have a lot of custom
filters for the users - so they can filter in a criteria they like - often
they would need the output to take this data to excel (for example for using
the data in a word circular letter. I have the possibility in VBA to use the
following:
DoCmd.OutputTo acOutputServerView, "qry_excel_export", acFormatXLS
But I would need to add an sql where condition because i have to filter
this query dynamic - can any one help me!

best regards

andres wöckl