Cette action est irreversible, confirmez la suppression du commentaire ?
Signaler le commentaire
Veuillez sélectionner un problème
Nudité
Violence
Harcèlement
Fraude
Vente illégale
Discours haineux
Terrorisme
Autre
Jan De Messemaeker
Bonjour Thanh,
1.
For each MyAss in Thistask.assignments if myass.resourcename= "Le Nom de la ressource" then LesUnites=myass.units exit for endif next myass
2.
Cela s'appelle Instr. Voici le texte du Help:
InStr Function
Returns a Variant (Long) specifying the position of the first occurrence of one string within another.
Syntax
InStr([start, ]string1, string2[, compare])
The InStr function syntax has these arguments:
Part Description start Optional. Numeric expression that sets the starting position for each search. If omitted, search begins at the first character position. If start contains Null, an error occurs. The start argument is required if compare is specified. string1 Required. String expression being searched. string2 Required. String expression sought. compare Optional. Specifies the type of string comparison. If compare is Null, an error occurs. If compare is omitted, the Option Compare setting determines the type of comparison. Specify a valid LCID (LocaleID) to use locale-specific rules in the comparison.
Settings
The compare argument settings are:
Constant Value Description vbUseCompareOption -1 Performs a comparison using the setting of the Option Compare statement. vbBinaryCompare 0 Performs a binary comparison. vbTextCompare 1 Performs a textual comparison. vbDatabaseCompare 2 Microsoft Access only. Performs a comparison based on information in your database.
Return Values
If InStr returns string1 is zero-length 0 string1 is Null Null string2 is zero-length start string2 is Null Null string2 is not found 0 string2 is found within string1 Position at which match is found start > string2 0
Remarks
The InStrB function is used with byte data contained in a string. Instead of returning the character position of the first occurrence of one string within another, InStrB returns the byte position.
Bien à vous,
-- Jan De Messemaeker Microsoft Project Most Valuable Professional Project Management Consultancy Prom+ade BVBA 32-495-300 620 "Thanh" schreef in bericht news:041e01c34473$af11c110$ Bonjour,
Concernant vba, je n'arrive pas à trouver les fonctions suivantes :
-Comment peut on connaitre le nombre d'unités d'une ressources affectées à une tâche donnée?
-Quand on désire comparer deux chaînes de caractères quelle est l'instruction qu'il faut écrire pour dire "contient" ?
Merci
Bonjour Thanh,
1.
For each MyAss in Thistask.assignments
if myass.resourcename= "Le Nom de la ressource" then
LesUnites=myass.units
exit for
endif
next myass
2.
Cela s'appelle Instr. Voici le texte du Help:
InStr Function
Returns a Variant (Long) specifying the position of the first occurrence of
one string within another.
Syntax
InStr([start, ]string1, string2[, compare])
The InStr function syntax has these arguments:
Part Description
start Optional. Numeric expression that sets the starting position for each
search. If omitted, search begins at the first character position. If start
contains Null, an error occurs. The start argument is required if compare is
specified.
string1 Required. String expression being searched.
string2 Required. String expression sought.
compare Optional. Specifies the type of string comparison. If compare is
Null, an error occurs. If compare is omitted, the Option Compare setting
determines the type of comparison. Specify a valid LCID (LocaleID) to use
locale-specific rules in the comparison.
Settings
The compare argument settings are:
Constant Value Description
vbUseCompareOption -1 Performs a comparison using the setting of the Option
Compare statement.
vbBinaryCompare 0 Performs a binary comparison.
vbTextCompare 1 Performs a textual comparison.
vbDatabaseCompare 2 Microsoft Access only. Performs a comparison based on
information in your database.
Return Values
If InStr returns
string1 is zero-length 0
string1 is Null Null
string2 is zero-length start
string2 is Null Null
string2 is not found 0
string2 is found within string1 Position at which match is found
start > string2 0
Remarks
The InStrB function is used with byte data contained in a string. Instead of
returning the character position of the first occurrence of one string
within another, InStrB returns the byte position.
Bien à vous,
--
Jan De Messemaeker
Microsoft Project Most Valuable Professional
Project Management Consultancy
Prom+ade BVBA
32-495-300 620
"Thanh" <thanh.pham-doan@edfgdf.fr> schreef in bericht
news:041e01c34473$af11c110$a001280a@phx.gbl...
Bonjour,
Concernant vba, je n'arrive pas à trouver les fonctions
suivantes :
-Comment peut on connaitre le nombre d'unités d'une
ressources affectées à une tâche donnée?
-Quand on désire comparer deux chaînes de caractères
quelle est l'instruction qu'il faut écrire pour
dire "contient" ?
For each MyAss in Thistask.assignments if myass.resourcename= "Le Nom de la ressource" then LesUnites=myass.units exit for endif next myass
2.
Cela s'appelle Instr. Voici le texte du Help:
InStr Function
Returns a Variant (Long) specifying the position of the first occurrence of one string within another.
Syntax
InStr([start, ]string1, string2[, compare])
The InStr function syntax has these arguments:
Part Description start Optional. Numeric expression that sets the starting position for each search. If omitted, search begins at the first character position. If start contains Null, an error occurs. The start argument is required if compare is specified. string1 Required. String expression being searched. string2 Required. String expression sought. compare Optional. Specifies the type of string comparison. If compare is Null, an error occurs. If compare is omitted, the Option Compare setting determines the type of comparison. Specify a valid LCID (LocaleID) to use locale-specific rules in the comparison.
Settings
The compare argument settings are:
Constant Value Description vbUseCompareOption -1 Performs a comparison using the setting of the Option Compare statement. vbBinaryCompare 0 Performs a binary comparison. vbTextCompare 1 Performs a textual comparison. vbDatabaseCompare 2 Microsoft Access only. Performs a comparison based on information in your database.
Return Values
If InStr returns string1 is zero-length 0 string1 is Null Null string2 is zero-length start string2 is Null Null string2 is not found 0 string2 is found within string1 Position at which match is found start > string2 0
Remarks
The InStrB function is used with byte data contained in a string. Instead of returning the character position of the first occurrence of one string within another, InStrB returns the byte position.
Bien à vous,
-- Jan De Messemaeker Microsoft Project Most Valuable Professional Project Management Consultancy Prom+ade BVBA 32-495-300 620 "Thanh" schreef in bericht news:041e01c34473$af11c110$ Bonjour,
Concernant vba, je n'arrive pas à trouver les fonctions suivantes :
-Comment peut on connaitre le nombre d'unités d'une ressources affectées à une tâche donnée?
-Quand on désire comparer deux chaînes de caractères quelle est l'instruction qu'il faut écrire pour dire "contient" ?