Alison Balteramp;#039;s Mastering Microsoft Office Access 1002003 [Electronic resources] نسخه متنی

Using the Err Object

The Err object contains information about the most recent error that occurred. As with all Access objects, it has its own built-in properties and methods. Table 16.1 lists the properties of the Err object.

Table 16.1. Properties of the Err Object

The Err object has only two methods: Clear and Raise. The Clear method enables you to clear an error condition explicitly. This is used primarily when you write code that uses the On Error Resume Next statement. This statement does not clear the error condition. Remember that there is no reason to issue the Clear method explicitly with any type of Resume, Exit Sub, Exit Function, Exit Property, or On Error Goto, or End Sub statement. The Clear method is implicitly issued when these constructs are used. The Raise method of the Err object is covered in the next section.