Table A.36. The Field Properties of the tblTimeCardExpenses Table
|
| TimeCardExpenseID | Number (Long) |
| AllowZeroLength | False |
| Attributes | Fixed size, auto-increment |
| Caption | Time Card Expense ID |
| CollatingOrder | General |
| ColumnHidden | False |
| ColumnOrder | Default |
| ColumnWidth | Default |
| OrdinalPosition | 0 |
| Required | False |
| SourceField | TimeCardExpenseID |
| SourceTable | tblTimeCardExpenses |
| 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 | tblTimeCardExpenses |
| ExpenseDate | Date/Time |
| AllowZeroLength | False |
| Attributes | Fixed size |
| Caption | Expense Date |
| CollatingOrder | General |
| ColumnHidden | False |
| ColumnOrder | Default |
| ColumnWidth | Default |
| Format | Short date |
| InputMask | 99/99/00 |
| OrdinalPosition | 2 |
| Required | False |
| SourceField | ExpenseDate |
| SourceTable | tblTimeCardExpenses |
| 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 | tblTimeCardExpenses |
| ExpenseDescription | Text |
| AllowZeroLength | False |
| Attributes | Variable length |
| Caption | Expense Description |
| CollatingOrder | General |
| ColumnHidden | False |
| ColumnOrder | Default |
| ColumnWidth | Default |
| DisplayControl | Text Box |
| OrdinalPosition | 4 |
| Required | False |
| SourceField | ExpenseDescription |
| SourceTable | tblTimeCardExpenses |
| ExpenseAmount | Currency |
| AllowZeroLength | False |
| Attributes | Fixed size |
| Caption | Expense Amount |
| CollatingOrder | General |
| ColumnHidden | False |
| ColumnOrder | Default |
| ColumnWidth | Default |
| DecimalPlaces | 2 |
| Format | Currency |
| OrdinalPosition | 5 |
| Required | False |
| SourceField | ExpenseAmount |
| SourceTable | tblTimeCardExpenses |
| ExpenseCodeID | Number (Long) |
| AllowZeroLength | False |
| Attributes | Fixed size |
| BoundColumn | 1 |
| Caption | Expense 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 | 6 |
| Required | False |
| RowSourceType | Table/Query |
| RowSource | SELECT DISTINCTROW tblExpenseCodes.* FROM tblExpenseCodes ORDER BY tblExpenseCodes.Exp enseCode; |
| SourceField | ExpenseCodeID |
| SourceTable | tblTimeCardExpenses |
لطفا منتظر باشید ...
