PM forgets to save the file!

[hazim]

Hi,

It often happens that a Project Manager accepts all the
times submitted for his/her projects via Project Central
and then forgets to save the file. Project Central thinks
that the Task has been Updated and if the PM has hundreds
of Tasks to process, going back one by one is pretty much
not practical ... I am hoping that someone can point me to
a SQL script that will reset the task messages for a
Particular Project on Project central, so that the PM can
go back and accept all of them again ... and SAVE the file!

Thanks,
-Hazim

 

[Jack D.]

Hi,

It often happens that a Project Manager accepts all the
times submitted for his/her projects via Project Central
and then forgets to save the file. Project Central thinks
that the Task has been Updated and if the PM has hundreds
of Tasks to process, going back one by one is pretty much
not practical ... I am hoping that someone can point me to
a SQL script that will reset the task messages for a
Particular Project on Project central, so that the PM can
go back and accept all of them again ... and SAVE the file!

Thanks,
-Hazim

I think it would be best to remind the PM's to save instead of messing with
the database.
You could insert the following code into the file so that they will be
reminded and if they just hit enter the file will be saved automatically.


Private Sub Project_BeforeClose(ByVal pj As Project)
If MsgBox("If you have saved after updating the file click OK" & _
Chr(13) & "If not click 'Cancel' and the file will be saved", _
257, "Please Save File After Update") <> vbOK Then
FileSave
MsgBox "File is saved"
End If
End Sub

To make it run, open the file you want to put it in.
Hit F11 to bring up the visual basic editor.
In the little window in the top left browse for the project you want to
insert it in.
Expand to show "Microsoft Project Objects" -
"ThisProject(nameofyourproject).
Double click on "ThisProject"
Paste that code into the window that appears.
Save the project.

Now when anyone closes they are prompted again if they want to save with the
default (cancel) resulting in an automatic save.

--
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


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