Notes

I have no problem if anyone does anything with this program. Enjoy it as much as you can because I know your work is difficult.

I would like to receive program changes in return and I'll try to incorporate the most generic ones and send it out in a few months. That is, if I get some changes. If I run into some snags I will ask for help incorporating. In order to keep it simple, please send revisions in Access 2. The newer ones are great but I'd like to make it so the most number of people are benefiting.

Apologies in advance for any bugs, unfinished work or anything else you might find irritating.

Below is a list of stuff I never got around to.

  1. Split app and data. Yeah I should have done this a long time ago.
  2. Edit/Save button. - A single button that changes it's personality. If the record is not being edited the button says "Edit". While the record is being edited the button says "Save".
  3. Make Customer Department and Work Records navigation line up. In other words, if I am editing a record in Work Records, when I press the Customers tab the record being displayed should be that customer.
  4. Get reports to email and not rtf or doc attachments.
  5. Get e-RC button to work. Good luck and if you do get it to work send documentation.
  6. Filter panel. Every now and then I considered making a filter panel pop up in the right square.
  7. Create radio buttons to pop up different subforms in the Work Records form right square (calendar, todo, filter panel, most recent)
  8. Propagate consistent look for edit/find/new/delete/save throughout all forms.
  9. Trickle down lists. When a department got in a pile of new machines, we unfortunately had to put the new machines in the same hot spots year after year (almost) and their machines went to someone else and theirs to someone else. Making a coherent chart that described that activity was a chore since we would always get the information from a liaison who had a different manner of expressing cascading lists of domino moves, trickling down to disposal authority forms.
  10. Create dead file and easy method of moving records there.
  11. Get business managers to access their own inventory and IS work records.
  12. Create installation program or a slick way for the program to install a new version of itself on the analyst's c: drive.
  13. Attendance reports and vacation / holidays allotments and accruals. Yeah, track attendance and vacation entitlement of our staff.
  14. Fulfillment index. Some cool algorithm that suggests whether this department is or should be happy. Necessary ammo.

Below are most of the things I added.

  1. First name field (mixed fields from other tables) 12/7/96
  2. Customer, Analyst, and Project combos to display in TODO panel 12/7/96
  3. On New record and completion of Fill in Customer name automatic filter by customer 12/7/96
  4. Get Project to work. (filter project) + if work record is duped and project number is 0 then project number = highest number + 1 (lone record projects don’t get a project number) 12/7/96
  5. Application subform for department
  6. Pick up user name from environment string and stuff field 11/9/96
  7. Get stop time to actually stuff field with value. 11/9/96
  8. Make filter buttons letters change color to show which one is on. 11/9/96
  9. Proper relationships so that 11/9/96
  10. Combo box filters for analyst and for customer which will probably require a 11/9/96
  11. I can show first name and last names of customers on work records form. 11/9/96
  12. Add record date (date of call)
  13. Add project number
  14. Add elapsed time
  15. Add To Do list
  16. Add calendar
  17. Add filter customer
  18. Add filter analyst
  19. Create tabs
  20. Create morning meeting report
  21. Create Week Ahead report
  22. Create The Undone report
  23. Create Staff List
  24. Create Department Totals
  25. Create sub-forms for sub-departments, hardware and applications

top of The Work | top of site