记录保存问题 [英] Record Saving issue

问题描述

我的数据库存在问题，因为它偶尔会无法保存记录，但按钮按下的其余代码运行完美。


我正在使用：

I am having an issue with my database in that it occasionally fails to save records, but the rest of the code ran by the button works flawlessly.

I am using the :

展开 | 选择 | Wrap | 行号

推荐答案

除非您的代码有错误/警告，否则您应该收到错误消息记录未保存。没有更多细节/看到你的其他代码我没有其他建议。

Unless your code is supressing errors/warnings, you should get an error message when a record is not saved. Without more details/seeing the rest of your code I have no other advice to offer.

错误编码如下：

the error coding is as follows:

展开 | 选择 | Wrap | 行号

很难从你的代码中说出来，但我首先要在你的第一个Select语句中添加一个Case Else。 （作为一个很好的编程实践，我建议总是有一个Case Else。如果你知道它不打算使用，只需在其他情况下添加一个Msgbox，这样如果它发生，你会收到提醒。


我也看不到 RunCommand acCmdSaveRecord 的位置。

Its hard to say from your code, but I would start by adding a Case Else to your first Select statement. (As a good programming practise, I recommend always having a Case Else. If you know that its not meant to be used, simply add a Msgbox within the case else, so that if it should happen, you will be alerted.

Also I dont see where the RunCommand acCmdSaveRecord comes in.

这篇关于记录保存问题的文章就介绍到这了，希望我们推荐的答案对大家有所帮助，也希望大家多多支持IT屋！