J
JoeR
I am trying to dynamically filter content from a query to
an Excel spreadsheet. Whereas the "OutputTo a report"
feature allows for a 'Where' statement, I can't find a way
that works to limit output to an Excel spreadsheet.
I want to pass a variable created from a pull down menu on
a form to the OutputTo results so that the resulting Excel
spreadsheet will only have records that match the
varialble. Below is the command I've been working with.
DoCmd.OutputTo acQuery, "QueryName", "MicrosoftExcel
(*.xls)", "", false, ""
I've tried setting up a filter and a record set--but no
success.
I appreciate any help anyone can offer on this. Don't
know if it makes a difference, but I'm using Access 2000.
an Excel spreadsheet. Whereas the "OutputTo a report"
feature allows for a 'Where' statement, I can't find a way
that works to limit output to an Excel spreadsheet.
I want to pass a variable created from a pull down menu on
a form to the OutputTo results so that the resulting Excel
spreadsheet will only have records that match the
varialble. Below is the command I've been working with.
DoCmd.OutputTo acQuery, "QueryName", "MicrosoftExcel
(*.xls)", "", false, ""
I've tried setting up a filter and a record set--but no
success.
I appreciate any help anyone can offer on this. Don't
know if it makes a difference, but I'm using Access 2000.