The file can be downloaded below
Offering $25.00
Double-click column C7:C37, frmFLT form appears…
1. In the “Depart & Dest Airport” combo boxes, I want to select an airport from the drop down menu from the listed airports in column U.
2. When I type a 4-digit number into the “Report, Depart, and Dest Time” textboxes, it should automatically convert the 4-digit number into a time value base on a 24hr clock system (HH:MM). (Similar code already exists, but can be changed if needed.)
3. If a time value is entered into the “Report Time” textbox, that time should be entered into columns O7:O12.
4. If the “Dead Head” checkbox is checked, it should place an “X” column B.
5. When I click the “Update” button, the information should be entered into the sheet. (Note: when the information is entered into the sheet, column D & G should display the corresponding time zone for that airport as listed in column V.)
6. If I Double-Click column C7:C37 with existing information, it should pre-fill the frmFLT form. (Note: The “Report Time” Textbox should remain empty.)
7. When data is entered into the sheet, the data in columns B7:J37 should automatically sort by date.
8. When I double-click on a Date in column C7:C37 that has existing data and I click the delete button, only that data should be deleted and the remaining data in columns B7:J37 should be sorted.
When I Click the “New Airport Listing” button on the frmFlt, frmAprt appears…
1. After entering the airport’s name and the corresponding time zone into the frmAprt form, the information should be entered into column U:V
2. After the information is entered into column U:V, it should sort alphabetically by airport name.
3. I should able to select an airport from the drop down menu from the airports listed in column U and the corresponding “timezone” textbox should pre-fill for that airport.
Note: the tables are complete tables. They will not have new rows or columns added.
Note: I should have the ability to start with a empty table.