Accessing filter property

  • Thread starter Thread starter Guest
  • Start date Start date
G

Guest

In Access Project 2003, I open a table, right-mouse-click for the popup menu,
and specify some filter criteria. How can I programmatically access the
filter specified? Is it stored in a property? If so, where?
 
Personally, I never tried to apply a filter directly to a linked table and I
never heard of someone who wanted to do this. You're the first one.

It is possible that this property is available when you programmatically
open the table in design mode; however this is definetively not the way to
proceed with ADP.

S. L.
 
One can access this information via the fn_listextendedproperty function from
within SQL Server. Unfortunately, unlike an MDB, the filter information is
not available until one applies it to the table. I simply use a form in
datasheet mode now instead. This does provide the filter information
immediately.
 
Back
Top