The first goal of the project was to make easy to register inspection related data and to produce quality reports subsequently. The measurement data are input by Quality Inspector in every hour (eight times per production shift), three shifts per day, five days per week, around four to eight different parts per day, one to eight cavities per mold and, obviously, the generated amount of paper was enormous...
By design, the application will be tied strictly to PLASTIC INJECTION MOLDING manufacturing environment and set the main limit of up to eight cavities per mold.
During the developing phase, as usual, a few problems have to be overcome to make this application easy to work with. Below is a list of tools I am using (or was testing) in order to create and support the application.
- MS Access 2003 is the only IDE tool used to create an environment able to do the job without any additional cost. Every computer in the Company has already MS Office Pro installed in it.
- In this task VBA is going to do the business logic and DAO to manipulate an Access 2003 database. One standard any_name.mdb file is suppose to accommodate the VBA code, the user interface, business logic and the data.
- Screen capture (screenshot and screencast) software which helps me to make useful documentation:
-- If you are using Vista could try this: C:\Windows\System32\SnippingTool.exe
-- Greenshot - see the sample on right :) this happen to be my favorite
-- CamStudio - I hope it will help me in future
