How to Get Table/Field Filter in Access 2007?

  • Thread starter Thread starter Yazeed
  • Start date Start date
Y

Yazeed

Hello All,

I'm trying to get a filter set on a table/fields, i couldnt find it in its
TableDef.properties collection nor a a direct property unlike form and report
objects, is this property supported for table/field??

Thanks.
 
Yazeed said:
I'm trying to get a filter set on a table/fields, i couldnt find it in its
TableDef.properties collection nor a a direct property unlike form and report
objects, is this property supported for table/field??
Click to expand...


No, tables are just buckets of data, nothing to do with how
the data is selected/presented.

Filtering is strictly a query operation. Specifying a
filter for a form or report is just a convenience that
Access uses behind the scenes with the form/report's record
source. Even when you specify a table as a record source,
Access runs a basic query to retrieve the data records.

Just in case you are using the word "filter"
inappropriately, tables/fields have validation rules that
can be used to prevent unacceptable data from being saved in
a table.
 
Back
Top