Previous Page TOC Index Next Page Home


A

Table Structures

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

Field Name

Type

Size (Bytes)

ClientID

Number (Long)

4

CompanyName

Text

50

Address

Text

255

City

Text

30

StateProvince

Text

20

PostalCode

Text

20

Country

Text

20

ContactFirstName

Text

30

ContactLastName

Text

50

ContactTitle

Text

50

OfficePhone

Text

30

Fax

Text

30

Cellular

Text

30

Home

Text

30

EMailAddress

Text

30

ReferredBy

Text

30

AssociatedWith

Text

30

IntroDate

Date/Time

8

DefaultRate

Currency

8

Notes

Memo

(Varies)

Property

Value

ClientID

Number (Long)

Allow Zero Length:

False

Attributes:

Fixed Size, Auto-Increment

Caption:

Client ID

Collating Order:

General

Column Hidden:

False

Column Order:

Default

Column Width:

Default

Ordinal Position:

0

Required:

False

Source Field:

ClientID

Source Table:

tblClients

CompanyName

Text

Allow Zero Length:

False

Attributes:

Variable Length

Caption:

Company Name

Collating Order:

General

Column Hidden:

False

Column Order:

Default

Column Width:

Default

Display Control:

Text Box

Ordinal Position:

1

Required:

True

Source Field:

CompanyName

Source Table:

tblClients

Address

Text

Allow Zero Length:

False

Attributes:

Variable Length

Collating Order:

General

Column Hidden:

False

Column Order:

Default

Column Width:

Default

Display Control:

Text Box

Ordinal Position:

2

Required:

False

Source Field:

Address

Source Table:

tblClients

City

Text

Allow Zero Length:

False

Attributes:

Variable Length

Collating Order:

General

Column Hidden:

False

Column Order:

Default

Column Width:

Default

Display Control:

Text Box

Ordinal Position:

3

Required:

False

Source Field:

City

Source Table:

tblClients

StateProvince

Text

Allow Zero Length:

False

Attributes:

Variable Length

Caption:

State/Province

Collating Order:

General

Column Hidden:

False

Column Order:

Default

Column Width:

Default

Default Value:

"CA"

Display Control:

Text Box

Ordinal Position:

4

Required:

False

Source Field:

StateProvince

Source Table:

tblClients

PostalCode

Text

Allow Zero Length:

False

Attributes:

Variable Length

Caption:

Postal Code

Collating Order:

General

Column Hidden:

False

Column Order:

Default

Column Width:

Default

Display Control:

Text Box

Ordinal Position:

5

Required:

False

Source Field:

PostalCode

Source Table:

tblClients

Country

Text

Allow Zero Length:

False

Attributes:

Variable Length

Collating Order:

General

Column Hidden:

False

Column Order:

Default

Column Width:

Default

Display Control:

Text Box

Ordinal Position:

6

Required:

False

Source Field:

Country

Source Table:

tblClients

ContactFirstName

Text

Allow Zero Length:

False

Attributes:

Variable Length

Caption:

Contact First Name

Collating Order:

General

Column Hidden:

False

Column Order:

Default

Column Width:

Default

Display Control:

Text Box

Ordinal Position:

7

Required:

False

Source Field:

ContactFirstName

Source Table:

tblClients

ContactLastName

Text

Allow Zero Length:

False

Attributes:

Variable Length

Caption:

Contact Last Name

Collating Order:

General

Column Hidden:

False

Column Order:

Default

Column Width:

Default

Display Control:

Text Box

Ordinal Position:

8

Required:

False

Source Field:

ContactLastName

Source Table:

tblClients

ContactTitle

Text

Allow Zero Length:

False

Attributes:

Variable Length

Caption:

Contact Title

Collating Order:

General

Column Hidden:

False

Column Order:

Default

Column Width:

Default

Display Control:

Text Box

Ordinal Position:

9

Required:

False

Source Field:

ContactTitle

Source Table:

tblClients

OfficePhone

Text

Allow Zero Length:

False

Attributes:

Variable Length

Caption:

Office Phone

Collating Order:

General

Column Hidden:

False

Column Order:

Default

Column Width:

Default

Display Control:

Text Box

Input Mask:

!\(999\)000\-0000

Ordinal Position:

10

Required:

False

Source Field:

OfficePhone

Source Table:

tblClients

Fax

Text

Allow Zero Length:

False

Attributes:

Variable Length

Collating Order:

General

Column Hidden:

False

Column Order:

Default

Column Width:

Default

Display Control:

Text Box

Input Mask:

!\(999\)000\-0000

Ordinal Position:

11

Required:

False

Source Field:

Fax

Source Table:

tblClients

Cellular

Text

Allow Zero Length:

False

Attributes:

Variable Length

Collating Order:

General

Column Hidden:

False

Column Order:

Default

Column Width:

Default

Display Control:

Text Box

Input Mask:

!\(999\)000\-0000

Ordinal Position:

12

Required:

False

Source Field:

Cellular

Source Table:

tblClients

Home

Text

Allow Zero Length:

False

Attributes:

Variable Length

Collating Order:

General

Column Hidden:

False

Column Order:

Default

Column Width:

Default

Display Control:

Text Box

Input Mask:

!\(999\)000\-0000

Ordinal Position:

13

Required:

False

Source Field:

Home

Source Table:

tblClients

EMailAddress

Text

Allow Zero Length:

False

Attributes:

Variable Length

Caption:

E-Mail Address

Collating Order:

General

Column Hidden:

False

Column Order:

Default

Column Width:

Default

Display Control:

Text Box

Ordinal Position:

14

Required:

False

Source Field:

EMailAddress

Source Table:

tblClients

ReferredBy

Text

Allow Zero Length:

False

Attributes:

Variable Length

Caption:

Referred By

Collating Order:

General

Column Hidden:

False

Column Order:

Default

Column Width:

Default

Display Control:

Text Box

Ordinal Position:

15

Required:

False

Source Field:

ReferredBy

Source Table:

tblClients

AssociatedWith

Text

Allow Zero Length:

False

Attributes:

Variable Length

Caption:

Associated With

Collating Order:

General

Column Hidden:

False

Column Order:

Default

Column Width:

Default

Display Control:

Text Box

Ordinal Position:

16

Required:

False

Source Field:

AssociatedWith

Source Table:

tblClients

IntroDate

Date/Time

Allow Zero Length:

False

Attributes:

Fixed Size

Caption:

Intro Date

Collating Order:

General

Column Hidden:

False

Column Order:

Default

Column Width:

Default

Default Value:

=Date()

Ordinal Position:

17

Required:

True

Source Field:

IntroDate

Source Table:

tblClients

Validation Rule:

<=Date()

Validation Text:

Date Entered Must Be On Or Before Today

DefaultRate

Currency

Allow Zero Length:

False

Attributes:

Fixed Size

Caption:

Default Rate

Collating Order:

General

Column Hidden:

False

Column Order:

Default

Column Width:

Default

Decimal Places:

255

Default Value:

125

Format:

Currency

Ordinal Position:

18

Required:

False

Source Field:

DefaultRate

Source Table:

tblClients

Validation Rule:

Between 75 And 150

Validation Text:

Rate Must Be Between 75 and 150

Notes

Memo

Allow Zero Length:

False

Attributes:

Variable Length

Collating Order:

General

Column Hidden:

False

Column Order:

Default

Column Width:

Default

Ordinal Position:

19

Required:

False

Source Field:

Notes

Source Table:

tblClients

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)

Property

Value

SetupID

Number (Long)

Allow Zero Length:

False

Attributes:

Fixed Size, Auto-Increment

Caption:

SetupID

Collating Order:

General

Column Hidden:

False

Column Order:

Default

Column Width:

Default

Ordinal Position:

0

Required:

False

Source Field:

SetupID

Source Table:

tblCompanyInfo

CompanyName

Text

Allow Zero Length:

False

Attributes:

Variable Length

Caption:

Company Name

Collating Order:

General

Column Hidden:

False

Column Order:

Default

Column Width:

Default

Display Control:

Text Box

Ordinal Position:

1

Required:

False

Source Field:

CompanyName

Source Table:

tblCompanyInfo

Address

Text

Allow Zero Length:

False

Attributes:

Variable Length

Collating Order:

General

Column Hidden:

False

Column Order:

Default

Column Width:

Default

Display Control:

Text Box

Ordinal Position:

2

Required:

False

Source Field:

Address

Source Table:

tblCompanyInfo

City

Text

Allow Zero Length:

False

Attributes:

Variable Length

Collating Order:

General

Column Hidden:

False

Column Order:

Default

Column Width:

Default

Display Control:

Text Box

Ordinal Position:

3

Required:

False

Source Field:

City

Source Table:

tblCompanyInfo

StateProvince

Text

Allow Zero Length:

False

Attributes:

Variable Length

Caption:

State/Province

Collating Order:

General

Column Hidden:

False

Column Order:

Default

Column Width:

Default

Display Control:

Text Box

Ordinal Position:

4

Required:

False

Source Field:

StateProvince

Source Table:

tblCompanyInfo

PostalCode

Text

Allow Zero Length:

False

Attributes:

Variable Length

Caption:

Postal Code

Collating Order:

General

Column Hidden:

False

Column Order:

Default

Column Width:

Default

Display Control:

Text Box

Input Mask:

00000\-9999

Ordinal Position:

5

Required:

False

Source Field:

PostalCode

Source Table:

tblCompanyInfo

Country

Text

Allow Zero Length:

False

Attributes:

Variable Length

Collating Order:

General

Column Hidden:

False

Column Order:

Default

Column Width:

Default

Display Control:

Text Box

Ordinal Position:

6

Required:

False

Source Field:

Country

Source Table:

tblCompanyInfo

PhoneNumber

Text

Allow Zero Length:

False

Attributes:

Variable Length

Caption:

Phone Number

Collating Order:

General

Column Hidden:

False

Column Order:

Default

Column Width:

Default

Display Control:

Text Box

Input Mask:

!\(999") "000\-0000

Ordinal Position:

7

Required:

False

Source Field:

PhoneNumber

Source Table:

tblCompanyInfo

FaxNumber

Text

Allow Zero Length:

False

Attributes:

Variable Length

Caption:

Fax Number

Collating Order:

General

Column Hidden:

False

Column Order:

Default

Column Width:

Default

Display Control:

Text Box

Input Mask:

!\(999") "000\-0000

Ordinal Position:

8

Required:

False

Source Field:

FaxNumber

Source Table:

tblCompanyInfo

DefaultPaymentTerms

Text

Allow Zero Length:

False

Attributes:

Variable Length

Caption:

Default Payment Terms

Collating Order:

General

Column Hidden:

False

Column Order:

Default

Column Width:

Default

Display Control:

Text Box

Ordinal Position:

9

Required:

False

Source Field:

DefaultPaymentTerms

Source Table:

tblCompanyInfo

DefaultInvoiceDescription

Memo

Allow Zero Length:

False

Attributes:

Variable Length

Caption:

Default Invoice Description

Collating Order:

General

Column Hidden:

False

Column Order:

Default

Column Width:

Default

Ordinal Position:

10

Required:

False

Source Field:

DefaultInvoiceDescription

Source Table:

tblCompanyInfo

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

Property

Value

EmployeeID

Number (Long)

Allow Zero Length:

False

Attributes:

Fixed Size, Auto-Increment

Caption:

Employee ID

Collating Order:

General

Ordinal Position:

0

Required:

False

Source Field:

EmployeeID

Source Table:

tblEmployees

FirstName

Text

Allow Zero Length:

False

Attributes:

Variable Length

Caption:

First Name

Collating Order:

General

Ordinal Position:

1

Required:

False

Source Field:

FirstName

Source Table:

tblEmployees

LastName

Text

Allow Zero Length:

False

Attributes:

Variable Length

Caption:

Last Name

Collating Order:

General

Ordinal Position:

2

Required:

False

Source Field:

LastName

Source Table:

tblEmployees

Title

Text

Allow Zero Length:

False

Attributes:

Variable Length

Collating Order:

General

Ordinal Position:

3

Required:

False

Source Field:

Title

Source Table:

tblEmployees

EmailName

Text

Allow Zero Length:

False

Attributes:

Variable Length

Caption:

Email Name

Collating Order:

General

Ordinal Position:

4

Required:

False

Source Field:

EmailName

Source Table:

tblEmployees

Extension

Text

Allow Zero Length:

False

Attributes:

Variable Length

Collating Order:

General

Ordinal Position:

5

Required:

False

Source Field:

Extension

Source Table:

tblEmployees

Address

Text

Allow Zero Length:

False

Attributes:

Variable Length

Collating Order:

General

Ordinal Position:

6

Required:

False

Source Field:

Address

Source Table:

tblEmployees

City

Text

Allow Zero Length:

False

Attributes:

Variable Length

Collating Order:

General

Ordinal Position:

7

Required:

False

Source Field:

City

Source Table:

tblEmployees

StateOrProvince

Text

Allow Zero Length:

False

Attributes:

Variable Length

Caption:

State/Province

Collating Order:

General

Ordinal Position:

8

Required:

False

Source Field:

StateOrProvince

Source Table:

tblEmployees

PostalCode

Text

Allow Zero Length:

False

Attributes:

Variable Length

Caption:

Postal Code

Collating Order:

General

Input Mask:

00000-9999

Ordinal Position:

9

Required:

False

Source Field:

PostalCode

Source Table:

tblEmployees

Country

Text

Allow Zero Length:

False

Attributes:

Variable Length

Collating Order:

General

Ordinal Position:

10

Required:

False

Source Field:

Country

Source Table:

tblEmployees

HomePhone

Text

Allow Zero Length:

False

Attributes:

Variable Length

Caption:

Home Phone

Collating Order:

General

Input Mask:

!(999) 000-0000

Ordinal Position:

11

Required:

False

Source Field:

HomePhone

Source Table:

tblEmployees

WorkPhone

Text

Allow Zero Length:

False

Attributes:

Variable Length

Caption:

Work Phone

Collating Order:

General

Input Mask:

!(999) 000-0000

Ordinal Position:

12

Required:

False

Source Field:

WorkPhone

Source Table:

tblEmployees

BillingRate

Currency

Allow Zero Length:

False

Attributes:

Fixed Size

Caption:

Billing Rate

Collating Order:

General

Decimal Places:

2

Format:

Currency

Ordinal Position:

13

Required:

False

Source Field:

BillingRate

Source Table:

tblEmployees

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

Module

Text

50

Routine

Text

50

Property

Value

ErrorSeq

Number (Long)

Allow Zero Length:

False

Attributes:

Fixed Size, Auto-Increment

Collating Order:

General

Column Hidden:

False

Column Order:

Default

Column Width:

Default

Description:

Unique Identifier for the Error

Ordinal Position:

0

Required:

False

Source Field:

ErrorSeq

Source Table:

tblErrorLog

ErrorDate

Date/Time

Allow Zero Length:

False

Attributes:

Fixed Size

Collating Order:

General

Column Hidden:

False

Column Order:

Default

Column Width:

Default

Description:

Date that the Error Occurred

Format:

Medium Date

Ordinal Position:

1

Required:

False

Source Field:

ErrorDate

Source Table:

tblErrorLog

ErrorTime

Date/Time

Allow Zero Length:

False

Attributes:

Fixed Size

Collating Order:

General

Column Hidden:

False

Column Order:

Default

Column Width:

Default

Description:

Time that the Error Occurred

Format:

Long Time

Ordinal Position:

2

Required:

False

Source Field:

ErrorTime

Source Table:

tblErrorLog

UserName

Text

Allow Zero Length:

False

Attributes:

Variable Length

Collating Order:

General

Column Hidden:

False

Column Order:

Default

Column Width:

Default

Description:

Name of the User

Display Control:

Text Box

Ordinal Position:

3

Required:

False

Source Field:

UserName

Source Table:

tblErrorLog

ErrorNum

Number (Integer)

Allow Zero Length:

False

Attributes:

Fixed Size

Collating Order:

General

Column Hidden:

False

Column Order:

Default

Column Width:

Default

Decimal Places:

255

Default Value:

0

Description:

VBA Error Code

Display Control:

Text Box

Ordinal Position:

4

Required:

False

Source Field:

ErrorNum

Source Table:

tblErrorLog

ErrorString

Text

Allow Zero Length:

False

Attributes:

Variable Length

Collating Order:

General

Column Hidden:

False

Column Order:

Default

Column Width:

Default

Description:

VBA Error Description

Display Control:

Text Box

Ordinal Position:

5

Required:

False

Source Field:

ErrorString

Source Table:

tblErrorLog

Module

Text

Allow Zero Length:

False

Attributes:

Variable Length

Collating Order:

General

Column Hidden:

False

Column Order:

Default

Column Width:

Default

Description:

Module in Which the Error Occurred

Display Control:

Text Box

Ordinal Position:

6

Required:

False

Source Field:

Module

Source Table:

tblErrorLog

Routine

Text

Allow Zero Length:

False

Attributes:

Variable Length

Collating Order:

General

Column Hidden:

False

Column Order:

Default

Column Width:

Default

Description:

Routine in Which the Error Occurred

Display Control:

Text Box

Ordinal Position:

7

Required:

False

Source Field:

Routine

Source Table:

tblErrorLog

Field Name

Type

Size (Bytes)

ErrorNum

Number (Long)

4

Response

Number (Long)

4

Property

Value

ErrorNum

Number (Long)

Allow Zero Length:

False

Attributes:

Fixed Size

Collating Order:

General

Column Hidden:

False

Column Order:

Default

Column Width:

Default

Decimal Places:

255

Default Value:

0

Description:

Number of the Error

Display Control:

Text Box

Ordinal Position:

0

Required:

False

Source Field:

ErrorNum

Source Table:

tblErrors

Response

Number (Long)

Allow Zero Length:

False

Attributes:

Fixed Size

Collating Order:

General

Column Hidden:

False

Column Order:

Default

Column Width:

Default

Decimal Places:

255

Default Value:

0

Description:

Action to Take

Display Control:

Text Box

Ordinal Position:

1

Required:

False

Source Field:

Response

Source Table:

tblErrors

Field Name

Type

Size (Bytes)

ExpenseCodeID

Number (Long)

4

ExpenseCode

Text

30

Property

Value

ExpenseCodeID

Number (Long)

Allow Zero Length:

False

Attributes:

Fixed Size, Auto-Increment

Caption:

Expense Code ID

Collating Order:

General

Ordinal Position:

0

Required:

False

Source Field:

ExpenseCodeID

Source Table:

tblExpenseCodes

ExpenseCode

Text

Allow Zero Length:

False

Attributes:

Variable Length

Caption:

Expense Code

Collating Order:

General

Ordinal Position:

1

Required:

False

Source Field:

ExpenseCode

Source Table:

tblExpenseCodes

Field Name

Type

Size (Bytes)

PaymentMethodID

Number (Long)

4

PaymentMethod

Text

50

CreditCard

Yes/No

1

Property

Value

PaymentMethodID

Number (Long)

Allow Zero Length:

False

Attributes:

Fixed Size, Auto-Increment

Caption:

Payment Method ID

Collating Order:

General

Ordinal Position:

0

Required:

False

Source Field:

PaymentMethodID

Source Table:

tblPaymentMethods

PaymentMethod

Text

Allow Zero Length:

False

Attributes:

Variable Length

Caption:

Payment Method

Collating Order:

General

Ordinal Position:

1

Required:

False

Source Field:

PaymentMethod

Source Table:

tblPaymentMethods

CreditCard

Yes/No

Allow Zero Length:

False

Attributes:

Fixed Size

Caption:

Credit Card?

Collating Order:

General

Format:

Yes/No

Ordinal Position:

2

Required:

False

Source Field:

CreditCard

Source Table:

tblPaymentMethods

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

Property

Value

PaymentID

Number (Long)

Allow Zero Length:

False

Attributes:

Fixed Size, Auto-Increment

Caption:

Payment ID

Collating Order:

General

Column Hidden:

False

Column Order:

Default

Column Width:

Default

Ordinal Position:

0

Required:

False

Source Field:

PaymentID

Source Table:

tblPayments

ProjectID

Number (Long)

Allow Zero Length:

False

Attributes:

Fixed Size

Caption:

Project ID

Collating Order:

General

Column Hidden:

False

Column Order:

Default

Column Width:

Default

Decimal Places:

255

Display Control:

Text Box

Ordinal Position:

1

Required:

False

Source Field:

ProjectID

Source Table:

tblPayments

PaymentAmount

Currency

Allow Zero Length:

False

Attributes:

Fixed Size

Caption:

Payment Amount

Collating Order:

General

Column Hidden:

False

Column Order:

Default

Column Width:

Default

Decimal Places:

2

Format:

Currency

Ordinal Position:

2

Required:

False

Source Field:

PaymentAmount

Source Table:

tblPayments

PaymentDate

Date/Time

Allow Zero Length:

False

Attributes:

Fixed Size

Caption:

Payment Date

Collating Order:

General

Column Hidden:

False

Column Order:

Default

Column Width:

Default

Format:

Short Date

Input Mask:

99/99/00

Ordinal Position:

3

Required:

False

Source Field:

PaymentDate

Source Table:

tblPayments

CreditCardNumber

Text

Allow Zero Length:

False

Attributes:

Variable Length

Caption:

Credit Card #

Collating Order:

General

Column Hidden:

False

Column Order:

Default

Column Width:

Default

Display Control:

Text Box

Ordinal Position:

4

Required:

False

Source Field:

CreditCardNumber

Source Table:

tblPayments

CardholdersName

Text

Allow Zero Length:

False

Attributes:

Variable Length

Caption:

Cardholder Name

Collating Order:

General

Column Hidden:

False

Column Order:

Default

Column Width:

Default

Display Control:

Text Box

Ordinal Position:

5

Required:

False

Source Field:

CardholdersName

Source Table:

tblPayments

CreditCardExpDate

Date/Time

Allow Zero Length:

False

Attributes:

Fixed Size

Caption:

Card Exp. Date

Collating Order:

General

Column Hidden:

False

Column Order:

Default

Column Width:

Default

Format:

Short Date

Input Mask:

99/99/00

Ordinal Position:

6

Required:

False

Source Field:

CreditCardExpDate

Source Table:

tblPayments

PaymentMethodID

Number (Long)

Allow Zero Length:

False

Attributes:

Fixed Size

Bound Column:

1

Caption:

Payment Method ID

Collating Order:

General

Column Count:

3

Column Heads:

False

Column Hidden:

False

Column Order:

Default

Column Width:

Default

Column Widths:

0;1440;0

Decimal Places:

255

Display Control:

Combo Box

Limit To List:

True

List Rows:

8

List Width:

1

Ordinal Position:

7

Required:

False

Row Source Type:

Table/Query

Row Source:

SELECT DISTINCTROW tblPaymentMethods.* FROM tblPaymentMethods ORDER BY tblPaymentMethods.PaymentMethod;

Source Field:

PaymentMethodID

Source Table:

tblPayments

Field Name

Type

Size (Bytes)

ProjectID

Number (Long)

4

ProjectName

Text

50

ProjectDescription

Memo

-

ClientID

Number (Long)

4

PurchaseOrderNumber

Text

50

ProjectTotalEstimate

Currency

8

EmployeeID

Number (Long)

4

ProjectBeginDate

Date/Time

8

ProjectEndDate

Date/Time

8

Property

Value

ProjectID

Number (Long)

Allow Zero Length:

False

Attributes:

Fixed Size, Auto-Increment

Caption:

Project ID

Collating Order:

General

Column Hidden:

False

Column Order:

Default

Column Width:

Default

Ordinal Position:

0

Required:

False

Source Field:

ProjectID

Source Table:

tblProjects

ProjectName

Text

Allow Zero Length:

False

Attributes:

Variable Length

Caption:

Project Name

Collating Order:

General

Column Hidden:

False

Column Order:

Default

Column Width:

Default

Display Control:

Text Box

Ordinal Position:

1

Required:

True

Source Field:

ProjectName

Source Table:

tblProjects

ProjectDescription

Memo

Allow Zero Length:

False

Attributes:

Variable Length

Caption:

Project Description

Collating Order:

General

Column Hidden:

False

Column Order:

Default

Column Width:

Default

Ordinal Position:

2

Required:

False

Source Field:

ProjectDescription

Source Table:

tblProjects

ClientID

Number (Long)

Allow Zero Length:

False

Attributes:

Fixed Size

Bound Column:

1

Caption:

Client ID

Collating Order:

General

Column Count:

2

Column Heads:

False

Column Hidden:

False

Column Order:

Default

Column Width:

Default

Column Widths:

;14400

Decimal Places:

255

Default Value:

0

Display Control:

Combo Box

Limit To List:

True

List Rows:

8

List Width:

1

Ordinal Position:

3

Required:

True

Row Source Type:

Table/Query

Row Source:

SELECT DISTINCTROW [tblClients].[ClientID], [tblClients].[CompanyName] FROM [tblClients];

Source Field:

ClientID

Source Table:

tblProjects

PurchaseOrderNumber

Text

Allow Zero Length:

False

Attributes:

Variable Length

Caption:

Purchase Order Number

Collating Order:

General

Column Hidden:

False

Column Order:

Default

Column Width:

Default

Display Control:

Text Box

Ordinal Position:

4

Required:

False

Source Field:

PurchaseOrderNumber

Source Table:

tblProjects

ProjectTotalEstimate

Currency

Allow Zero Length:

False

Attributes:

Fixed Size

Caption:

ProjectTotalEstime

Collating Order:

General

Column Hidden:

False

Column Order:

Default

Column Width:

Default

Decimal Places:

255

Default Value:

0

Format:

Currency

Ordinal Position:

5

Required:

False

Source Field:

ProjectTotalEstimate

Source Table:

tblProjects

EmployeeID

Number (Long)

Allow Zero Length:

False

Attributes:

Fixed Size

Caption:

Employee ID

Collating Order:

General

Column Hidden:

False

Column Order:

Default

Column Width:

Default

Decimal Places:

255

Default Value:

0

Display Control:

Text Box

Ordinal Position:

6

Required:

False

Source Field:

EmployeeID

Source Table:

tblProjects

ProjectBeginDate

Date/Time

Allow Zero Length:

False

Attributes:

Fixed Size

Caption:

Project Begin Date

Collating Order:

General

Column Hidden:

False

Column Order:

Default

Column Width:

Default

Ordinal Position:

7

Required:

False

Source Field:

ProjectBeginDate

Source Table:

tblProjects

ProjectEndDate

Date/Time

Allow Zero Length:

False

Attributes:

Fixed Size

Caption:

Project End Date

Collating Order:

General

Column Hidden:

False

Column Order:

Default

Column Width:

Default

Ordinal Position:

8

Required:

False

Source Field:

ProjectEndDate

Source Table:

tblProjects

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

Property

Value

TimeCardExpenseID

Number (Long)

Allow Zero Length:

False

Attributes:

Fixed Size, Auto-Increment

Caption:

Time Card Expense ID

Collating Order:

General

Column Hidden:

False

Column Order:

Default

Column Width:

Default

Ordinal Position:

0

Required:

False

Source Field:

TimeCardExpenseID

Source Table:

tblTimeCardExpenses

TimeCardID

Number (Long)

Allow Zero Length:

False

Attributes:

Fixed Size

Caption:

Time Card ID

Collating Order:

General

Column Hidden:

False

Column Order:

Default

Column Width:

Default

Decimal Places:

255

Display Control:

Text Box

Ordinal Position:

1

Required:

False

Source Field:

TimeCardID

Source Table:

tblTimeCardExpenses

ExpenseDate

Date/Time

Allow Zero Length:

False

Attributes:

Fixed Size

Caption:

Expense Date

Collating Order:

General

Column Hidden:

False

Column Order:

Default

Column Width:

Default

Format:

Short Date

Input Mask:

99/99/00

Ordinal Position:

2

Required:

False

Source Field:

ExpenseDate

Source Table:

tblTimeCardExpenses

ProjectID

Number (Long)

Allow Zero Length:

False

Attributes:

Fixed Size

Bound Column:

1

Caption:

Project ID

Collating Order:

General

Column Count:

3

Column Heads:

False

Column Hidden:

False

Column Order:

Default

Column Width:

Default

Column Widths:

0;1020;3156

Decimal Places:

255

Display Control:

Combo Box

Limit To List:

True

List Rows:

8

List Width:

3

Ordinal Position:

3

Required:

False

Row Source Type:

Table/Query

Row Source:

SELECT DISTINCTROW tblProjects.* FROM tblProjects ORDER BY tblProjects.ProjectName;

Source Field:

ProjectID

Source Table:

tblTimeCardExpenses

ExpenseDescription

Text

Allow Zero Length:

False

Attributes:

Variable Length

Caption:

Expense Description

Collating Order:

General

Column Hidden:

False

Column Order:

Default

Column Width:

Default

Display Control:

Text Box

Ordinal Position:

4

Required:

False

Source Field:

ExpenseDescription

Source Table:

tblTimeCardExpenses

ExpenseAmount

Currency

Allow Zero Length:

False

Attributes:

Fixed Size

Caption:

Expense Amount

Collating Order:

General

Column Hidden:

False

Column Order:

Default

Column Width:

Default

Decimal Places:

2

Format:

Currency

Ordinal Position:

5

Required:

False

Source Field:

ExpenseAmount

Source Table:

tblTimeCardExpenses

ExpenseCodeID

Number (Long)

Allow Zero Length:

False

Attributes:

Fixed Size

Bound Column:

1

Caption:

Expense Code ID

Collating Order:

General

Column Count:

2

Column Heads:

False

Column Hidden:

False

Column Order:

Default

Column Width:

Default

Column Widths:

0;2880

Decimal Places:

255

Display Control:

Combo Box

Limit To List:

True

List Rows:

8

List Width:

2

Ordinal Position:

6

Required:

False

Row Source Type:

Table/Query

Row Source:

SELECT DISTINCTROW tblExpenseCodes.* FROM tblExpenseCodes ORDER BY tblExpenseCodes.Exp enseCode;

Source Field:

ExpenseCodeID

Source Table:

tblTimeCardExpenses

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

Property

Value

TimeCardDetailID

Number (Long)

Allow Zero Length:

False

Attributes:

Fixed Size, Auto-Increment

Caption:

Time Card Detail ID

Collating Order:

General

Column Hidden:

False

Column Order:

Default

Column Width:

Default

Ordinal Position:

0

Required:

False

Source Field:

TimeCardDetailID

Source Table:

tblTimeCardHours

TimeCardID

Number (Long)

Allow Zero Length:

False

Attributes:

Fixed Size

Caption:

Time Card ID

Collating Order:

General

Column Hidden:

False

Column Order:

Default

Column Width:

Default

Decimal Places:

255

Display Control:

Text Box

Ordinal Position:

1

Required:

False

Source Field:

TimeCardID

Source Table:

tblTimeCardHours

DateWorked

Date/Time

Allow Zero Length:

False

Attributes:

Fixed Size

Caption:

Date Worked

Collating Order:

General

Column Hidden:

False

Column Order:

Default

Column Width:

Default

Format:

Short Date

Input Mask:

99/99/00

Ordinal Position:

2

Required:

False

Source Field:

DateWorked

Source Table:

tblTimeCardHours

ProjectID

Number (Long)

Allow Zero Length:

False

Attributes:

Fixed Size

Bound Column:

1

Caption:

Project ID

Collating Order:

General

Column Count:

3

Column Heads:

False

Column Hidden:

False

Column Order:

Default

Column Width:

Default

Column Widths:

0;1020;3156

Decimal Places:

255

Display Control:

Combo Box

Limit To List:

True

List Rows:

8

List Width:

3

Ordinal Position:

3

Required:

False

Row Source Type:

Table/Query

Row Source:

SELECT DISTINCTROW tblProjects.* FROM tblProjects ORDER BY tblProjects.ProjectName;

Source Field:

ProjectID

Source Table:

tblTimeCardHours

WorkDescription

Text

Allow Zero Length:

False

Attributes:

Variable Length

Caption:

Work Description

Collating Order:

General

Column Hidden:

False

Column Order:

Default

Column Width:

Default

Display Control:

Text Box

Ordinal Position:

4

Required:

False

Source Field:

WorkDescription

Source Table:

tblTimeCardHours

BillableHours

Number (Double)

Allow Zero Length:

False

Attributes:

Fixed Size

Caption:

Billable Hours

Collating Order:

General

Column Hidden:

False

Column Order:

Default

Column Width:

Default

Decimal Places:

255

Display Control:

Text Box

Ordinal Position:

5

Required:

False

Source Field:

BillableHours

Source Table:

tblTimeCardHours

BillingRate

Currency

Allow Zero Length:

False

Attributes:

Fixed Size

Caption:

Billing Rate

Collating Order:

General

Column Hidden:

False

Column Order:

Default

Column Width:

Default

Decimal Places:

2

Format:

Currency

Ordinal Position:

6

Required:

False

Source Field:

BillingRate

Source Table:

tblTimeCardHours

WorkCodeID

Number (Long)

Allow Zero Length:

False

Attributes:

Fixed Size

Bound Column:

1

Caption:

Work Code ID

Collating Order:

General

Column Count:

2

Column Heads:

False

Column Hidden:

False

Column Order:

Default

Column Width:

Default

Column Widths:

0;2880

Decimal Places:

255

Display Control:

Combo Box

Limit To List:

True

List Rows:

8

List Width:

2

Ordinal Position:

7

Required:

False

Row Source Type:

Table/Query

Row Source:

SELECT DISTINCTROW tblWorkCodes.* FROM tblWorkCodes ORDER BY tblWorkCodes.WorkCode;

Source Field:

WorkCodeID

Source Table:

tblTimeCardHours

Field Name

Type

Size (Bytes)

TimeCardID

Number (Long)

4

EmployeeID

Number (Long)

4

DateEntered

Date/Time

8

Property

Value

TimeCardID

Number (Long)

Allow Zero Length:

False

Attributes:

Fixed Size, Auto-Increment

Caption:

Time Card ID

Collating Order:

General

Column Hidden:

False

Column Order:

Default

Column Width:

Default

Ordinal Position:

0

Required:

False

Source Field:

TimeCardID

Source Table:

tblTimeCards

EmployeeID

Number (Long)

Allow Zero Length:

False

Attributes:

Fixed Size

Bound Column:

1

Caption:

Employee ID

Collating Order:

General

Column Count:

3

Column Heads:

False

Column Hidden:

False

Column Order:

Default

Column Width:

Default

Column Widths:

0;2000;700

Decimal Places:

255

Display Control:

Combo Box

Limit To List:

True

List Rows:

8

List Width:

2

Ordinal Position:

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];

Source Field:

EmployeeID

Source Table:

tblTimeCards

DateEntered

Date/Time

Allow Zero Length:

False

Attributes:

Fixed Size

Caption:

Date Entered

Collating Order:

General

Column Hidden:

False

Column Order:

Default

Column Width:

Default

Format:

Short Date

Input Mask:

99/99/00

Ordinal Position:

2

Required:

False

Source Field:

DateEntered

Source Table:

tblTimeCards

Field Name

Type

Size (Bytes)

WorkCodeID

Number (Long)

4

WorkCode

Text

30

Property

Value

WorkCodeID

Number (Long)

Allow Zero Length:

False

Attributes:

Fixed Size, Auto-Increment

Caption:

Work Code ID

Collating Order:

General

Ordinal Position:

0

Required:

False

Source Field:

WorkCodeID

Source Table:

tblWorkCodes

WorkCode

Text

Allow Zero Length:

False

Attributes:

Variable Length

Caption:

Work Code

Collating Order:

General

Ordinal Position:

1

Required:

False

Source Field:

WorkCode

Source Table:

tblWorkCodes

Previous Page TOC Index Next Page Home