I have attached a an Access DB. What I want to do is to convert the access DB and forms into a browser based solution. Reason being, we are going to need to have multiple people accessing different forms of the system at the same time.
This system is to track repair orders for tablet computers. Repair orders are entered, and then a technician will repair the machine. The repair is going to be an addition to this system.
To explain this simply there are a few parts....
1. Lookup Warranty - This is the form "TabletWarrantyLookup"
This form tells us if the machine is still eligible for warranty repair
2. Add Repair Order - This is the form "RepairOrdersForm"
This form is where the repair needed is entered into the DB. This includes the diagnostic like HDD and Fan need to be repaired by selecting them from the drop down. We're hoping to expand this a little and have a "order parts" portion where the parts can be "ordered." At the end of the day, we print an order parts report and send this to the part company. We will also need to enter in that a part has arrived so that we know the machines that are ready to be repaired. If the machine is being shipped out, the print label button is needed too.
3. New portion needed - Repair Ticket - This is when the machine is being repaired. We need to determine EXACTLY what was done to the machine such as new HDD, RAM, System Board, etc. When this ticket is closed at the completion of a repair, the repair order is closed.
The reports within the current system will still be needed:
-Open Repair Orders
-Repair History by Serial Number
Hopefully, someone is out there that is willing to give me a hand with this! It's something that is much over due in my department.