Table A.38. The Field Properties of the tblTimeCardHours Table
|
| TimeCardDetailID | Number (Long) |
| AllowZeroLength | False |
| Attributes | Fixed size, auto-increment |
| Caption | Time Card Detail ID |
| CollatingOrder | General |
| ColumnHidden | False |
| ColumnOrder | Default |
| ColumnWidth | Default |
| OrdinalPosition | 0 |
| Required | False |
| SourceField | TimeCardDetailID |
| SourceTable | tblTimeCardHours |
| TimeCardID | Number (Long) |
| AllowZeroLength | False |
| Attributes | Fixed size |
| Caption | Time Card ID |
| CollatingOrder | General |
| ColumnHidden | False |
| ColumnOrder | Default |
| ColumnWidth | Default |
| DecimalPlaces | 255 |
| DisplayControl | Text Box |
| OrdinalPosition | 1 |
| Required | False |
| SourceField | TimeCardID |
| SourceTable | tblTimeCardHours |
| DateWorked | Date/Time |
| AllowZeroLength | False |
| Attributes | Fixed size |
| Caption | Date Worked |
| CollatingOrder | General |
| ColumnHidden | False |
| ColumnOrder | Default |
| ColumnWidth | Default |
| Format | Short date |
| InputMask | 99/99/00 |
| OrdinalPosition | 2 |
| Required | False |
| SourceField | DateWorked |
| SourceTable | tblTimeCardHours |
| ProjectID | Number (Long) |
| AllowZeroLength | False |
| Attributes | Fixed size |
| BoundColumn | 1 |
| Caption | Project ID |
| CollatingOrder | General |
| ColumnCount | 3 |
| ColumnHeads | False |
| ColumnHidden | False |
| ColumnOrder | Default |
| ColumnWidth | Default |
| ColumnWidths | 0;1020;3156 |
| DecimalPlaces | 255 |
| DisplayControl | Combo Box |
| LimitToList | True |
| ListRows | 8 |
| ListWidth | 3 |
| OrdinalPosition | 3 |
| Required | False |
| RowSourceType | Table/Query |
| RowSource | SELECT DISTINCTROW tblProjects.* FROM tblProjects ORDER BY tblProjects.ProjectName; |
| SourceField | ProjectID |
| SourceTable | tblTimeCardHours |
| WorkDescription | Text |
| AllowZeroLength | False |
| Attributes | Variable length |
| Caption | Work Description |
| CollatingOrder | General |
| ColumnHidden | False |
| ColumnOrder | Default |
| ColumnWidth | Default |
| DisplayControl | Text Box |
| OrdinalPosition | 4 |
| Required | False |
| SourceField | WorkDescription |
| SourceTable | tblTimeCardHours |
| BillableHours | Number (Double) |
| AllowZeroLength | False |
| Attributes | Fixed size |
| Caption | Billable Hours |
| CollatingOrder | General |
| ColumnHidden | False |
| ColumnOrder | Default |
| ColumnWidth | Default |
| DecimalPlaces | 255 |
| DisplayControl | Text Box |
| OrdinalPosition | 5 |
| Required | False |
| SourceField | BillableHours |
| SourceTable | tblTimeCardHours |
| BillingRate | Currency |
| AllowZeroLength | False |
| Attributes | Fixed size |
| Caption | Billing Rate |
| CollatingOrder | General |
| ColumnHidden | False |
| ColumnOrder | Default |
| ColumnWidth | Default |
| DecimalPlaces | 2 |
| Format | Currency |
| OrdinalPosition | 6 |
| Required | False |
| SourceField | BillingRate |
| SourceTable | tblTimeCardHours |
| WorkCodeID | Number (Long) |
| AllowZeroLength | False |
| Attributes | Fixed size |
| BoundColumn | 1 |
| Caption | Work Code ID |
| CollatingOrder | General |
| ColumnCount | 2 |
| ColumnHeads | False |
| ColumnHidden | False |
| ColumnOrder | Default |
| ColumnWidth | Default |
| ColumnWidths | 0;2880 |
| DecimalPlaces | 255 |
| DisplayControl | Combo Box |
| LimitToList | True |
| ListRows | 8 |
| ListWidth | 2 |
| OrdinalPosition | 7 |
| Required | False |
| RowSourceType | Table/Query |
| RowSource | SELECT DISTINCTROW tblWorkCodes.* FROM tblWorkCodes ORDER BY tblWorkCodes.WorkCode; |
| SourceField | WorkCodeID |
| SourceTable | tblTimeCardHours |
لطفا منتظر باشید ...
