This content has been marked as final. Show 2 replies
I have an Access application that opens Monarch then applies model and exports the records as an excel spreadsheet.
If a model has a filter applied to it then I would like to remove the filter before expoting the records to excel.Is there a way to change the filter in the code before exporting to excel?
I tried: MonarchObj.Currentfilter = "No Filter"
But this doesn't work. This code works if I want to apply the filter not remove the filter.
Any ideas would be greatly appreciated.