This table logs all application errors encountered while using the hypothetical time and billing application, including error number and the name of the routine and module where the error occurred.
Field Name | Type | Size (Bytes) |
|---|---|---|
ErrorSeq | Number (Long) | 4 |
ErrorDate | Date/Time | 8 |
ErrorTime | Date/Time | 8 |
UserName | Text | 30 |
ErrorNum | Number (Integer) | 2 |
ErrorString | Text | 30 |
ModuleName | Text | 50 |
RoutineName | Text | 50 |
Property | Value |
|---|---|
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 |
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 |
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 |
tblErrorLog |