技術(shù) 點(diǎn)
- 技術(shù)
- 點(diǎn)
- V幣
- 點(diǎn)
- 積分
- 53
|
- Private Sub C新增_Click()
- Dim Db As DAO.Database
- Dim rs As DAO.Recordset
-
- Set Db = CurrentDb()
- Set rs = Db.OpenRecordset("收入明細(xì)", dbOpenDynaset)
- '新增記錄
- rs.AddNew
-
- rs!日期 = Me!日期
- rs!收入項(xiàng)目 = Me!收入項(xiàng)目
- rs!收入賬戶 = Me!收入賬戶
- rs!收入金額 = Me!收入金額
- rs!摘要 = Me!摘要
-
- If IsNull(日期) Then
- MsgBox "沒(méi)有輸入'日期'"
- Exit Sub
- End If
- If IsNull(收入項(xiàng)目) Then
- MsgBox "沒(méi)有輸入'收入項(xiàng)目'"
- Exit Sub
- End If
- If IsNull(收入賬戶) Then
- MsgBox "沒(méi)有輸入'收入賬戶'"
- Exit Sub
- End If
- If IsNull(收入金額) Then
- MsgBox "沒(méi)有輸入'收入金額'"
- Exit Sub
- End If
- If DCount("*", "收入明細(xì)", "日期=#" & Me.日期 & " #" And "收入項(xiàng)目='" & Me.收入項(xiàng)目 & "'" And "收入賬戶='" & Me.收入賬戶 & "'" And "收入金額=" & Me.收入金額) > 0 Then
- MsgBox "此數(shù)據(jù)已錄入,請(qǐng)不要重復(fù)添加!"
- Exit Sub
- End If
- '更新記錄
- rs.Update
- Set rs = Nothing
- Me!日期 = Null
- Me!收入項(xiàng)目 = Null
- Me!收入賬戶 = Null
- Me!收入金額 = Null
- Me!摘要 = Null
- MsgBox "新增成功"
- End Sub
復(fù)制代碼 |
本帖子中包含更多資源
您需要 登錄 才可以下載或查看,沒(méi)有帳號(hào)?注冊(cè)
x
|