Private Sub 新登记_Click()
Rem 新登记按钮
On Error GoTo Err_新登记_Click
'Me.RecordSource = ""
Dim A, XM, b, c, d
If Me.保存.Enabled = True Then
d = MsgBox("请完成当前作业后再进行新病人登记!", vbOKOnly, "警告:当前数据尚未保存!")
If A = 1 Then
Call Sd_Locked
End If
Else
Me.RecordSource = "CT登记表_LS"
Call QingKong
c = DLookup("count([CT号])", "CT登记表")
Rem 读入CT号的最大值
If c = 0 Then
A = 0
Else
A = DLookup("max([CT号])", "CT登记表")
End If
'End If
Rem 解除控件锁定
Call Js_Locked
Rem 对新CT号重新赋值
'A = Format(Date, "yyyy") & Format(Val(Right(A, 5)))
A = Format(Date, "yyyy") & (Right(A, 5))
Me.CT号 = A + 1
Me.姓名.SetFocus
Me.年龄 = ""
Me.申请医生 = " "
End If
Exit_新登记_Click:
Exit Sub
Err_新登记_Click:
MsgBox Err.Description
Resume Exit_新登记_Click
End Sub
这是我在做CT报告单程序时用的按年度自增号代码,参考着用用看