1. Create a new screen.

• Click the New button on the Screen Designer toolbar.

• Add the Loan Equipment screen information and click OK.

A blank screen appears.

2. Create the fields for the data to be saved into.

The names for a field can contain letters A to Z (upper or lower case), numerals 1 to 9, but can have no spaces.

• There are four fields to be added.

Field Name Field Type/Size Display Label Description

LoanOutDate Type: Date Date Date equipment

was loaned out

Returned Type: Date Returned Date equipment is

to be returned

Description Type: Text Description Description of

Size: 30 equipment

 

EquipmentValue Type: Decimal Value Value of the

Number Equipment

3. You decide that you want the dates in the LoanOutDate field sorted in descending order.

• On the Field Chooser screen, select Date then click the Sorting tab.

• Click the Allow Information To Be Sorted By This Field checkbox.

Then click the Descending radio button.

• Click OK.

4. The EquipmentValue field is to have two decimal places.

• On the Field Chooser screen, select Value then click the Display tab.

• Select 2 Decimal places from the format drop-down.

• Click OK.

5. Drag the fields from the Field Chooser to the form in the locations you want them

to be.

6. Now is a good time to set the properties for each item; for example, the dates. Do

this using the Field Chooser.

• Select LoanOutDate in the Field Chooser and click the Edit button.

The Field Properties screen displays the current properties of the field.

• Click the Display tab. Select the type of date you require from the Format

drop-down list.

• When you have done this, click on the OK button.

 

• Repeat step 4 for the Returned field.

7. Change the Description field so that users can choose from a Pick List instead of

using the default field box. To do this you must first delete the Description default

field box. You decide to replace the box with a dynamic Pick List (one where the

user can add an item if it is not in the list) instead of a static one (one where the

user can only select items from the list).

• To delete the Description box, select the Description box and press Del.

• From the Control Properties toolbar, select the dynamic Pick List and drag it to the

location where you just deleted the description box.

• Right-click the Pick List field and choose Control Properties from the

shortcut menu. The Control Properties screen appears. 24

• Select the Description field from the Field drop-down list.

This links the Pick List control with the Description field.

• When you have done this, click OK.

8. To avoid wasted space on the form, you can reduce the size of the screen.

• Select and drag the navigation buttons up the screen.

• Now size the screen size.

9. Save the screen and exit Screen Designer to check the results in Personnel

Email: Support@VisualPersonnel.co.uk Internet: www.VisualPersonnel.co.uk

o Very useful & easy to follow o Too technical

o More technical detail needed o Other (Please comment below)