Completed

Job Tracker

This project was successfully completed by israrsoft for $50 USD in 5 days.

Get free quotes for a project like this
Employer working
Completed by:
Project Budget
$30 - $250 USD
Completed In
5 days
Total Bids
27
Project Description

---:[Program Description]:---
I need a program that can load stored Part Information from an access database and/or allow new Parts/Gages to be entered into a work grid
A user should be able to search the database for an existing Gage or Add a New gage.

- When Selecting from the database there should be an area for typing the GageID, which will return all LIKE results from the *[Gage] Table to a small result grid from which a user will then select then that information and populate into some textboxes so it can be edited if needed along with adding a savename before being added to the "Work Grid" which should be bound to the *[TechSheet] Table.

- When Adding new ALL *[TechSheet] table fields minus the "ID" should be visble. The "Description" and "Manufacturer" should autocomplete with a dropdown similar to the Google Dropdown as they are typed from the *[GageType] and *[Manufacturer] tables.

Once the Gage Information is either Entered New or Selected the user can click a button to add the information to the [TechSheet] Grid. At this time 2 verifications must take place.

1) Verify the savename File actually exists, if the file does not exists popup a warning and dont let the gage be added until they enter a valid filename. (We will store a path ONLY a filename will be entered in the SaveName field.)

2) If the gage was selected and any information is modified then write the modified and original information to the *[GageDescrepancy] Table.

***The *[GageDescrepancy] table and "Work Grid" should be able to be exported to excel.



---:[Input Text Files from which database will be populated]:---
FieldService File:
JobNo, CompCode, CompanyName, Address, City, State, Zip, StartDate, EndDate, PONo, ContactName, ContactPhone, ContactEmail

Gage File:
GageID, GageType, Description, Manufacturer, ModelNo, SerialNo



---:[Database Tables and Fields NEEDED]:---
*[FieldService]
ID, JobNo, CompCode, CompanyName, Address, City, State, Zip, StartDate, EndDate,
PONo, ContactName, ContactPhone, ContactEmail

*[Gage]
CompCode, GageID, GageType, Description, Manufacturer, ModelNo, SerialNo

*[Manufacturer]
ID, ManufacturerName

*[GageType]
ID, GageType

*[TechSheet]
ID, JobNo, GageID, GageType, Description, Manufacturer, ModelNo, SerialNo, SaveName

*[GageDescrepancy]
ID, NewJobNo, NewGageID, NewGageType, NewDescription, NewManufacturer, NewModelNo, NewSerialNo, NewSaveName, OldJobNo, OldGageID, OldGageType, OldDescription, OldManufacturer, OldModelNo, OldSerialNo, OldSaveName

Looking to make some money?

  • Set your budget and the timeframe
  • Outline your proposal
  • Get paid for your work

Hire Freelancers who also bid on this project

    • Forbes
    • The New York Times
    • Time
    • Wall Street Journal
    • Times Online