vba ApplyFilter 和 SetFilter 的区别
声明：本页面是StackOverFlow热门问题的中英对照翻译，遵循CC BY-SA 4.0协议，如果您需要使用它，必须同样遵循CC BY-SA许可，注明原文地址和作者信息，同时你必须将它归于原作者（不是我）：StackOverFlow
原文地址: http://stackoverflow.com/questions/16608478/
Warning: these are provided under cc-by-sa 4.0 license. You are free to use/share it, But you must attribute it to the original authors (not me):
StackOverFlow
Difference Between ApplyFilter and SetFilter
提问by jaromey
What is the difference between the DoCmd.ApplyFilter and DoCmd.SetFilter methods? I looked them up on msdn and I don't see the difference. They even have the same arguements.
DoCmd.ApplyFilter 和 DoCmd.SetFilter 方法之间有什么区别？我在 msdn 上查找了它们，但看不出有什么区别。他们甚至有相同的争论。
采纳答案by craig.white
It (SetFilter) was put in at Version 2010 specifically for tightening the tolerances for the filter (or 'Where' clause) so Access could interact with 1) Web based forms/data and 2) a greater variety of datasources. For more information, see here: http://blogs.office.com/b/microsoft-access/archive/2012/03/19/access-2010-how-to-write-expressions-for-web-queries-forms-and-reports.aspx
它 (SetFilter) 在 2010 版中专门用于收紧过滤器（或“Where”子句）的容差，以便 Access 可以与 1）基于 Web 的表单/数据和 2）更多种类的数据源进行交互。有关更多信息，请参见此处：http: //blogs.office.com/b/microsoft-access/archive/2012/03/19/access-2010-how-to-write-expressions-for-web-queries-forms -and-reports.aspx
They certainly could have done a better job describing the difference, no doubt. But there is one, however obscure. All that said, I wonder if anyone tried using (ApplyFilter) in the Web forms with any success.
毫无疑问，他们当然可以更好地描述差异。但有一个，无论多么晦涩。说了这么多，我想知道是否有人尝试在 Web 表单中使用 (ApplyFilter) 并取得成功。
Craig
克雷格
