customizing excel export

  • Thread starter Thread starter Andreas Wöckl
  • Start date Start date
A

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
 
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
 
Back
Top