經段代碼參考 Private Sub Command1_Click() On Error GoTo ErrLine Dim Sql As String
Sql = "insert into A(ID) values(1)" Cm.ActiveConnection = Cn Cm.CommandText = Sql Cm.ExecuteExit Sub ErrLine: If Err.Number = -2147217900 Then MsgBox "不能插入NULL值" End If End Sub
你最好对插入的字段进行非空处理 function Nonull(byval fieldname as string,byval record as recordset ) as variant if isnull( record.fields(fieldname).valule) then
select case record.fields(fieldname).type '(或者vartype(record.fields(fieldname).value) case addate '对应不同类型处理 end select else nonull=record.fields(fieldname).values endif end function
Private Sub Command1_Click()
On Error GoTo ErrLine
Dim Sql As String
Sql = "insert into A(ID) values(1)"
Cm.ActiveConnection = Cn
Cm.CommandText = Sql
Cm.ExecuteExit Sub
ErrLine:
If Err.Number = -2147217900 Then
MsgBox "不能插入NULL值"
End If
End Sub
'代码......
Err:
MsgBox Err.Description不知道是不是你要的
function Nonull(byval fieldname as string,byval record as recordset ) as variant
if isnull( record.fields(fieldname).valule) then
select case record.fields(fieldname).type '(或者vartype(record.fields(fieldname).value)
case addate '对应不同类型处理 end select
else
nonull=record.fields(fieldname).values
endif
end function