Changes for new Policy

- Changed VacaWEEKSavail to vacaHOURSavail
Years worked calculated with Current year against year of hire date.
(11/29/2012 minus 8/25/2008 = 4 years)

Conditions for hours available:

Case 1 To 4
CalcYearsWorked.VacaHoursAvail = 80
Case 5 To 11
CalcYearsWorked.VacaHoursAvail = 120
Case 12 To 20
CalcYearsWorked.VacaHoursAvail = 160
Case 21
CalcYearsWorked.VacaHoursAvail = 168
Case 22
CalcYearsWorked.VacaHoursAvail = 176
Case 23
CalcYearsWorked.VacaHoursAvail = 184
Case 24
CalcYearsWorked.VacaHoursAvail = 192
Case Is >= 25
CalcYearsWorked.VacaHoursAvail = 200

NOTE:
----

***Working on calculating hours available after hour taken***

Since I have to account for individual days(hours) now, these new
methods will not be compatible with the current data in the database. We
will likely have to wipe it out and start fresh. The current data is
recording 7 day weeks, the new stuff will need to be work days only (5
days).

----

-Finished changing calcweeksavail to hour based. I query for vaca
entries between 1/1 of current year and 12/31 of current year, and run
zero based calcs on each entry and add 1. So if someone takes 1 day it
returns zero, to which I add 1 so (2/2/12 minus 2/2/12 = 0 + 1 = 1 day).
So 2 days is (2/3/12 minus 2/2/12 = 1 + 1 = 2 days)  This allows more
intuitiveness when adding entries. Users can select startdate 2/2/12 and
enddate 2/2/12 to record a single day vacation, as opposed to 2/2/12 to
2/3/12 for a single day.

-All functions changed to hour format.

-After selecting a startdate, the enddate will automatically be set to 5
days later, instead of 7. (Right now it's not ignoring weekends, so it's
not accurate for vacations starting midweek. May revisit this later.)

-Added row to vacation grids to show number of hours for each entry.

-Updated labels to hours

-Changed the current period display

-Fixed Editing, Printing and deleting functions that were broken from
the additional hour column
Layout changes

Compacted the layout of a couple forms.
CSI and VBW sync
Layout and Fixes

- Fixed years worked calculation.

- Removed the auto enddate selection.

NOTE:
---------------------------------

Holiday handling:

In order to correctly represent the time taken when a vacation is split
by a holiday, the user will need to add multiple entries for a single
vacation. Ex.(If someone was taking a vacation on the week of July 4th.
You need to add one entry for 7/2 to 7/3 (16 hours) and another entry
for 7/5 to 7/9 (24 hours)).

----------------------------------

-A little more layout compression.

-Disabled the Accruals run button.

-Fixed some printing typos
Procedure Changes

As per user:
Hours are no longer calculated, they will be entered be the user.

Added hours field and changed the loading and editing subs to handle the
the new procedure.
Few changes and Go live

Compress the UI a little more. Now live on policy change.
Floating Holiday and Bugfix

-Added hours to all for floating holiday.
-Fixed bug that prevented vacation 'Add' button from enabling
Username Update
New Server IP

Changed Server IP
Bugfix attempt

Trying to fix bug causing windows to switch focus after adding entries.
Vacation Report Bugfix

WhoOnVaca sub wasn't requesting it's results to be ordered by date and
was outputting gibberish. I have no idea how it ever worked before like
this. My only guess is that the previous version of the MySQL server
defaulted to that particualar order by. Now it appears not to. Added
order by.  :-o
Global ADO

Switched to global ADO connection.

Exponential proformance improvments on some reports, particularly over
VPN.
Vacation Rpt Hour Display

Added hours, removed status from vacation report as per users request.
Fixed some print issues
New User
New Fields and Connection Timer

Added a timer that keeps the SQL connection awake to prevent timeout
disconnects.
Added LastModified and LastModifiedBy fields to the DB. As more users
get access, I felt this would be good info to have.
Security Updates - More secure/easier to manage

- Created a new SQL Table that contains authorized users and R/W access.
- Added sub to check against local username and provide will Full R/W or
R/O access or kill the program (Username not in table).
Merge remote-tracking branch 'origin/policy-change'

Conflicts:
	Form1.frm
	Module1.bas
	Project1.csi
	Project1.vbp
	Project1.vbw
	frmVacationReports.frm
Recompile after merge