I have a Command Button to Update a table connected to an Access Query. Sometimes the table is filtered and sometimes it is not.
Currently my VBA code looks like this:
If the filter has been turned on this works fine. However, if the table is not filtered, I get the error :
ShowAllData method of Worksheet class failed.
Is there a way I can set up a check to see if the table is filtered or not?