I need to assign resources to tasks and have some troubles.

[Eugene Rokhlin]

Another question about creating a new project file from a database.

OK, I have tasks in one table

TaskID
Description
WBS
etc...

I have resources in another table

TaskID
EmployeeLogon
Effort
etc....

It would be good to use
Task.UniqueID = rs.Fields("TaskID")
when creating a task and then assigning resources would become easy.
But the UniqueID is a read-only field and this line would not compile.

So I'm looking for a workaround.

Can someone recommend an elegant one?

Well, I have some ideas like getting a recources recordset and a tasks
recordset, disconnecting them and then go and insert tasks. After inserting
a new task, get its UniqueID, go to the resources recordset, store this id
in some field there, and then use it when assigning the resources. This may
work, only seems a bit complex.

 

[Rod Gill]

Hi,

Yes, if you're using automation then you do need to add the task, then read
its UID and update your task table with it.

--
Rod Gill
Project MVP
For Microsoft Project companion projects, best practices and Project VBA
development services
visit www.projectlearning.com/