Need estimate for HTML, VB or Excel type maintenance work order entry screen. This screen will be accessed by anyone on our company network (icon on their desktop or task bar). Data entered on this screen should store in a database for reporting and ultimately be "Hot Linked" (imported) or manually entered into our company computer software (JD-Edwards Equipment Plant Maintenance). Currently the work order entry screen in this software is so complex no one on the plant floor will use it. We need a very simple work order entry screen for this purpose. This screen needs to be pleasing to eye (color, border, etc) and use pull down fields to easily select data needed (this data will be provided and my require you to store in database . Below is the information and fields that will be needed. - Our company name and logo at top of work order screen - and "Maintenance Work Order Request" - Current date & time stamp when work order is entered. - Pull down for selecting employee name (includes six digit employee number - field should populate with both employee name and number. when selected). - Pull down for selecting four-digit production line number. - Pull down for selecting six-digit asset number and description (both should show up on screen after selected). - Pull down for selecting fault code (Line Down, Normal Repair, Safety Issue) - Pull down for selecting shift (First Shift, Second Shift, Third Shift) - Pull down for selecting printer (currently two printers involved in two separate buildings on same network). - Small field to enter short description of problem (thirty character limit) - Large field at bottom for entering "Description of Problem" - Button at bottom to "Send" work order to maintenance printer. - All fields will be required and will request entry if missed. I have attached a poor attempt at this in Excel for your review.
1) Complete and fully-functional working program(s) in executable form as well as complete source code of all work done.
2) Installation package that will install the software (in ready-to-run condition) on the platform(s) specified in this bid request.
3) Exclusive and complete copyrights to all work purchased. (No GPL, 3rd party components, etc. unless all copyright ramifications are explained AND AGREED TO by the buyer on the site).
All workstations have the following: Win2000 Internet Explorer (Plant - Intranet only) Lotus Notes JD-Edwards (OneWorldxe)