MS Access上下文菜单筛选器消息该对象不包含自动化对象"me" [英] MS Access context menu filter message The object doesn't contain the Automation object 'me'

问题描述

我有一个在数据表或连续表单视图中打开的表单，其中四个字段绑定到链接表中的文本列.如果右键单击上下文菜单，并在第1列或第2列上筛选等于其中一个值的列，则筛选确定；如果我尝试对字段3或4进行过滤，则会收到消息对象不包含自动化对象'me'".如果我在字段3或4上选择文本过滤器"并输入一些文本，则会过滤确定.

I have a form that I open in either datasheet or continuous forms view with four fields bound to text columns in a linked table. If I right click for the context menu and filter on column 1 or 2 equal to one of the values it filters OK; If I try to filter on field 3 or 4 I get the message "The object doesn't contain the Automation object 'me'". If I select 'Text Filter' on fields 3 or 4 and enter some text, it filters OK.

如果有人能告诉我发生这种情况的原因，以及如何诱捕或阻止它，我将不胜感激.

I would be grateful if anybody that has experienced this can tell me why it happens and how to either trap or stop it.

谢谢

推荐答案

问题在于列上的条件格式.如果我删除条件格式，则通过上下文菜单进行过滤可以正常工作，请替换格式并过滤显示消息(但仍可以正确过滤！)

The problem is with Conditional Formatting on the columns. If I remove conditional formatting, filtering via the context menu works fine, replace the formatting and filtering shows the message (but still filters correctly!!)

这篇关于MS Access上下文菜单筛选器消息该对象不包含自动化对象"me"的文章就介绍到这了，希望我们推荐的答案对大家有所帮助，也希望大家多多支持IT屋！