2003-> 2010：设置某些子表单的记录源会导致“对象已关闭”错误 [英] 2003->2010: Setting recordsource of some subforms leads to 'object is closed' error

问题描述

我有一个表单，其中包含不同表名列表和另一个选项卡列表。当您选择表名和选项卡然后单击按钮时，将执行以下代码：

Hi,


I have a form which has a list of different table names and another list of tabs. When you select a table name and a tab and then click on a button, the following code is executed:

展开 | < span class =codeLinkonclick =selectAll（this）;>选择 | 换行 | 行号

推荐答案

您好

Access 2003使用ADO作为默认库，Access 2010已恢复为DAO（根据Access 97），因此如果您使用ADO，则必须注册一个ADO dll。


我可能是错误的小溪，但你可以先查看你的参考文献（从代码窗口工具>参考文献），然后添加像Microsoft ActiveX Data Objec这样的东西ts 2.8图书馆。


祝你好运！

S7

Hi
Access 2003 used ADO as the default library and Access 2010 has reverted to DAO (as per Access 97), so if you are using ADO you have to register an ADO dll.

I might be up the wrong creek, but you could start by looking at your References(from a code window Tools>References) then add something like Microsoft ActiveX Data Objects 2.8 Library.

Good luck!
S7

你好S7，


我更改了参考号。到activex 2.8库但我仍然得到相同的错误。感谢您的努力

Hi S7,

I changed the ref. To activex 2.8 library but I still get the same error. thanks for the effort though

您好Avais

对不起，但是您说代码在Access 2003中运行正常，因为您指的是某种类型的对象模型是第一个被怀疑的东西。


试图找出你的代码，我不喜欢之前的空间子表单

Hi Avais
Sorry that did not work but you said the code ran OK in Access 2003 and as you are referring to some type of object model that was the first thing to suspect.

Trying to figure out your code, I don''t like the space before " subform"

展开 | 选择 | Wrap | 行号

这篇关于2003-&gt; 2010：设置某些子表单的记录源会导致“对象已关闭”错误的文章就介绍到这了，希望我们推荐的答案对大家有所帮助，也希望大家多多支持IT屋！