This project will use VB 6, and SQL 2005. It will be used to track and log downtime on factory machinery. There will be two parts to the program. A logging GUI, and a reporting GUI both written in VB6. You will also provide the script to create the tables for the database.
Logging application
When first launched the application will prompt for the SQL information. We use username / password for our database rather than windows authentication. The SQL information will be stored in the registry using “SaveSettings”. The settings will be the ip address of the SQL server, the database to use, and the credentials to login with. On subsequent launches the application will load the settings from the registry and read the info from the database. There will be a menu button that will allow the user to change the database settings.
The main from will have a combo box for the user to select the Machine that they are going to be doing a downtime study on. Then there will be a button labeled with “Start” button that will start a timer, and then change to a “stop” label. The program will display the accumulated time in seconds on the form. When the button is pressed a second time the program will stop the timer and prompt the user for a “reason” The list of reasons will be stored in the database and will be machine specific. In other words machine “a” will have different downtime reasons that machine “b”. The user will be able to add new reasons to the list and those reasons will be stored in the database.
Database
The following information will be stored in the database.
A table of Machine Names
A table of downtime reasons that is tied to the machine names.
A table of downtime that is tied to the machine name, and reason
Reporting application
This program will allow the user to select a machine, and a date range and will display the accumulated downtime and percentage that that reason accounted for each reason that machine was down.
I have attached a screenshot of the date picker I would like to use for the date range selection.
The report will look something like…
Downtime Report for Machine A.
Downtime Reason 1. .. 5:12:12 61%
Downtime Reason 2 …. 2:04:56 24%
Downtime Reason 3 … 1:13:15 14%
i am expert vb6 & vb.net programmer with over +15 years experience in programming. i can make your application exactly as you want it. i made many desktop utilities with both vb6 & vb.net. and i can start now