保存按钮代码如下
On Error GoTo SaveError
Set DTPBuydate.DataSource = Nothing '防止更新出错
RsTool!ToolNo = TxtNo.Text
RsTool!ToolName = txtname.Text
RsTool!Type = CmbType.Text
RsTool!buydate = DTPBuydate.Value
If CmbQuantity.Text = "" Then
RsTool!quantity = 0
Else
RsTool!quantity = Int(CmbQuantity.Text)
End If
RsTool!Maintainer = CmbMaintainer.Text
RsTool!re = TxtRe.Text
Set DTPBuydate.DataSource = RsTool
ConnMain.CommitTrans
On Error GoTo SaveError
Set DTPBuydate.DataSource = Nothing '防止更新出错
RsTool!ToolNo = TxtNo.Text
RsTool!ToolName = txtname.Text
RsTool!Type = CmbType.Text
RsTool!buydate = DTPBuydate.Value
If CmbQuantity.Text = "" Then
RsTool!quantity = 0
Else
RsTool!quantity = Int(CmbQuantity.Text)
End If
RsTool!Maintainer = CmbMaintainer.Text
RsTool!re = TxtRe.Text
Set DTPBuydate.DataSource = RsTool
ConnMain.CommitTrans
解决方案 »
免费领取超大流量手机卡,每月29元包185G流量+100分钟通话, 中国电信官方发货