As always, I hope this question is not redundant; I've looked through previous questions, and can't seem to find a match to this 'variation on a theme'.
I have a menu driven app that is used by a client. In order to simplify matters, I don't provide the user with access to the menu system that allows usage of the "Office Links" options. Within this app, there are a series of output options set up, mostly reports, that are the result of utilizing the "WhereCondition" option in the DoCmd.OpenReport method. There are multiple instances of this issue within the application, but all share the same issue. In each separate case, a single report format is populated each time it's run with records distinguished by a network of user selected characteristics, assigned in a "master file".
The basic functionality of the reporting has been working just fine for over a year and is tried and true. However, I'd now like to add an "Export to Excel" option for the user to select. Currently the only options at runtime are to either send the report to the screen or to the printer.
The OutputTo method's Access help file indicates that there is no opportunity for "filtering" a larger dataset in the same manner as is possible with the "WhereCondition".
Granted, I can rewrite the existing procs to build the filtering into various queries, instead of controlling data flow in the DoCmd.OpenReport method. But I hate to begin tearing up a process that's actually working just fine.
Any ideas on how to filter output to Excel?
Many thanks, my friends.
... John
Start Free Trial
