帮助“记录被删除”信息 [英] Help with "Record is Deleted" message
问题描述
大家好，
我每次关闭表单时都会弹出一条恼人的消息。由于性能问题，我将数据从SQL Server上的链接表缓存到临时本地表中。用户对存储在本地表中的数据进行更改。然后，当用户关闭表单时，我运行几个快速查询来更新服务器上的数据并删除临时表中的任何数据。代码在表单的Close事件中运行后，我收到一条弹出消息，说Record is Deleted;仅此而已。以下是我的Form_Close事件中的代码：
Hello all,
I have an annoying message popping up every time I close a form. Due to performance issues, I am caching data from a linked table on a SQL Server into a temporary local table. The user makes changes to data that are stored in the local table. Then, when the user closes the form, I run a couple of quick queries to update the data back on the server and delete any data in the temp table. After the code runs in the Close event of the form, I get a popup message saying "Record is Deleted" and nothing more. Here is the code from my Form_Close event:
推荐答案
Hello all，
我每次关闭表单时都会弹出一条恼人的消息。由于性能问题，我将数据从SQL Server上的链接表缓存到临时本地表中。用户对存储在本地表中的数据进行更改。然后，当用户关闭表单时，我运行几个快速查询来更新服务器上的数据并删除临时表中的任何数据。代码在表单的Close事件中运行后，我收到一条弹出消息，说Record is Deleted;仅此而已。以下是我的Form_Close事件中的代码：
Hello all,
I have an annoying message popping up every time I close a form. Due to performance issues, I am caching data from a linked table on a SQL Server into a temporary local table. The user makes changes to data that are stored in the local table. Then, when the user closes the form, I run a couple of quick queries to update the data back on the server and delete any data in the temp table. After the code runs in the Close event of the form, I get a popup message saying "Record is Deleted" and nothing more. Here is the code from my Form_Close event:
感谢您的想法，但那不是''工作。我得到的更多的是警示而不是确认。它是一个标题为Microsoft Office Access的msgbox。内容只是记录被删除。它上面有一个OK和一个帮助按钮。
Thanks for the thought, but that doesn''t work. What I''m getting is more of an alert than a confirmation. It''s a msgbox with the title "Microsoft Office Access." The content is just "Record is deleted." and there is an OK and a help button on it.
感谢您的想法，但这不起作用。我得到的更多的是警示而不是确认。它是一个标题为Microsoft Office Access的msgbox。内容只是记录被删除。并且有一个OK和一个帮助按钮。
Thanks for the thought, but that doesn''t work. What I''m getting is more of an alert than a confirmation. It''s a msgbox with the title "Microsoft Office Access." The content is just "Record is deleted." and there is an OK and a help button on it.
这不是一个警报，否则你的Set Warnings代码就会压制它。根据消息文本，我认为这是错误＃3167。如果是，则需要添加错误处理代码来捕获/拦截它并显示您自己的自定义消息。
It is not an alert, otherwise it would be supressed by your Set Warnings code. Based on the message text, I think it is error #3167. If it is, you need to add error handling code to trap/intercept it and display your own custom message.
这篇关于帮助“记录被删除”信息的文章就介绍到这了，希望我们推荐的答案对大家有所帮助，也希望大家多多支持IT屋！
