|
本帖最后由 Henry D. Sy 于 2013-1-13 12:26 编辑
哇老兄你好厉害,多谢多谢了,明天我去单位试一试!
话说我还有一张手机充值卡......
不过这个可以自动 ... - Option Compare Database
- Option Explicit
- Dim strbh As String
- Dim intNo As Integer
- Private Sub Command4_Click()
- Dim sSQL As String
- If Not IsNull(Me.编号) And Not IsNull(Me.名称) Then
- sSQL = "insert into 表1(编号,名称)values('" & strbh & "','" & Me.名称 & "')"
- CurrentDb.Execute sSQL
- sSQL = "delete from bh"
- CurrentDb.Execute sSQL
- sSQL = "insert into bh(bh)values(" & intNo & ")"
- CurrentDb.Execute sSQL
- MsgBox "OK"
- Me.编号 = Null
- Me.名称 = Null
- End If
- End Sub
- Private Sub 名称_GotFocus()
- intNo = Nz(DLookup("bh", "bh"))
- intNo = intNo + 1
- strbh = Format(Date, "yyyy") & "-" & Format(intNo, "0000")
- Me.编号 = strbh
- End Sub
复制代码
|
本帖子中包含更多资源
您需要 登录 才可以下载或查看,没有帐号?注册
x
|