|
- Sub 编号() '自动编号On Error Resume Next
- Dim y$
- y = HzToPy(ComboBox1, 1, "", 0, 1)
- If ComboBox1 = "" Then
- MsgBox "数据不完整,请输入要修改内容", vbCritical, ""
- Exit Sub
- End If
- Call mydata
- Sql = " Select count(1) AS 分类记录 from 供方分类 where 分类='" & ComboBox1 & "'"
- With RST
- .Open Sql, CNN, adOpenKeyset, adLockOptimistic
- MsgBox .EOF
- If .EOF Then
- TextBox1.Value = y & "001"
- Else
- TextBox1.Value = y & Format(.Fields("分类记录") + 1, "000")
- '忘了字段名是0开始还是1开始了,这样更简单
- 'TextBox1.Value = y & Format(.Fields(0) + 1, "000")
- 'TextBox1.Value = y & Format(.Fields(1) + 1, "000")
- End If
- End With
-
- Set RST = Nothing
- CNN.Close
- End Sub
复制代码 |
|