Application written in C# that modifies a specific Access database and table, needs additional functionality and some additional functionality.
## Deliverables
1.)? ? If possible add ability for the modification of the BLOB (fields DrawS and DrawN)? from within the application using the? left mouse button to add black and right mouse button to paint white. Also, would like to Overlay [login to view URL] (DrawN)? and [login to view URL] (DrawS)? over/under the BLOB resulting in something similar to what is shown in [login to view URL]
2.)? On devices with smaller screens like a UNMP's and netbooks, the gridview currently located at the bottom of the application isn't visible.? And there are no scroll bars to allow viewing.? I would like the Gridview always be available? regardless of the devices screen or the windows dimensions. Perhaps the best solution would be to move the gridview into a new tab.
3.) Add the Company's logo to the About box. ([login to view URL])
4.)? Move the About GenGel from the File title bar menu to a new Help menu and rename it to "About".
5.)? Add a titlebar menu titled Filter that allows the user to filter by the following Map, Job No, WkEnd, Lname, Lno, Twnshp/Rnge/Sec, also need an option to remove the applied filter. I would prefer if dynamically driven drop downs were used populated with unique data from the table rather than? user entered text fields.
6.)? In the File titlebar Menu could the option to delete all records be added.? Be sure that a message box pops-up? Yes/Cancel that? the user really wishes to delete ALL records. I would like it to look as ominous as possible.
7.)? Move the Map edit from Details tab into the Header Info tab.
8.)? rename the following labels:
Currently? ? ? ? Change to
Pole No? ? ? ? ? ? ? ? Pole Number
Loc? ? ? ? ? ? ? ? ? ? ? ? ? ? ? Location
Twnshp? ? ? ? ? ? ? ? Township
Rnge? ? ? ? ? ? ? ? ? ? ? ? Range
Sec? ? ? ? ? ? ? ? ? ? ? ? ? ? ? Section
Directn? ? ? ? ? ? ? ? ? Direction
PYear? ? ? ? ? ? ? ? ? ? ? Vintage
PYearE? ? ? ? ? ? ? ? ? Estimated?
Spec? ? ? ? ? ? ? ? ? ? ? ? Species
OTrt? ? ? ? ? ? ? ? ? ? ? ? Original Preservative
HGT? ? ? ? ? ? ? ? ? ? ? ? Height
Cnstrc? ? ? ? ? ? ? ? Construction
Ocirc? ? ? ? ? ? ? ? ? ? ? ? Circumference
Ecirc? ? ? ? ? ? ? ? ? ? ? ? Effective Circumference
Inspstat? ? ? ? ? ? Inspection Code
Main Com? ? ? ? Maintenance Comments
Loc Com? ? ? ? ? ? ? Location Comments
Cond Com? ? ? ? Condition Comments
Intrnl? ? ? ? ? ? ? ? ? ? ? Internal Treatment
BRods? ? ? ? ? ? ? ? ? ? Boron Rods
Oz Vile? ? ? ? ? ? ? ? Fumigant (Oz/Viles)
Drv Rod? ? ? ? ? ? ? Installed Ground Rods
Grst1? ? ? ? ? ? ? ? ? ? ? 1st Resistance Test
Grst2? ? ? ? ? ? ? ? ? ? ? 2nd Resistance Test
Grst3? ? ? ? ? ? ? ? ? ? 3rd Resistance Test
Inst GG? ? ? ? ? ? ? ? Installed Guy Guards
PMFG? ? ? ? ? ? ? ? ? ? ? ? Manufacturer
DrawS
DrawN? ? ? ? ? ? ? ? ? Decay Diagrams
Wk End? ? ? ? ? ? ? ? Week Ending
WGS84LON? Longitude
WGS84LAT? ? Latitude
Job No? ? ? ? ? ? ? ? Job Number
Insp? ? ? ? ? ? ? ? ? ? ? ? Inspector
wthr? ? ? ? ? ? ? ? ? ? ? ? Weather
Cnty? ? ? ? ? ? ? ? ? ? ? ? County
St? ? ? ? ? ? ? ? ? ? ? ? ? ? ? ? State
PSRVTV? ? ? ? ? ? ? ? Applied Preservatives
sub sta? ? ? ? ? ? ? ? Sub Station
Cust? ? ? ? ? ? ? ? ? ? ? ? Customer
Lname? ? ? ? ? ? ? ? Line Name
Lno? ? ? ? ? ? ? ? ? ? ? ? ? ? Line Number
Lvolt? ? ? ? ? ? ? ? ? ? ? ? Voltage
Purc Or? ? ? ? ? ? ? ? Purchase Order
* leave the field titles in the data view as they are (if desired).
9.)? Move Exp Gr, Brk Grnd, CGrate, and ExpGA to Advanced Inspection tab from details tab
10.)? Add a checksum or dropdown? so that Height is no less than 25 and no greater than 135 and cleanly divisible by 5 (i.e. 25, 30, 35, 40, 45, etc.)
11.)? Make Class a drop down selection from the following 8, 7, 6, 5, 4, 3, 2, 1, H1, H2, H3
12.) Ocirc must be null, or between the following range 12 thru 87.? Ecirc must be less than Ocirc, null, or 0.
13.) Give BRods a drop down menu from 1 thru 12 or null
14.)? Give Oz Vile a drop down menu from 1 thru 12 or null
15.)? give Drv Rods a drop down menu from 1 thru 6 or null
16.) Give Inst GG a drop down menu from 1 thru 12 or null
Sample database [login to view URL] has been included the application should locate it in C:\My Documents and open the table tblGenGL upon starting.
*** It is important that no other Forms/Queries or Tables inside the Database be changed or manipulated by this application