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.
”The time we save is the biggest benefit of E-E to our team. What could take multiple guys 2 hours or more each to find is accessed in around 15 minutes on Experts Exchange.
-Mike Kapnisakis, Warner Bros
With your subscription - you'll gain access to our exclusive IT community of thousands of IT pros. You'll also be able to connect with highly specified Experts to get personalized solutions to your troubleshooting & research questions. It’s like crowd-sourced consulting.
We can't always guarantee that the perfect solution to your specific problem will be waiting for you. If you ask your own question - our Certified Experts will team up with you to help you get the answers you need.
Our certified Experts are CTOs, CISOs, and Technical Architects who answer questions, write articles, and produce videos on Experts Exchange. 99% of them have full time tech jobs - they volunteer their time to help other people in the technology industry learn and succeed.
We can't guarantee quick solutions - Experts Exchange isn't a help desk. We're a community of IT professionals committed to sharing knowledge. Our experts volunteer their time to help other people in the technology industry learn and succeed.