Microsoft KB Archive/117809

From BetaArchive Wiki

PRJ4: Problem with Microsoft Project Timesheet Program

Q117809



The information in this article applies to:


  • Microsoft Project for Windows, version 4.0





SUMMARY

Microsoft Project Timesheet is a Microsoft Visual Basic program that is included with Microsoft Project. You can use this program to update resource work in your project on a task-by-task basis. The following is a summary of the problems that you may encounter when you use the Timesheet program.

An updated version of this program is now available from the Microsoft Download Center. For more information, please see the following article in the Microsoft Knowledge Base:

Q126379 PRJ4: Updated Timesheet Program Timetrak.exe for Project 4.0/4.1



MORE INFORMATION

You can run Microsoft Project Timesheet by clicking the Update Resources button on the Tracking toolbar. When you run the Timesheet program, the Resource Update Options dialog box appears, and allows you to update work for all of the resources in your project or for an individual resource in your project, in a Visual Basic timesheet. Each timesheet displays the task assignments for a resource in a table, including work and scheduling information for each task. The information in your project is updated when you change information in a timesheet. You may encounter any of the following problems when you use this program.


Error Message Entering Value in Timesheet

If you enter a date in the form of Today, Tomorrow, or a day of the week, such as Monday, in the Start Date or the Finish Date column in the Timesheet, you receive the following error message:

The date you entered is not in a recognized date format

Even though you can enter these values in your project in Microsoft Project, these are not valid date formats in Microsoft Project Timesheet. Because Timesheet is a program written in Visual Basic, not all of the features available in Microsoft Project are available in the Timesheet program.

Incorrect Resource Work in Updated Project

In Microsoft Project Timesheet, if you enter a value in the Hours Worked column for a resource assignment, and you then enter another value, while the Update Resource Work dialog box is still open, the resource Work value is incorrect when the schedule is updated.



WORKAROUND

If you enter incorrect information in the Update Resource Work dialog box, click Cancel, and then click OK to open the Update Resource Work dialog box again, and enter the correct information.

Task Doesn't Display in Timesheet

A task that is marked as a milestone in your project is not displayed in the Update Resource Work dialog box, even if the duration of the task is greater than 0d. When a resource is assigned to a task with more than 546 hours of work, the resource does not appear in the timesheet. Under this condition, Microsoft Project Timesheet cannot update the resource. If you choose to update only this resource, or if this resource is the only resource that has a task assignment in your project, you receive the following error message when you update the resource:

The selected resource does not have any task assignments within the specified date range

Incorrect Results with Project Scheduled from Project Finish

If you have a project that is scheduled from the project finish, and you update the task Start Date in the Update Resource Work dialog box to a date prior to the Start Date in the Summary Info dialog box, you receive the following error message:

Task start date is before the project start date

To change the task start date, use the Start Date field in the Gantt Chart.

In a project scheduled from the project finish, if you use the timesheet to change the finish date of a task to a date later than the project finish date, you do not receive an error message indicating that the task finish date is after the project finish date. However, when you close the timesheet, the task finish date is not updated in the project.

Project Summary Task No Longer Displayed

After you run Microsoft Project Timesheet, the project summary task is no longer displayed in your project. The Project Summary Task check box on the View tab of the Options dialog box is cleared after running the Microsoft Project Timesheet, whether or not it was selected before you ran the program. This behavior occurs even if you click Cancel in the Resource Update Options dialog box. To display the project summary task in your project after running the Microsoft Project Timesheet, follow these steps:


  1. On the Tools menu, click Options. Click the View tab.
  2. Under Outline Options, click to select the Project Summary Task check box, and click OK.

Microsoft Project Timesheet Already Active After Closing

If you run Microsoft Project Timesheet, and you close the Resource Update Options dialog box by clicking Close on the Control menu, or double- clicking the Control menu, you receive the following error message when you run the program again in the same session of Microsoft Windows:

A copy of Microsoft Project Timesheet is already active



Use the Close or Cancel button in the Resource Update Options dialog box to close the Timesheet program, instead of double-clicking the Control menu or clicking Close on the Control menu.

To quit the program once you have closed it using the Control menu, run the Task List (press CTRL+ALT+DEL), click to select Timesheet, and then click End Task.


Error Message Entering Date

When entering a date into a date field in the TimeTrk program, the following error message may be generated:

The date you entered is not in a recognized date format



This occurs when the file Msafinx.dll file is not in the \Windows\System directory. This file was not shipped with Microsoft Project, therefore systems that do not have Visual Basic installed can receive this error.

Error Message Updating Resources

When selecting a resource to update, you may receive the following error message:

The selected resource does not have any task assignments within the specified date range

This problem occurs when a resource is assigned to a task for more than 546 hours of work. If this situation occurs, no tasks for the resource will be displayed in the Timesheet program. It does not matter if there are tasks with the resource assigned with fewer than 546 hours of work; no task will be displayed.



STATUS

Microsoft has confirmed these to be problems in the Microsoft products listed at the beginning of this article.



REFERENCES

For more information about the Update Resources Command, click the Search button in Help and type the following text:

time sheet, updating

Additional query words: timetrak mak vb err msg

Keywords : kberrmsg kbtool kbdta
Issue type : kbbug
Technology :


Last Reviewed: November 3, 2000
© 2001 Microsoft Corporation. All rights reserved. Terms of Use.