Search in book...
Toggle Font Controls
Create new playlist

Name your new playlist

Playlist description (optional)
Sign In

Email address

Password

Forgot Password?

or

Continue with Facebook

Continue with Google
Sign Up

Full Name

Email address

Confirm Email Address

Password

or

Continue with Facebook

Continue with Google

Appendix A. Table Structures

This appendix gives you a complete listing of all the tables included in the Time and Billing application. Each table includes the following

A list of the field names, types, and lengths of each field in the table
A detailed list of the properties associated with each field in the table

The tblClients Table

This table stores pertinent information about each client, such as the company name, contact name, and phone numbers.

Table A.1. The tblClients Table

Field Name	Type	Size (Bytes)
ClientID	Number (Long)	4
CompanyName	Text	50
ContactFirstName	Text	30
ContactLastName	Text	50
ContactTitle	Text	50
ContactTypeID	Number (Long)	4
ReferredBy	Text	30
AssociatedWith	Text	30
IntroDate	Date/Time	8
DefaultRate	Currency	8
Notes	Memo	(Varies)
Miles	Number (Long)	4
TermTypeID	Number (Long)	3
HomePage	Hyperlink

Table A.2. The Field Properties for Each Field in the tblClients Table

Property	Value
ClientID	Number (Long)
AllowZeroLength	False
Attributes	Fixed size, auto-increment
Caption	Client ID
CollatingOrder	General
Column Hidden	False
ColumnOrder	Default
ColumnWidth	Default
OrdinalPosition	0
Required	False
SourceField	ClientID
SourceTable	tblClients
CompanyName	Text
AllowZeroLength	False
Attributes	Variable length
Caption	Company Name
CollatingOrder	General
ColumnHidden	False
ColumnOrder	Default
ColumnWidth	Default
DisplayControl	Text Box
OrdinalPosition	1
Required	True
SourceField	CompanyName
SourceTable	tblClients
AllowZeroLength	length
CollatingOrder
ColumnHidden
ColumnOrder
ColumnWidth
DisplayControl
OrdinalPosition
SourceField
SourceTable
AllowZeroLength	length
CollatingOrder
ColumnOrder
ColumnWidth
DisplayControl
OrdinalPosition
SourceField
SourceTable
AllowZeroLength	length
CollatingOrder
ColumnHidden
ColumnOrder
ColumnWidth
DefaultValue
DisplayControl
OrdinalPosition
SourceField
SourceTable
AllowZeroLength	length
CollatingOrder
ColumnHidden
ColumnOrder
ColumnWidth
DisplayControl
OrdinalPosition
SourceTable
AllowZeroLength	length
CollatingOrder
ColumnHidden
ColumnOrder
ColumnWidth
DisplayControl
OrdinalPosition
SourceField
SourceTable
ContactFirstName	Text
AllowZeroLength	False
Attributes	Variable length
Caption	Contact First Name
CollatingOrder	General
ColumnHidden	False
ColumnOrder	Default
ColumnWidth	Default
DisplayControl	Text Box
OrdinalPosition	7
Required	False
SourceField	ContactFirstName
SourceTable	tblClients
ContactLastName	Text
AllowZeroLength	False
Attributes	Variable length
Caption	Contact Last Name
CollatingOrder	General
ColumnHidden	False
ColumnOrder	Default
ColumnWidth	Default
DisplayControl	Text Box
OrdinalPosition	8
Required	False
SourceField	ContactLastName
SourceTable	tblClients
ContactTitle	Text
AllowZeroLength	False
Attributes	Variable length
Caption	Contact Title
CollatingOrder	General
ColumnHidden	False
ColumnOrder	Default
ColumnWidth	Default
DisplayControl	Text Box
OrdinalPosition	9
Required	False
SourceField	ContactTitle
SourceTable	tblClients
ContactTypeID	Long Integer
AllowZeroLength	False
Attributes	Fixed size
Caption	Contact Type ID
CollatingOrder	General
ColumnHidden	False
ColumnOrder	Default
ColumnWidth	Default
DataUpdatable	False
DecimalPlaces	Auto
DisplayControl	Text Box
OrdinalPosition	6
Required	False
AllowZeroLength	length
CollatingOrder
ColumnHidden
ColumnOrder
ColumnWidth
DisplayControl
InputMask
SourceField
SourceTable
AllowZeroLength	length
CollatingOrder
ColumnHidden
ColumnOrder
ColumnWidth
DisplayControl
InputMask
OrdinalPosition
SourceField
SourceTable
AllowZeroLength	length
CollatingOrder
ColumnHidden
ColumnOrder
ColumnWidth
DisplayControl
InputMask
OrdinalPosition
SourceField
SourceTable
AllowZeroLength	length
CollatingOrder
ColumnOrder
ColumnWidth
DisplayControl
InputMask
OrdinalPosition
SourceField
SourceTable
AllowZeroLength	length
CollatingOrder
ColumnHidden
ColumnOrder
ColumnWidth
DisplayControl
OrdinalPosition
SourceField
SourceTable
ReferredBy	Text
AllowZeroLength	False
Attributes	Variable length
Caption	Referred By
CollatingOrder	General
ColumnHidden	False
ColumnOrder	Default
ColumnWidth	Default
DisplayControl	Text Box
OrdinalPosition	15
Required	False
SourceField	ReferredBy
SourceTable	tblClients
AssociatedWith	Text
AllowZeroLength	False
Attributes	Variable length
Caption	Associated With
CollatingOrder	General
ColumnHidden	False
ColumnOrder	Default
ColumnWidth	Default
DisplayControl	Text Box
OrdinalPosition	16
Required	False
SourceField	AssociatedWith
SourceTable	tblClients
IntroDate	Date/Time
AllowZeroLength	False
Attributes	Fixed size
Caption	Intro Date
CollatingOrder	General
ColumnHidden	False
ColumnOrder	Default
ColumnWidth	Default
DefaultValue	=Date()
OrdinalPosition	17
Required	True
SourceField	IntroDate
SourceTable	tblClients
ValidationRule	<=Date()
ValidationText	Date Entered Must Be On Or Before Today
DefaultRate	Currency
AllowZeroLength	False
Attributes	Fixed size
Caption	Default Rate
CollatingOrder	General
ColumnHidden	False
ColumnOrder	Default
Column Width	Default
DecimalPlaces	255
DefaultValue	150
Format	Currency
OrdinalPosition	18
Required	False
SourceField	DefaultRate
SourceTable	tblClients
ValidationRule	Between 75 and 200
ValidationText	Rate must be between 75 and 200
Notes	Memo
AllowZeroLength	False
Attributes	Variable length
CollatingOrder	General
ColumnHidden	False
ColumnOrder	Default
ColumnWidth	Default
OrdinalPosition	19
Required	False
SourceField	Notes
SourceTable	tblClients
HomePage	Hyperlink
AllowZeroLength	False
Attributes	Variable length
Caption	Home Page
CollatingOrder	General
ColumnHidden	False
ColumnOrder	Default
ColumnWidth	Default
OrdinalPosition	20
Required	False
SourceField	HomePage
SourceTable	tblClients
Miles	Long Integer
AllowZeroLength	False
Attributes	Fixed size
CollatingOrder	General
ColumnHidden	False
ColumnOrder	Default
ColumnWidth	Default
DataUpdatable	False
DecimalPlaces	Auto
DisplayControl	Text Box
OrdinalPosition	17
Required	False
SourceField	Miles
SourceTable	tblClients
TermTypeID	Long Integer
AllowZeroLength	False
Attributes	Fixed size
Caption	Term Type ID
CollatingOrder	General
ColumnHidden	False
ColumnOrder	Default
ColumnWidth	Default
DataUpdatable	False
DecimalPlaces	Auto
DisplayControl	Text Box
OrdinalPosition	18
Required	False
SourceField	TermTypeID
SourceTable	tblClients

The tblClientAddresses Table

This table stores the addresses for a client. One client can have multiple addresses. Each address has a specific address type.

Table A.3. The tblClientAddresses Table

Field Name	Type	Size (Bytes)
AddressID	Long Integer	4
ClientID	Long Integer	4
Address1	Text	50
Address2	Text	50
City	Text	30
StateProvince	Text	20
PostalCode	Text	20
Country	Text	20
AddressTypeID	Long Integer	4

Table A.4. The Field Properties for Each Field in the tblClientAddresses Table

Property	Value
AddressID	Long Integer
AllowZeroLength	False
Attributes	Fixed size, auto-increment
Caption	Address ID
CollatingOrder	General
ColumnHidden	False
ColumnOrder	Default
ColumnWidth	Default
DataUpdatable	False
OrdinalPosition	1
Required	False
SourceField	AddressID
SourceTable	tblClientAddresses
ClientID	Long Integer
AllowZeroLength	False
Attributes	Fixed size
Caption	Client ID
CollatingOrder	General
ColumnHidden	False
ColumnOrder	Default
ColumnWidth	Default
DataUpdatable	False
DecimalPlaces	Auto
DisplayControl	Text Box
OrdinalPosition	2
Required	False
SourceField	ClientID
SourceTable	tblClientAddresses
Address1	Text
AllowZeroLength	False
Attributes	Variable length
Caption	Address 1
CollatingOrder	General
ColumnHidden	False
ColumnOrder	Default
ColumnWidth	Default
DataUpdatable	False
DisplayControl	Text Box
IMEMode	0
IMESentenceMode	3
OrdinalPosition	3
Required	False
SourceField	Address1
SourceTable	tblClientAddresses
UnicodeCompression	True
Address2	Text
AllowZeroLength	False
Attributes	Variable length
Caption	Address 2
CollatingOrder	General
ColumnHidden	False
ColumnOrder	Default
ColumnWidth	Default
DataUpdatable	False
DisplayControl	Text Box
IMEMode	0
IMESentenceMode	3
OrdinalPosition	4
Required	False
SourceField	Address2
SourceTable	tblClientAddresses
UnicodeCompression	True
City	Text
AllowZeroLength	False
Attributes	Variable length
CollatingOrder	General
ColumnHidden	False
ColumnOrder	Default
ColumnWidth	Default
DataUpdatable	False
DisplayControl	Text Box
IMEMode	0
IMESentenceMode	3
OrdinalPosition	5
Required	False
SourceField	City
SourceTable	tblClientAddresses
UnicodeCompression	True
StateProvince	Text
AllowZeroLength	False
Attributes	Variable length
Caption	State/Province
CollatingOrder	General
ColumnHidden	False
ColumnOrder	Default
ColumnWidth	Default
DataUpdatable	False
DisplayControl	Text Box
IMEMode	0
IMESentenceMode	3
OrdinalPosition	6
Required	False
SourceTable	tblClientAddresses
UnicodeCompression	True
PostalCode	Text
AllowZeroLength	False
Attributes	Variable length
Caption	Postal Code
CollatingOrder	General
ColumnHidden	False
ColumnOrder	Default
ColumnWidth	Default
DataUpdatable	False
DisplayControl	Text Box
IMEMode	0
IMESentenceMode	3
OrdinalPosition	7
Required	False
SourceField	PostalCode
SourceTable	tblClientAddresses
UnicodeCompression	True
Country	Text
AllowZeroLength	False
Attributes	Variable length
CollatingOrder	General
ColumnHidden	False
ColumnOrder	Default
ColumnWidth	Default
DataUpdatable	False
DisplayControl	Text Box
IMEMode	0
IMESentenceMode	3
OrdinalPosition	8
Required	False
SourceField	Country
SourceTable	tblClientAddresses
UnicodeCompression	True
AddressTypeID	Long Integer
AllowZeroLength	False
Attributes	Fixed size
Caption	Address Type ID
CollatingOrder	General
ColumnHidden	False
ColumnOrder	Default
ColumnWidth	Default
DataUpdatable	False
DecimalPlaces	Auto
DisplayControl	Text Box
OrdinalPosition	9
Required	False
SourceField	AddressTypeID
SourceTable	tblClientAddresses

The tblAddressTypes Table

This table stores the valid address types. It relates to the tblClientAddresses table and is a lookup table for the AddressTypeID stored in the tblClientAddresses table.

Table A.5. The tblAddressTypes Table

Field Name	Type	Size (Bytes)
AddressTypeID	Long Integer	4
AddressType	Text	50

Table A.6. The Field Properties for Each Field in the tblAddressTypes Table

Property	Value
AddressTypeID	Long Integer
AllowZeroLength	False
Attributes	Fixed size, auto-increment
Caption	Address Type ID
CollatingOrder	General
ColumnHidden	False
ColumnOrder	Default
ColumnWidth	Default
DataUpdatable	False
OrdinalPosition	1
Required	False
SourceField	AddressTypeID
SourceTable	tblAddressTypes
AddressType	Text
AllowZeroLength	False
Attributes	Variable length
Caption	Address Type
CollatingOrder	General
ColumnHidden	False
ColumnOrder	Default
ColumnWidth	Default
DataUpdatable	False
DisplayControl	Text Box
IMEMode	0
IMESentenceMode	3
OrdinalPosition	2
Required	False
SourceField	AddressType
SourceTable	tblAddressTypes
UnicodeCompression	True

The tblClientPhones Table

This table stores the phone numbers for a client. One client can have multiple phone numbers. Each address has a specific phone type.

Table A.7. The Field Properties for Each Field in the tblClientPhones Table

Field Name	Type	Size (Bytes)
PhoneID	Long Integer	4
ClientID	Long Integer	4
PhoneNumber	Text	50
PhoneTypeID	Long Integer	4

Table A.8. The Field Properties for Each Field in the tblClientPhones Table

Property	Value
PhoneID	Long Integer
AllowZeroLength	False
Attributes	Fixed size, auto-increment
Caption	Phone ID
CollatingOrder	General
ColumnHidden	False
ColumnOrder	Default
ColumnWidth	Default
DataUpdatable	False
OrdinalPosition	1
Required	False
SourceField	PhoneID
SourceTable	tblClientPhones
ClientID	Long Integer
AllowZeroLength	False
Attributes	Fixed size
Caption	Client ID
CollatingOrder	General
ColumnHidden	False
ColumnOrder	Default
ColumnWidth	Default
DataUpdatable	False
DecimalPlaces	Auto
DisplayControl	Text Box
OrdinalPosition	2
Required	False
SourceField	ClientID
SourceTable	tblClientPhones
PhoneNumber	Text
AllowZeroLength	False
Attributes	Variable length
Caption	Phone Number
CollatingOrder	General
ColumnHidden	False
ColumnOrder	Default
ColumnWidth	Default
DataUpdatable	False
DisplayControl	Text Box
IMEMode	0
IMESentenceMode	3
OrdinalPosition	3
Required	False
SourceField	PhoneNumber
SourceTable	tblClientPhones
UnicodeCompression	True
PhoneTypeID	Long Integer
AllowZeroLength	False
Attributes	Fixed size
Caption	Phone Type ID
CollatingOrder	General
ColumnHidden	False
ColumnOrder	Default
ColumnWidth	Default
DataUpdatable	False
DecimalPlaces	Auto
DisplayControl	Text Box
OrdinalPosition	4
Required	False
SourceField	PhoneTypeID
SourceTable	tblClientPhones

The tblPhoneTypes Table

This table stores the valid phone types. It relates to the tblClientPhones table and is a lookup table for the PhoneTypeID stored in the tblClientPhones table.

Table A.9. The tblPhoneTypes Table

Field Name	Type	Size (Bytes)
PhoneTypeID	Long Integer	4
PhoneType	Text	50

Table A.10. The Field Properties for Each Field in the tblPhonesTypes Table

Property	Value
PhoneTypeID	Long Integer
AllowZeroLength	False
Attributes	Fixed size, auto-increment
Caption	Phone Type ID
CollatingOrder	General
ColumnHidden	False
ColumnOrder	Default
ColumnWidth	Default
DataUpdatable	False
OrdinalPosition	1
Required	False
SourceField	PhoneTypeID
SourceTable	tblPhoneTypes
PhoneType	Text
AllowZeroLength	False
Attributes	Variable length
Caption	Phone Type
CollatingOrder	General
ColumnHidden	False
ColumnOrder	Default
ColumnWidth	Default
DataUpdatable	False
DisplayControl	Text Box
IMEMode	0
IMESentenceMode	3
OrdinalPosition	2
Required	False
SourceField	PhoneType
SourceTable	tblPhoneTypes
UnicodeCompression	True

The tblCorrespondence Table

The tblCorrespondence table contains a history of correspondence made to a particular client. It relates to the tblClients table.

Table A.11. The tblCorrespondence Table

Field Name	Type	Size (Bytes)
CorrespondenceID	Long Integer	4
ClientID	Long Integer	4
Description	Text	50
Notes	Memo	-
DateSent	Date/Time	8
CorrespondenceTypeID	Long Integer	4
ConsultantID	Long Integer	4
Document	OLE Object	-

Table A.12. The Field Properties for Each Field in the tblCorrespondence Table

Property	Value
CorrespondenceID	Long Integer
AllowZeroLength	False
Attributes	Fixed size, auto-increment
Caption
Correspondence ID
CollatingOrder	General
ColumnHidden	False
ColumnOrder	Default
ColumnWidth	Default
DataUpdatable	False
OrdinalPosition	1
Required	False
SourceField	CorrespondenceID
SourceTable	tblCorrespondence
ClientID	Long Integer
AllowZeroLength	False
Attributes	Fixed size
Caption	Client ID
CollatingOrder	General
ColumnHidden	False
ColumnOrder	Default
ColumnWidth	Default
DataUpdatable	False
DecimalPlaces	Auto
DisplayControl	Text Box
OrdinalPosition	2
Required	False
SourceField	ClientID
SourceTable	tblCorrespondence
Description	Text
AllowZeroLength	False
Attributes	Variable length
CollatingOrder	General
ColumnHidden	False
ColumnOrder	Default
ColumnWidth	Default
DataUpdatable	False
DisplayControl	Text Box
IMEMode	0
IMESentenceMode	3
OrdinalPosition	3
Required	False
SourceField	Description
SourceTable	tblCorrespondence
UnicodeCompression	True
Notes	Memo
AllowZeroLength	False
Attributes	Variable length
CollatingOrder	General
ColumnHidden	False
ColumnOrder	Default
ColumnWidth	Default
DataUpdatable	False
IMEMode	0
IMESentenceMode	3
OrdinalPosition	4
Required	False
SourceField	Notes
SourceTable	tblCorrespondence
UnicodeCompression	True
DateSent	Date/Time
AllowZeroLength	False
Attributes	Fixed size
Caption	Date Sent
CollatingOrder	General
ColumnHidden	False
ColumnOrder	Default
ColumnWidth	Default
DataUpdatable	False
IMEMode	0
IMESentenceMode	3
InputMask	99/99/0000
OrdinalPosition	5
Required	False
SourceField	DateSent
SourceTable	tblCorrespondence
CorrespondenceTypeID	Long Integer
AllowZeroLength	False
Attributes	Fixed size
Caption	Correspondence Type ID
CollatingOrder	General
ColumnHidden	False
ColumnOrder	Default
ColumnWidth	Default
DataUpdatable	False
DecimalPlaces	Auto
DisplayControl	Text Box
OrdinalPosition	6
Required	False
SourceField	CorrespondenceTypeID
SourceTable	tblCorrespondence
ConsultantID	Long Integer
AllowZeroLength	False
Attributes	Fixed size
Caption	Consultant ID
CollatingOrder	General
ColumnHidden	False
ColumnOrder	Default
ColumnWidth	Default
DataUpdatable	False
DecimalPlaces	Auto
DisplayControl	Text Box
OrdinalPosition	7
Required	False
SourceField	ConsultantID
SourceTable	tblCorrespondence
Document	OLE Object
AllowZeroLength	False
Attributes	Variable length
CollatingOrder	General
ColumnHidden	False
ColumnOrder	Default
ColumnWidth	Default
DataUpdatable	False
OrdinalPosition	8
Required	False
SourceField	Document
SourceTable	tblCorrespondence

The tblCorrespondenceTypes Table

This table stores the valid correspondence types. It relates to the tblCorrespondence table and is a lookup table for the CorrespondenceTypeID stored in the tblCorrespondence table.

Table A.13. The tblCorrespondenceTypes Table

Field Name	Type	Size (Bytes)
CorrespondenceTypeID	Long Integer	4
CorrespondenceType	Text	50

Table A.12. The Field Properties for Each Field in the tblCorrespondenceTypes Table

Property	Value
CorrespondenceTypeID	Long Integer
AllowZeroLength	False
Attributes	Fixed size, auto-increment
Caption	Correspondence Type ID
CollatingOrder	General
ColumnHidden	False
ColumnOrder	Default
ColumnWidth	Default
DataUpdatable	False
OrdinalPosition	1
Required	False
SourceField	CorrespondenceTypeID
SourceTable	tblCorrespondenceTypes
CorrespondenceType	Text
AllowZeroLength	False
Attributes	Variable length
Caption	Correspondence Type
CollatingOrder	General
ColumnHidden	False
ColumnOrder	Default
ColumnWidth	Default
DataUpdatable	False
DisplayControl	Text Box
IMEMode	0
IMESentenceMode	3
OrdinalPosition	2
Required	False
SourceField	CorrespondenceType
SourceTable	tblCorrespondenceTypes
UnicodeCompression	True

The tblTerms Table

This table stores the valid term types. It relates to the tblClients table and is a lookup table for the TermTypeID stored in the tblClients table.

Table A.15. The tblTerms Table

Field Name	Type	Size (Bytes)
TermTypeID	Long Integer	4
TermType	Text	50

Table A.16. The Field Properties for Each Field in the tblTerms Table

Property	Value
TermTypeID	Long Integer
AllowZeroLength	False
Attributes	Fixed size, auto-increment
Caption	Term Type ID
CollatingOrder	General
ColumnHidden	False
ColumnOrder	Default
ColumnWidth	Default
DataUpdatable	False
OrdinalPosition	1
Required	False
SourceField	TermTypeID
SourceTable	tblTerms
TermType	Text
AllowZeroLength	False
Attributes	Variable length
Caption	Term Type
CollatingOrder	General
ColumnHidden	False
ColumnOrder	Default
ColumnWidth	Default
DataUpdatable	False
DisplayControl	Text Box
IMEMode	0
IMESentenceMode	3
OrdinalPosition	2
Required	False
SourceField	TermType
SourceTable	tblTerms
UnicodeCompression	True

The tblContactTypes Table

This table stores the valid contact types. It relates to the tblClients table and is a lookup table for the ContactTypeID stored in the tblClients table.

Table A.17. The tblContactTypes Table

Field Name	Type	Size (Bytes)
ContactTypeID	Long Integer	4
ContactType	Text	50

Table A.18. The Field Properties for Each Field in the tblContactTypes Table

Property	Value
ContactTypeID	Long Integer
AllowZeroLength	False
Attributes	Fixed size, auto-increment
Caption	Contact Type ID
CollatingOrder	General
ColumnHidden	False
ColumnOrder	Default
ColumnWidth	Default
DataUpdatable	False
OrdinalPosition	1
Required	False
SourceField	ContactTypeID
SourceTable	tblContactType
ContactType	Text
AllowZeroLength	False
Attributes	Variable length
Caption	Contact Type
CollatingOrder	General
ColumnHidden	False
ColumnOrder	Default
ColumnWidth	Default
DataUpdatable	False
DisplayControl	Text Box
IMEMode	0
IMESentenceMode	3
OrdinalPosition	2
Required	False
SourceField	ContactType
SourceTable	tblContactType
UnicodeCompression	True

The tblCompanyInfo Table

This table stores information about your company, including address and default payment terms.

Table A.19. The tblCompanyInfo Table

Field Name	Type	Size (Bytes)
SetupID	Number (Long)	4
CompanyName	Text	50
Address	Text	255
City	Text	50
StateProvince	Text	20
PostalCode	Text	20
Country	Text	50
PhoneNumber	Text	30
FaxNumber	Text	30
DefaultPaymentTerms	Text	255
DefaultInvoiceDescription	Memo	(varies)

Table A.20. The Properties of Each Field Included in the tblCompanyInfo Table

Property	Value
SetupID	Number (Long)
AllowZeroLength	False
Attributes	Fixed size, auto-increment
Caption	SetupID
CollatingOrder	General
ColumnHidden	False
ColumnOrder	Default
ColumnWidth	Default
OrdinalPosition	0
Required	False
SourceField	SetupID
SourceTable	tblCompanyInfo
CompanyName	Text
AllowZeroLength	False
Attributes	Variable length
Caption	Company Name
CollatingOrder	General
Column Hidden	False
ColumnOrder	Default
ColumnWidth	Default
DisplayControl	Text Box
OrdinalPosition	1
Required	False
SourceField	CompanyName
SourceTable	tblCompanyInfo
Address	Text
AllowZeroLength	False
Attributes	Variable length
CollatingOrder	General
ColumnHidden	False
ColumnOrder	Default
ColumnWidth	Default
DisplayControl	Text Box
OrdinalPosition	2
Required	False
SourceField	Address
SourceTable	tblCompanyInfo
City	Text
AllowZeroLength	False
Attributes	Variable length
CollatingOrder	General
Column Hidden	False
ColumnOrder	Default
ColumnWidth	Default
DisplayControl	Text Box
OrdinalPosition	3
Required	False
SourceField	City
SourceTable	tblCompanyInfo
StateProvince	Text
AllowZeroLength	False
Attributes	Variable length
Caption	State/Province
CollatingOrder	General
Column Hidden	False
ColumnOrder	Default
ColumnWidth	Default
DisplayControl	Text Box
OrdinalPosition	4
Required	False
SourceField	StateProvince
SourceTable	tblCompanyInfo
PostalCode	Text
AllowZeroLength	False
Attributes	Variable length
Caption	Postal Code
CollatingOrder	General
ColumnHidden	False
ColumnOrder	Default
ColumnWidth	Default
DisplayControl	Text Box
InputMask	00000-9999
OrdinalPosition	5
Required	False
SourceField	PostalCode
SourceTable	tblCompanyInfo
Country	Text
AllowZeroLength	False
Attributes	Variable length
CollatingOrder	General
ColumnHidden	False
ColumnOrder	Default
ColumnWidth	Default
DisplayControl	Text Box
OrdinalPosition	6
Required	False
SourceField	Country
SourceTable	tblCompanyInfo
PhoneNumber	Text
AllowZeroLength	False
Attributes	Variable length
Caption	Phone Number
CollatingOrder	General
Column Hidden	False
ColumnOrder	Default
ColumnWidth	Default
DisplayControl	Text Box
InputMask	!(999”) “000-0000
OrdinalPosition	7
Required	False
SourceField	PhoneNumber
SourceTable	tblCompanyInfo
FaxNumber	Text
AllowZeroLength	False
Attributes	Variable length
Caption	Fax Number
CollatingOrder	General
ColumnHidden	False
ColumnOrder	Default
ColumnWidth	Default
DisplayControl	Text Box
InputMask	!(999”) “000-0000
OrdinalPosition	8
Required	False
SourceField	FaxNumber
SourceTable	tblCompanyInfo
DefaultPaymentTerms	Text
AllowZeroLength	False
Attributes	Variable length
Caption	Default Payment Terms
CollatingOrder	General
ColumnHidden	False
ColumnOrder	Default
ColumnWidth	Default
DisplayControl	Text Box
OrdinalPosition	9
Required	False
SourceField	DefaultPaymentTerms
SourceTable	tblCompanyInfo
DefaultInvoiceDescription	Memo
AllowZeroLength	False
Attributes	Variable length
Caption	Default Invoice Description
CollatingOrder	General
ColumnHidden	False
ColumnOrder	Default
ColumnWidth	Default
OrdinalPosition	10
Required	False
SourceField	DefaultInvoiceDescription
SourceTable	tblCompanyInfo

The tblEmployees Table

This table includes relevant employee information, such as name, address, and billing rate.

Table A.21. The tblEmployees Table

Field Name	Type	Size (Bytes)
EmployeeID	Number (Long)	4
FirstName	Text	50
LastName	Text	50
Title	Text	50
EmailName	Text	50
Extension	Text	30
Address	Text	255
City	Text	50
StateOrProvince	Text	20
PostalCode	Text	20
Country	Text	50
HomePhone	Text	30
WorkPhone	Text	30
BillingRate	Currency	8

Table A.22. The Properties of Each Field Included in the tblEmployees Table

Property	Value
EmployeeID	Number (Long)
AllowZeroLength	False
Attributes	Fixed size, auto-increment
Caption	Employee ID
CollatingOrder	General
OrdinalPosition	0
Required	False
SourceField	EmployeeID
SourceTable	tblEmployees
FirstName	Text
AllowZeroLength	False
Attributes	Variable length
Caption	First Name
CollatingOrder	General
OrdinalPosition	1
Required	False
SourceField	FirstName
SourceTable	tblEmployees
LastName	Text
AllowZeroLength	False
Attributes	Variable length
Caption	Last Name
CollatingOrder	General
Ordinal Position	2
Required	False
SourceField	LastName
SourceTable	tblEmployees
Title	Text
AllowZeroLength	False
Attributes	Variable length
CollatingOrder	General
OrdinalPosition	3
Required	False
SourceField	Title
SourceTable	tblEmployees
EmailName	Text
AllowZeroLength	False
Attributes	Variable length
Caption	Email Name
CollatingOrder	General
OrdinalPosition	4
Required	False
SourceField	EmailName
SourceTable	tblEmployees
Extension	Text
AllowZeroLength	False
Attributes	Variable length
CollatingOrder	General
OrdinalPosition	5
Required	False
SourceField	Extension
SourceTable	tblEmployees
Address	Text
AllowZeroLength	False
Attributes	Variable length
CollatingOrder	General
OrdinalPosition	6
Required	False
SourceField	Address
SourceTable	tblEmployees
City	Text
AllowZeroLength	False
Attributes	Variable length
CollatingOrder	General
OrdinalPosition	7
Required	False
SourceField	City
SourceTable	tblEmployees
StateOrProvince	Text
AllowZeroLength	False
Attributes	Variable length
Caption	State/Province
CollatingOrder	General
OrdinalPosition	8
Required	False
SourceField	StateOrProvince
SourceTable	tblEmployees
PostalCode	Text
AllowZeroLength	False
Attributes	Variable length
Caption	Postal Code
CollatingOrder	General
InputMask	00000-9999
OrdinalPosition	9
Required	False
SourceField	PostalCode
SourceTable	tblEmployees
Country	Text
AllowZeroLength	False
Attributes	Variable length
CollatingOrder	General
OrdinalPosition	10
Required	False
SourceField	Country
SourceTable	tblEmployees
HomePhone	Text
AllowZeroLength	False
Attributes	Variable length
Caption	Home Phone
CollatingOrder	General
InputMask	!(999) 000-0000
OrdinalPosition	11
Required	False
SourceField	HomePhone
SourceTable	tblEmployees
WorkPhone	Text
AllowZeroLength	False
Attributes	Variable length
Caption	Work Phone
CollatingOrder	General
InputMask	!(999) 000-0000
OrdinalPosition	12
Required	False
SourceField	WorkPhone
SourceTable	tblEmployees
BillingRate	Currency
AllowZeroLength	False
Attributes	Fixed size
Caption	Billing Rate
CollatingOrder	General
DecimalPlaces	2
Format	Currency
OrdinalPosition	13
Required	False
SourceField	BillingRate
SourceTable	tblEmployees

The tblErrorLog Table

This table logs all application errors encountered while using the Time and Billing application, including error number and the name of the routine and module where the error occurred.

Table A.23. The tblErrorLog Table

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

Table A.24. The Properties and Values Associated with Each Field in the tblErrorLog Table

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
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
Column Hidden	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

The tblErrors Table

This table gives you information about how your application should respond to error numbers.

Table A.25. The tblErrors Table

Field Name	Type	Size (Bytes)
ErrorNum	Number (Long)	4
Response	Number (Long)	4

Table A.26. The Properties and Values Associated with Each Field in the tblErrors Table

Property	Value
ErrorNum	Number (Long)
AllowZeroLength	False
Attributes	Fixed size
CollatingOrder	General
ColumnHidden	False
ColumnOrder	Default
ColumnWidth	Default
DecimalPlaces	255
DefaultValue	0
Description	Number of the error
DisplayControl	Text Box
OrdinalPosition	0
Required	False
SourceField	ErrorNum
SourceTable	tblErrors
Response	Number (Long)
AllowZeroLength	False
Attributes	Fixed size
CollatingOrder	General
ColumnHidden	False
ColumnOrder	Default
ColumnWidth	Default
DecimalPlaces	255
DefaultValue	0
Description	Action to take
DisplayControl	Text Box
OrdinalPosition	1
Required	False
SourceField	Response
SourceTable	tblErrors

The tblExpenseCodes Tables

This table contains all the valid expense codes used in the Time and Billing application.

Table A.27. The tblExpenseCodes

Field Name	Type	Size (Bytes)
ExpenseCodeID	Number (Long)	4
ExpenseCode	Text	30

Table A.28. The Field Properties of the tblExpenseCodes Table

Property	Value
ExpenseCodeID	Number (Long)
AllowZeroLength	False
Attributes	Fixed size, auto-increment
Caption	Expense Code ID
CollatingOrder	General
OrdinalPosition	0
Required	False
SourceField	ExpenseCodeID
SourceTable	tblExpenseCodes
ExpenseCode	Text
AllowZeroLength	False
Attributes	Variable length
Caption	Expense Code
CollatingOrder	General
OrdinalPosition	1
Required	False
SourceField	ExpenseCode
SourceTable	tblExpenseCodes

The tblPaymentMethods Table

This table lists the valid payment methods.

Table A.29. The tblPaymentMethods Table

Field Name	Type	Size (Bytes)
PaymentMethodID	Number (Long)	4
PaymentMethod	Text	50
CreditCard	Yes/No	1

Table A.30. The Field Properties of the tblPaymentMethods Table

Property	Value
PaymentMethodID	Number (Long)
AllowZeroLength	False
Attributes	Fixed size, auto-increment
Caption	Payment Method ID
CollatingOrder	General
OrdinalPosition	0
Required	False
SourceField	PaymentMethodID
SourceTable	tblPaymentMethods
PaymentMethod	Text
AllowZeroLength	False
Attributes	Variable length
Caption	Payment Method
CollatingOrder	General
OrdinalPosition	1
Required	False
SourceField	PaymentMethod
SourceTable	tblPaymentMethods
CreditCard	Yes/No
AllowZeroLength	False
Attributes	Fixed size
Caption	Credit Card?
CollatingOrder	General
Format	Yes/No
OrdinalPosition	2
Required	False
SourceField	CreditCard
SourceTable	tblPaymentMethods

The tblPayments Table

This table stores client payment information, such as the amount and date of payment for particular projects.

Table A.31. The tblPayments Table

Field Name	Type	Size (Bytes)
PaymentID	Number (Long)	4
ProjectID	Number (Long)	4
PaymentAmount	Currency	8
PaymentDate	Date/Time	8
CreditCardNumber	Text	30
CardholdersName	Text	50
CreditCardExpDate	Date/Time	8
PaymentMethodID	Number (Long)	4

Table A.32. The Field Properties of the tblPayments Table

Property	Value
PaymentID	Number (Long)
AllowZeroLength	False
Attributes	Fixed size, auto-increment
Caption	Payment ID
CollatingOrder	General
ColumnHidden	False
ColumnOrder	Default
ColumnWidth	Default
OrdinalPosition	0
Required	False
SourceField	PaymentID
SourceTable	tblPayments
ProjectID	Number (Long)
AllowZeroLength	False
Attributes	Fixed size
Caption	Project ID
CollatingOrder	General
ColumnHidden	False
ColumnOrder	Default
ColumnWidth	Default
DecimalPlaces	255
DisplayControl	Text Box
OrdinalPosition	1
Required	False
SourceField	ProjectID
SourceTable	tblPayments
PaymentAmount	Currency
AllowZeroLength	False
Attributes	Fixed size
Caption	Payment amount
CollatingOrder	General
Column Hidden	False
ColumnOrder	Default
ColumnWidth	Default
DecimalPlaces	2
Format	Currency
OrdinalPosition	2
Required	False
SourceField	PaymentAmount
SourceTable	tblPayments
PaymentDate	Date/Time
AllowZeroLength	False
Attributes	Fixed size
Caption	Payment date
CollatingOrder	General
ColumnHidden	False
ColumnOrder	Default
ColumnWidth	Default
Format	Short date
InputMask	99/99/00
OrdinalPosition	3
Required	False
SourceField	PaymentDate
SourceTable	tblPayments
CreditCardNumber	Text
AllowZeroLength	False
Attributes	Variable length
Caption	Credit Card #
CollatingOrder	General
ColumnHidden	False
ColumnOrder	Default
ColumnWidth	Default
DisplayControl	Text Box
OrdinalPosition	4
Required	False
SourceField	CreditCardNumber
SourceTable	tblPayments
CardholdersName	Text
AllowZeroLength	False
Attributes	Variable length
Caption	Cardholder Name
CollatingOrder	General
ColumnHidden	False
ColumnOrder	Default
ColumnWidth	Default
DisplayControl	Text Box
OrdinalPosition	5
Required	False
SourceField	CardholdersName
SourceTable	tblPayments
CreditCardExpDate	Date/Time
AllowZeroLength	False
Attributes	Fixed size
Caption	Card Exp. Date
CollatingOrder	General
ColumnHidden	False
ColumnOrder	Default
ColumnWidth	Default
Format	Short date
InputMask	99/99/00
OrdinalPosition	6
Required	False
SourceField	CreditCardExpDate
SourceTable	tblPayments
PaymentMethodID	Number (Long)
AllowZeroLength	False
Attributes	Fixed size
Bound Column	1
Caption	Payment Method ID
CollatingOrder	General
Column Count	3
Column Heads	False
ColumnHidden	False
ColumnOrder	Default
ColumnWidth	Default
ColumnWidths	0;1440;0
DecimalPlaces	255
DisplayControl	Combo Box
LimitToList	True
ListRows	8
ListWidth	1
OrdinalPosition	7
Required	False
RowSource Type	Table/Query
RowSource	SELECT DISTINCTROW tblPaymentMethods.* FROM tblPaymentMethods ORDER BY tblPaymentMethods.PaymentMethod;
SourceField	PaymentMethodID
SourceTable	tblPayments

The tblProjects Table

This table stores information about each project, including a cost estimate and important dates.

Table A.33. The tblProjects Table

Field Name	Type	Size (Bytes)
ProjectID	Number (Long)	4
ProjectName	Text	50
ProjectDescription	Memo	n/a
ClientID	Number (Long)	4
PurchaseOrderNumber	Text	50
ProjectTotalEstimate	Currency	8
EmployeeID	Number (Long)	4
ProjectBeginDate	Date/Time	8
ProjectEndDate	Date/Time	8

Table A.34. The Field Properties of the tblProjects Table

Property	Value
ProjectID	Number (Long)
AllowZeroLength	False
Attributes	Fixed size, auto-increment
Caption	Project ID
CollatingOrder	General
ColumnHidden	False
ColumnOrder	Default
ColumnWidth	Default
OrdinalPosition	0
Required	False
SourceField	ProjectID
SourceTable	tblProjects
ProjectName	Text
AllowZeroLength	False
Attributes	Variable length
Caption	Project Name
CollatingOrder	General
ColumnHidden	False
ColumnOrder	Default
ColumnWidth	Default
DisplayControl	Text Box
OrdinalPosition	1
Required	True
SourceField	ProjectName
SourceTable	tblProjects
ProjectDescription	Memo
AllowZeroLength	False
Attributes	Variable length
Caption	Project Description
CollatingOrder	General
ColumnHidden	False
ColumnOrder	Default
Column Width	Default
OrdinalPosition	2
Required	False
SourceField	ProjectDescription
SourceTable	tblProjects
ClientID	Number (Long)
AllowZeroLength	False
Attributes	Fixed size
Bound Column	1
Caption	Client ID
CollatingOrder	General
ColumnCount	2
ColumnHeads	False
ColumnHidden	False
ColumnOrder	Default
ColumnWidth	Default
ColumnWidths	;14400
DecimalPlaces	255
DefaultValue	0
DisplayControl	Combo Box
LimitToList	True
ListRows	8
ListWidth	1
OrdinalPosition	3
Required	True
RowSourceType	Table/Query
RowSource	SELECT DISTINCTROW [tblClients].[ClientID], [tblClients].[CompanyName] FROM [tblClients];
SourceField	ClientID
SourceTable	tblProjects
PurchaseOrderNumber	Text
AllowZeroLength	False
Attributes	Variable length
Caption	Purchase Order Number
CollatingOrder	General
Column Hidden	False
ColumnOrder	Default
ColumnWidth	Default
DisplayControl	Text Box
OrdinalPosition	4
Required	False
SourceField	PurchaseOrderNumber
SourceTable	tblProjects
ProjectTotalEstimate	Currency
AllowZeroLength	False
Attributes	Fixed size
Caption	ProjectTotalEstimate
CollatingOrder	General
ColumnHidden	False
ColumnOrder	Default
ColumnWidth	Default
DecimalPlaces	255
DefaultValue	0
Format	Currency
OrdinalPosition	5
Required	False
SourceField	ProjectTotalEstimate
SourceTable	tblProjects
EmployeeID	Number (Long)
AllowZeroLength	False
Attributes	Fixed size
Caption	Employee ID
CollatingOrder	General
ColumnHidden	False
ColumnOrder	Default
ColumnWidth	Default
DecimalPlaces	255
DefaultValue	0
DisplayControl	Text Box
OrdinalPosition	6
Required	False
SourceField	EmployeeID
SourceTable	tblProjects
ProjectBeginDate	Date/Time
AllowZeroLength	False
Attributes	Fixed size
Caption	Project Begin Date
CollatingOrder	General
ColumnHidden	False
ColumnOrder	Default
ColumnWidth	Default
OrdinalPosition	7
Required	False
SourceField	ProjectBeginDate
SourceTable	tblProjects
ProjectEndDate	Date/Time
AllowZeroLength	False
Attributes	Fixed size
Caption	Project End Date
CollatingOrder	General
ColumnHidden	False
ColumnOrder	Default
ColumnWidth	Default
OrdinalPosition	8
Required	False
SourceField	ProjectEndDate
SourceTable	tblProjects

The tblTimCardExpenses Table

This tables stores necessary information for billable project expenses, such as the date and amount of the expense.

Table A.35. The tblTimeCardExpenses Table

Field Name	Type	Size (Bytes)
TimeCardExpenseID	Number (Long)	4
TimeCardID	Number (Long)	4
ExpenseDate	Date/Time	8
ProjectID	Number (Long)	4
ExpenseDescription	Text	255
ExpenseAmount	Currency	8
ExpenseCodeID	Number (Long)	4

Table A.36. The Field Properties of the tblTimeCardExpenses Table

Property	Value
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
Display Control	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
Bound Column	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

The tblTimeCardHours Table

This table stores a record of billable hours for a project, including dates and billing rates.

Table A.37. The tblTimeCardHours Table

Field Name	Type	Size (Bytes)
TimeCardDetailID	Number (Long)	4
TimeCardID	Number (Long)	4
DateWorked	Date/Time	8
ProjectID	Number (Long)	4
WorkDescription	Text	255
BillableHours	Number (Double)	8
BillingRate	Currency	8
WorkCodeID	Number (Long)	4

Table A.38. The Field Properties of the tblTimeCardHours Table

Property	Value
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
Column Hidden	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
Bound Column	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
Bound Column	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

The tblTimeCards Table

This table stores time card information for each employee.

Table A.39. The tblTimeCards Table

Field Name	Type	Size (Bytes)
TimeCardID	Number (Long)	4
EmployeeID	Number (Long)	4
DateEntered	Date/Time	8

Table A.40. The Field Properties of the tblTimeCards Table

Property	Value
TimeCardID	Number (Long)
AllowZeroLength	False
Attributes	Fixed size, auto-increment
Caption	Time Card ID
CollatingOrder	General
ColumnHidden	False
ColumnOrder	Default
ColumnWidth	Default
OrdinalPosition	0
Required	False
SourceField	TimeCardID
SourceTable	tblTimeCards
EmployeeID	Number (Long)
AllowZeroLength	False
Attributes	Fixed size
BoundColumn	1
Caption	Employee ID
CollatingOrder	General
ColumnCount	3
ColumnHeads	False
ColumnHidden	False
ColumnOrder	Default
ColumnWidth	Default
ColumnWidths	0;2000;700
DecimalPlaces	255
DisplayControl	Combo Box
LimitToList	True
ListRows	8
ListWidth	2
OrdinalPosition	1
Required	False
Row Source Type	Table/Query
Row Source	SELECT tblEmployees.EmployeeID, [LastName] & “, “ & [FirstName] AS EmployeeName, tblEmployees.BillingRate FROM tblEmployees ORDER BY [LastName] & “, “ & [FirstName];
SourceField	EmployeeID
SourceTable	tblTimeCards
DateEntered	Date/Time
AllowZeroLength	False
Attributes	Fixed size
Caption	Date Entered
CollatingOrder	General
ColumnHidden	False
ColumnOrder	Default
ColumnWidth	Default
Format	Short date
InputMask	99/99/00
OrdinalPosition	2
Required	False
SourceField	DateEntered
SourceTable	tblTimeCards

The tblWorkCodes Table

This table supplies valid work codes for the application.

Table A.41. The tblWorkCodes Table

Field Name	Type	Size (Bytes)
WorkCodeID	Number (Long)	4
WorkCode	Text	30

Table A.42. The Field Properties of the tblWorkCodes Table

Property	Value
WorkCodeID	Number (Long)
AllowZeroLength	False
Attributes	Fixed size, auto-increment
Caption	Work Code ID
CollatingOrder	General
OrdinalPosition	0
Required	False
SourceField	WorkCodeID
SourceTable	tblWorkCodes
WorkCode	Text
AllowZeroLength	False
Attributes	Variable length
Caption	Work Code
CollatingOrder	General
OrdinalPosition	1
Required	False
SourceField	WorkCode
SourceTable	tblWorkCodes

..................Content has been hidden....................

You can't read the all page of ebook, please click here login for view all page.

Table of Contents for A. Table Structures

Create new playlist

Sign In

Sign Up