运行SQL后关闭窗体：错误2585 [英] Close form after running SQL: Error 2585

问题描述

前体：我已经搜索了几个小时并尝试了很多不同的方法，所以如果已经回答了我道歉


我有一个需要登录的数据库我正在添加更改密码表单。表单适用于一个错误的例外;更改密码后我无法关闭表单。我收到错误消息：处理表单或报表事件时无法执行此操作。 （2585）


表tbl_Users

Precursor: "I have searched for several hours and tried a lot of different methods so I apologize if this has been answered"

I have a Log-in required database that I am adding a change password form to. The form works with an exception of one error; I cannot close the form after changing the password. I receive the error: This action can''t be carried out while processing a form or report event. (2585)

Table tbl_Users

展开 | 选择 | Wrap | 行号

推荐答案

用于解决问题注释第7行和第12行

在第9行之后插入

For trouble shooting Comment out line 7 and 12
Insert after line 9

展开 | 选择 | Wrap | 行号

Steven，

我认为问题在于你如何使用这段代码。这段代码是什么事件？无论事件链是什么，您都不能从此处关闭表单。从此代码中删除关闭表单，并选择另一种方法在密码更改后强制关闭表单。


更好的是，解释事件顺序，也许我们可以从你的经验中学习，因为我们试图准确地确定发生的事情。


吉姆

Steven,
I think the problem is in how you got to this code. What event is this code within? Whatever the chain of events has been, you are not allowed to close the form from here. Remove the close form from this code and choose another way to force the form to close after the password changes.

Better yet, explain the event sequence and maybe we can learn from your experience as we try to nail down precisely what happened.

Jim

zmbd


我收到警告消息时唯一收到的是SQL提示，以验证我想要更改1条记录。 SQL打印输出如下。

zmbd

The only thing I receive when taking of the warning messages is the SQL prompt to verify I want to change 1 record. The SQL printout is below.

展开 | 选择 | Wrap | 行号

这篇关于运行SQL后关闭窗体：错误2585的文章就介绍到这了，希望我们推荐的答案对大家有所帮助，也希望大家多多支持IT屋！