访问运行时错误 - '-2147352567

Question

"清除按钮"出现错误有两个字段的数据类型为date&时间

Private Sub cmdClear_Click()
Me.SampleCode = ""
Me.ReceivedDate = ""
Me.SampleQuntity = ""
Me.SampleReceivedTime = ""
Me.SampleName = ""
Me.BatchNo = ""
Me.MRANo = ""
Me.Division = ""
Me.SubmittedBy = ""
Me.ReceivedBy = ""
Me.AssignedTo = ""
''focuse on SampleCode txtBox
Me.SampleCode.SetFocus
End Sub

Answer 1

如果没有任何进一步的信息，它要么是：

• 您的接收日期不能接受任何空字符串
  如果不能是Null，则将其设置为类似01-01-1900的值。

• 任何数字字段都应设置为Null或0。

• 可能是你拼错了SampleQuntity。应该是SampleQuantity吗？