B
Bev Kaufman
As I mentioned in an earlier post, I was told to adapt a Microsoft timesheet
template, switching it from XML to Sql. Looking ahead to the possibility
(probability?) that this can't be done - meaning I will have to create this
form from scratch - I have been disecting the template, trying to figure out
how it works.
There are two non-repeating tables with 7 columns for the 7 days of the
week, and several rows representing start and end times of different shifts
and the different kinds of leave. Each cell in the table is a specific
field, such as week.day1.subShift1.regularHours.startTime. Each time an
entry is made, an UpdateTotals function is run to calculate and populate
daily and weekly totals.
UpdateTotals is called from three functions in the script:
function msoxd__startTime::OnAfterChange(oEvent)
function msoxd__endTime::OnAfterChange(oEvent)
function msoxd__hours::OnAfterChange(oEvent)
But when I look at the Data Validation dialog of these fields, there is no
event code selected. So what is connecting the OnAfterChange code to the
fields? And what is this msoxd prefix? I did a search of the script and I
don't see if declared anywhere.
template, switching it from XML to Sql. Looking ahead to the possibility
(probability?) that this can't be done - meaning I will have to create this
form from scratch - I have been disecting the template, trying to figure out
how it works.
There are two non-repeating tables with 7 columns for the 7 days of the
week, and several rows representing start and end times of different shifts
and the different kinds of leave. Each cell in the table is a specific
field, such as week.day1.subShift1.regularHours.startTime. Each time an
entry is made, an UpdateTotals function is run to calculate and populate
daily and weekly totals.
UpdateTotals is called from three functions in the script:
function msoxd__startTime::OnAfterChange(oEvent)
function msoxd__endTime::OnAfterChange(oEvent)
function msoxd__hours::OnAfterChange(oEvent)
But when I look at the Data Validation dialog of these fields, there is no
event code selected. So what is connecting the OnAfterChange code to the
fields? And what is this msoxd prefix? I did a search of the script and I
don't see if declared anywhere.