运行时错误'424 - 需要对象 [英] Run-Time Error '424 - Object Required
问题描述
早安专家，
我整个周末都在这方面工作，绝对没有。
我有一个带有输入表单的数据库，它运行追加查询以附加到表格。
表格名称：Poetry
追加查询名称：Created_Submitted_Work
表名：Created_Submitted
我还创建了我希望的更新查询。此查询的目的是检查是否存在包含单词的记录？不适用？在表字段[提交到]。我试图通过验证我可以检查表字段来分阶段测试吗？不适用？单击添加记录命令按钮后，在（Created_Submitted。[Submitted To]）字段中。
我经常收到消息？运行时错误''424 - 对象是否必需？但我不知道它指的是什么。我假设它无法访问表来验证字段内容。如果是这种情况，我不知道如何实现它。如果情况并非如此，那么我再也不知道造成这种情况的原因了。
我已经注释了事件中的所有内容，我只是想做一个简单的if if statement to看看它是否有效。
以下是我用来测试的内容：
Good Morning Experts,
I spent all weekend working on this and got absolutely no where.
I have a database with an input form that runs an append query to append to a table.
Form Name: Poetry
Append Query Name: Created_Submitted_Work
Table Name: Created_Submitted
I have also created what I hope is an update query. The purpose of this query is to check whether a record exists that contains the words ?Not Applicable? in the table field [Submitted To]. I am trying to test this in stages by verifying I can examine the table field for ?Not Applicable? in the (Created_Submitted.[Submitted To]) field after clicking the Add Record command button.
I am constantly getting the message ?Run-Time Error ''424 - Object Required?. But I don?t know what it is referring to. I assume it is not able to access the table to verify the field contents. If that is the case I have no idea how to make it happen. If that is not the case, then again, I have no idea what is causing this.
I have commented out everything in the event and am just trying to do s simple if statement to see if it works.
Here is what I used to test that:
推荐答案
您是否尝试过：
Did you try:
感谢Nico ,,
我尝试使用下面的代码并收到了不同的消息。
Thank Nico,,
I tried using the code below and received a differnet message.
感谢Nico ,,
我尝试使用下面的代码并收到不同的消息。
Thank Nico,,
I tried using the code below and received a differnet message.
这篇关于运行时错误'424 - 需要对象的文章就介绍到这了，希望我们推荐的答案对大家有所帮助，也希望大家多多支持IT屋！
