Skip to content

Latest commit

 

History

History
85 lines (61 loc) · 2.99 KB

Project.Application.CheckField.md

File metadata and controls

85 lines (61 loc) · 2.99 KB
title keywords f1_keywords ms.service api_name ms.assetid ms.date ms.localizationpriority
Application.CheckField method (Project)
vbapj.chm7
vbapj.chm7
project-server
Project.Application.CheckField
a3360541-faa7-169e-1b23-5b3937fc6c07
06/08/2017
medium

Application.CheckField method (Project)

True if the selected tasks or resources meet the specified criteria.

Syntax

expression. CheckField (_Field_, _Value_, _Test_, _Op_, _Field2_, _Value2_, _Test2_)

expression A variable that represents an Application object.

Parameters

Name Required/Optional Data type Description
Field Required String The name of the field to search.
Value Required String The value to compare with the value of the field specified with Field.
Test Optional String The type of comparison made between Field and Value. The default value is "equals". Can be one of the following comparison strings.
Op Optional String How the criteria established with Field, Test, and Value relate to the second criteria. The Op argument can be set to "And" or "Or".
Field2 Optional String The name of a second field to search.
Value2 Optional String The value to compare with the value of the field specified with Field2.
Test2 Optional String The type of comparison made between Field2 and Value2. Can be one of the same comparison strings as Test.

Comparison strings

Comparison string Description
"equals" The value of Field equals Value.
"does not equal" The value of Field does not equal Value.
"is greater than" The value of Field is greater than Value.
"is greater than or equal to" The value of Field is greater than or equal to Value.
"is less than" The value of Field is less than Value.
"is less than or equal to" The value of Field is less than or equal to Value.
"is within" The value of Field is within Value.
"is not within" The value of Field is not within Value.
"contains" Field contains Value.
"does not contain" Field does not contain Value.
"contains exactly" Field exactly contains Value.

Return value

Variant

Example

The following example determines whether value of Duration is equal to 1 and displays an appropriate message.

Sub Check_Field() 
 
 Dim T As Task 
 Dim Result As Boolean 
 
 Set T = ActiveProject.Tasks(3) 
 Result = CheckField("Duration", "1", "equals") 
 
 If Result Then 
 Result = MsgBox(T.GetField(pjTaskName) + " task Duration is equal to value specified.", vbOKOnly, "CheckField Method") 
 Else 
 Result = MsgBox(T.GetField(pjTaskName) + " task Duration is not equal to value specified.", vbOKOnly, "CheckField Method") 
 End If 
End Sub

[!includeSupport and feedback]