Recordset.Filter不能像MSDN那样工作 [英] Recordset.Filter not working as MSDN says it does

问题描述

我正在尝试过滤记录集。我之前从未这样做过，所以我向MSDN网站寻求帮助，找到了这个网站： Recordset.Filter Property 。以下是我遇到问题的帮助的主要摘录：

I''m attempting to filter a recordset. I had never done this before, so I looked to the MSDN website for help and found this website: Recordset.Filter Property. Here is the main excerpt from the help that I''m having trouble with:

展开 | 选择 | Wrap | 行号

推荐答案

对我来说Seth很好。也许我们看不到有什么不对。


我们看不到记录集的类型，也无法看到它被实例化（设置）的位置。

Looks fine to me Seth. Maybe something wrong that we can''t see.

We can''t see the type of recordset nor can we see where it is instantiated (set up).

试试（）最后......如果代码的其余部分正确设置为rstQuestionLevel
设置rstFiltered = rstQuestionLevel.OpenRecordset （）


看起来类似于此处给出的querydefs示例： Database.OpenRecordset Method（DAO）Office 2010

Try "()" at end... provided the rest of the code is setup correctly for "rstQuestionLevel"
Set rstFiltered = rstQuestionLevel.OpenRecordset()

appears similar to the querydefs example given here: Database.OpenRecordset Method (DAO) Office 2010

只需添加"（）"最后没有改变任何东西。


这是整个程序：

Just adding "()" at the end didn''t change anything.

Here is the whole procedure:

展开 | 选择 | 换行 | 行号

这篇关于Recordset.Filter不能像MSDN那样工作的文章就介绍到这了，希望我们推荐的答案对大家有所帮助，也希望大家多多支持IT屋！