Configuring the Custom Vendor Properties Window

To configure the Custom Vendor Properties Window:

1 Open the CUSTSYS.MDB.

2 Open the CUST_EVNT table.

3 Type the required entry in the following fields:

In This Field	Type This
OWNER_KEY	The Owner_Key of the Customer being configured.
EVNT	The event name of the screen being configured. These are documented below.
EVNT_SEQ_NUM	An unused unique integer which must be present to satisfy the keys of the CUST_EVNT table.
EVNT_CLASS	The name of the EVNT_CLASS or, in this case PROPERTY being set
IN_USE_FLAG	A Flag which must be True (Yes) for this property to be set. If false, the record is ignored.
EVNT_TYPE	Possible values are: Text: A string value which is literally set Eval: An expression which is evaluated as the property is set Boolean: A Flag, which can be True or False or Yes or No Number: A number
EVNT_MEMO	The actual value of the property.

Notes

OWNER_KEY = <owner_key>

EVNT = ‘VENDOR Custom Properties Setup’

If no properties are defined, then the Custom Vendor Properties screen will assume a default configuration, using labels such as %T001, etc. If any property is defined, then only % fields

which have defined settings will be used.

All %T001 properties exist for %T001, %T002, %T003, through %T010. In reading the text below, any %T0nn label may be freely substituted for %T001, as may %N1 and %D1.

Properties (EVNT_CLASS)

Caption: Controls the caption that appears on the title bar of the form.

EVNT_TYPE: Text

EVNT_MEMO: <desired screen caption>

Default Value: ’ Custom Vendor Properties’

Field_Width: Controls the width of the Text Value portion of the screen. The value is expressed in inches.

EVNT_TYPE: Number

EVNT_MEMO: <desired button caption>

Default: 1

%T001_Caption: Text that appears as the Caption for field VENDOR![%T001].

EVNT_TYPE: Text

EVNT_MEMO: <desired field caption>

Default: ‘Text 1‘

%T001_StatusBarText: Text that appears on the Status Bar for field VENDOR![%T001].

EVNT_TYPE: Text

EVNT_MEMO: <desired field Status Bar Text>

Default: <The value of %T001_Caption>

%T001_Format: Any valid MSAccess defined format in which data is to be displayed, such as ‘Percent’, ‘Standard’, ‘yy/mm/dd’, etc.

EVNT_TYPE: Text

EVNT_MEMO: <The format to use>

Default: Null

%T001_ValidationRule: A valid MSAccess control Validation Rule setting. This can be used to do rudimentary field level validation if %T001_AllowUpdating = True. It is typically used in conjunction with %T001_ValidationText.

EVNT_TYPE: Text

EVNT_MEMO: <A valid MSAccess ValidationRule setting>

Default: Null

%T001_ValidationText: An error message which is displayed if %T001_ValidationRule fails.

EVNT_TYPE: Text

EVNT_MEMO: <The desired error message>

Default: Null