Due to the overwhelming number of requests (3+) for screenshots and code for the Status Report described in a previous post , I’ve decided to make them publicly available. My only request is that you let me know how I can improve the form.
Here is the “Individual View”:
It uses a Master-Detail control for viewing multiple Status Reports at once.
Here’s the “Team View”
It groups things by section, rather than by person. I had to use a secondary data source and some scripting to get this to work. Perhaps someone can come up with a more elegant solution.
Here is the original form template. Also included are the two data sources (Access databases) that the form depends on.
A couple of notes on running this form:
- I created an access database for the form to run in, but the form is currently hardcoded to look for the Access DB at C:\StatusReport\. Unzip the files to that location for the form to run properly. When you deploy the form to users, you should put the Access DB in a shared location, or use SQL Server.
- The original form uses a Web Service to get the current user name. I had to remove this in order for this form to be functional, and I replaced it with a call to the WScript.Network ActiveX control. Unfortunately, this ActiveX control is unsafe, and requires the form to be Fully Trusted. Until you get your own web service written, you can test the functionality of the form by opening it in the Designer and Previewing.
If you have any questions or problems, let me know.