Project Sequence Number

[Morne Taljaard]

Hi,

I have a couple of custom enterprise fields. One of them is a Project Number that I create in VBA when the project status is set to "Approved".
The Porject Number needs to have the following format. DIS-2008-001, DIS-2008-002 etc....
I create the Project Number before save and works fine but I need to get a way to increment the sequence part of the number for each project that gets set to Approved.

Is there a way in Project Server to do something like this and get the value back in VBA before save.

Thanks
Morne

 

[Morne Taljaard]

I have a couple of options that I can try to get the correct number for them.<br /><br />What I can do is have file sitting on the server and access the file with VBA. The file would have the next sequence number inline and then update the file afterwards to the next number. Not sure this is the most sufficient method.<br /><br />or else<br />create a table on project server that has the next sequence number and access that from vba.<br /><br />Will have to test and see which is going to be the best solution use.

 

[Morne Taljaard]

Is it possible to add values to a Lookup table with vba?
I got another idea that I want to test....

Thanks
Morne

 

[Morne Taljaard]

Okay,

what I did to get a incremental number was the following:
I created a table on the server with a integer field.

Before the user saves the project file, I do a couple of checks and if
need be, I access the database, get the value, update the project number
field and then update the database field with the next number.

It works, is pretty fast, so i'm happy

Morne

 

[Morne Taljaard]

with the changes that I have made to create the project number once the
project status (custom field) change to "approved", another issue came
along"

I've read that you cannot disable or stop a user from changing project
information.

Only certain users must be able to change the project status field to
approved, but seeing as this is not possible, is there perhaps another
solution or suggestion, where I can create a project number once a
project has been approved, only by users that have access to modify the
custom field.

Thanks
Morne