Table A.24. The Properties and Values Associated with Each Field in the tblErrorLog Table
|
| ErrorSeq | Number (Long) |
| AllowZeroLength | False |
| Attributes | Fixed size, auto-increment |
| CollatingOrder | General |
| ColumnHidden | False |
| ColumnOrder | Default |
| ColumnWidth | Default |
| Description | Unique identifier for the error |
| OrdinalPosition | 0 |
| Required | False |
| SourceField | ErrorSeq |
| SourceTable | tblErrorLog |
| ErrorDate | Date/Time |
| AllowZeroLength | False |
| Attributes | Fixed size |
| CollatingOrder | General |
| ColumnHidden | False |
| ColumnOrder | Default |
| ColumnWidth | Default |
| Description | Date that the error occurred |
| Format | Medium date |
| OrdinalPosition | 1 |
| Required | False |
| SourceField | ErrorDate |
| SourceTable | tblErrorLog |
| ErrorTime | Date/Time |
| AllowZeroLength | False |
| Attributes | Fixed size |
| CollatingOrder | General |
| ColumnHidden | False |
| ColumnOrder | Default |
| ColumnWidth | Default |
| Description | Time that the error occurred |
| Format | Long Time |
| OrdinalPosition | 2 |
| Required | False |
| SourceField | ErrorTime |
| SourceTable | tblErrorLog |
| UserName | Text |
| AllowZeroLength | False |
| Attributes | Variable length |
| CollatingOrder | General |
| ColumnHidden | False |
| ColumnOrder | Default |
| ColumnWidth | Default |
| Description | Name of the user |
| DisplayControl | Text Box |
| OrdinalPosition | 3 |
| Required | False |
| SourceField | UserName |
| SourceTable | tblErrorLog |
| ErrorNum | Number (Integer) |
| AllowZeroLength | False |
| Attributes | Fixed size |
| CollatingOrder | General |
| ColumnHidden | False |
| ColumnOrder | Default |
| ColumnWidth | Default |
| DecimalPlaces | 255 |
| DefaultValue | 0 |
| Description | VBA Error Code |
| DisplayControl | Text Box |
| OrdinalPosition | 4 |
| Required | False |
| SourceField | ErrorNum |
| SourceTable | tblErrorLog |
| ErrorString | Text |
| AllowZeroLength | False |
| Attributes | Variable length |
| CollatingOrder | General |
| ColumnHidden | False |
| ColumnOrder | Default |
| ColumnWidth | Default |
| Description | VBA Error Description |
| DisplayControl | Text Box |
| OrdinalPosition | 5 |
| Required | False |
| SourceField | ErrorString |
| SourceTable | tblErrorLog |
| ModuleName | Text |
| AllowZeroLength | False |
| Attributes | Variable length |
| CollatingOrder | General |
| ColumnHidden | False |
| ColumnOrder | Default |
| ColumnWidth | Default |
| Description | Module in which the error occurred |
| DisplayControl | Text Box |
| OrdinalPosition | 6 |
| Required | False |
| SourceField | Module |
| SourceTable | tblErrorLog |
| RoutineName | Text |
| AllowZeroLength | False |
| Attributes | Variable length |
| CollatingOrder | General |
| ColumnHidden | False |
| ColumnOrder | Default |
| ColumnWidth | Default |
| Description | Routine in which the error occurred |
| DisplayControl | Text Box |
| OrdinalPosition | 7 |
| Required | False |
| SourceField | Routine |
| SourceTable | tblErrorLog |
لطفا منتظر باشید ...
