Filter Show Tasks "Using Resource" - not displaying full list

[Gerry]

Hi,

I am trying to use filtering to list tasks by a specific
resource, however, when I try to select the resource
using the pull-down resource list, I am only able to see
137 out of the 167 resources I know are available. Is
there a parameter setting that allows more resources to
be displayed, or is this another MS Project limitation?
As a workaround, is there a way to type in the resource
without the pull-down list?

Much appreciated,
Gerry

 

[Jack D.]

Hi,

I am trying to use filtering to list tasks by a specific
resource, however, when I try to select the resource
using the pull-down resource list, I am only able to see
137 out of the 167 resources I know are available. Is
there a parameter setting that allows more resources to
be displayed, or is this another MS Project limitation?
As a workaround, is there a way to type in the resource
without the pull-down list?

Much appreciated,
Gerry

This should not be happening.
I just entered 150 resources and all are visible in the pull down list.
Is there some pattern to the ones which are not available?
Perhaps you have some which have the same name?
Are you using a resource pool?
Try adding another resource and see if they show up in the list.

--
Please try to keep replies in this group. I do check e-mail, but only
infrequently. For Macros and other things check http://masamiki.com/project

-Jack Dahlgren, Project MVP


+++++++++++++++++++

 

[Gerry]

Hi Jack,

I have populated this resource list from our network MS
Outlook Global Email list. I have played with deleting
resources above this treshold and that works, ie. more
names appear as I delete from above. Any other
suggestions are appreciated.

Thanks,
Gerry

 

[Jack D.]

Hi Jack,

I have populated this resource list from our network MS
Outlook Global Email list. I have played with deleting
resources above this treshold and that works, ie. more
names appear as I delete from above. Any other
suggestions are appreciated.

Thanks,
Gerry

Sounds like you might have a bad name in there somewhere that is causing the
problem.
Maybe a blank line? A name with some special characters?

--
Please try to keep replies in this group. I do check e-mail, but only
infrequently. For Macros and other things check http://masamiki.com/project

-Jack Dahlgren, Project MVP


+++++++++++++++++++

 

[Tomm \(portrett.no\)]

You can always create a macro to set a Flag on each task using a specific
resource. Then filter on that flag.


Sub ResourceFilter()
Dim sRes As String
Dim oTask As Task
Dim oRes As Resource
Dim oAss As Assignment

'\ Get user name
sRes = InputBox("Type a resource name")

'\ Remove Flag1
For Each oTask In ActiveProject.Tasks
If Not (oTask Is Nothing) Then
If oTask.Flag1 = True Then
oTask.Flag1 = False
End If
End If
Next

'\ Set Flag 1
For Each oRes In ActiveProject.Resources
If Not (oRes Is Nothing) Then
If oRes.Name = sRes Then
For Each oAss In oRes.Assignments
ActiveProject.Tasks(oAss.TaskID).Flag1 = True
Next
End If
End If
Next

End Sub

 

[Jack D.]

You can always create a macro to set a Flag on each task using a specific
resource. Then filter on that flag.


Sub ResourceFilter()
Dim sRes As String
Dim oTask As Task
Dim oRes As Resource
Dim oAss As Assignment

'\ Get user name
sRes = InputBox("Type a resource name")

'\ Remove Flag1
For Each oTask In ActiveProject.Tasks
If Not (oTask Is Nothing) Then
If oTask.Flag1 = True Then
oTask.Flag1 = False
End If
End If
Next

'\ Set Flag 1
For Each oRes In ActiveProject.Resources
If Not (oRes Is Nothing) Then
If oRes.Name = sRes Then
For Each oAss In oRes.Assignments
ActiveProject.Tasks(oAss.TaskID).Flag1 = True
Next
End If
End If
Next

End Sub

Tomm,

That is a good idea, but the drop down list SHOULD work.

--
Please try to keep replies in this group. I do check e-mail, but only
infrequently. For Macros and other things check http://masamiki.com/project

-Jack Dahlgren, Project MVP


+++++++++++++++++++

 

[Tomm \(portrett.no\)]

That's true.

Tomm,

That is a good idea, but the drop down list SHOULD work.

--
Please try to keep replies in this group. I do check e-mail, but only
infrequently. For Macros and other things check http://masamiki.com/project

-Jack Dahlgren, Project MVP


+++++++++++++++++++

 

[Tommy Lovelace]

I have had many people contact me regarding this problem.
In each case, after reviewing their files, I noticed that
they had turned on "Automatically Add Resources" and had
accidentally hit a period or some letter key, which in
turn automatically added that period or that letter as a
resource. Might be a place to start for you.....Tommy