For the last several months I have been in the process of creating a application for the recording of injuries at the company I work at, for all of our facilities where we track injuries, currently (5).
The workbook I have created uses both userforms and activex controls. I decided to go this route since it would be easiest to display the information I needed, the purpose of the user forms is for data input only.
One of the features I am proud of that I have included in this workbook is the login page. I have created this since multiple users will be using this workbook and each will have a different level of access, and that level of access also determines what fields are visible to the user on the main pivot table. To prevent unauthorized access to a user account, after the user enters their username, the program looks at the application user name and if they match, then the user may proceed to enter their password.
Speaking of Pivot Tables, this report contains 28 different pivot tables. The reason for this is to display the different charts that are available, however the downside is that this tends to bog down the program, especially when adding an injury.
What I am requesting is a review of the application and any advice to improve its performance. The file itself is about 1 meg in size due to the fact that it has a year and half's worth of data and for two plants.
The workbook can be accessed via this link: https://drive.google.com/file/…YRVpQbFk/view?usp=sharing
thank you to anyone to who takes the time to review this.
Implementation of this program is scheduled for January 2016, so as to give me time for testing and debugging. I am also in the process of creating a manual for the program as well as a tutorial.