2 Replies Latest reply: May 15, 2014 9:55 AM by MonarchUser _ RSS

    Monarch Filter

    MonarchUser _

      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.

       

      Thanks