VBA中的错误陷阱 [英] Error Trap in VBA

问题描述

大家好

我在Access表单中有一个click事件，它基本上有三个子。

它们就像：

Hi All
I have a click event in an Access form which basically does three subs.
They are like:

展开 | 选择 | Wrap | 行号

推荐答案

rajeevs，


我总是建议在所有程序中添加错误捕获/处理项目。基础知识如下：

rajeevs,

I always recommend adding error trapping/handling on all procedures within a project. The basics are as follows:

展开 | 选择 | Wrap | 行号

谢谢twinnyfo

你是如此善良。

我会尝试让你知道进展

Thank you twinnyfo
You are so kind as always.
I will try and let you know the progress

嗨twinnyfo

实际上错误始终发生在process1中。因此，我想停止Process_Click（）子句停止并向用户显示一条消息，而无需继续进行process2。所以你能告诉我如何把错误陷阱放在Process_Click（）中。

Hi twinnyfo
Actually the error occurs always in process1. So I would like to stop the Process_Click() sub to stop and show a message to the user without proceeding to process2 and further. So could you tell me how can I put the error trap in Process_Click().

这篇关于VBA中的错误陷阱的文章就介绍到这了，希望我们推荐的答案对大家有所帮助，也希望大家多多支持IT屋！