Can't figure out how event code gets called

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.
 
C

Clay Fox

So are you migrating from InfoPath or to InfoPath?

If you need a way to integrate InfoPath and SQL ( Have InfoPath front end
SQL data) then you may want to check out the Database Accelerator tools at
http://www.qdabra.com.

If you are trying to find things in InfoPath then you should look at rules
in the controls not just for code. Most InfoPath functions are done codeless
in the rules engine.
--
Thanks

Clay Fox

Qdabra Software
http://www.qdabra.com

InfoPathDev.Com
The Largest InfoPath Forum in the World
http://www.infopathdev.com
 
B

Bev Kaufman

No, it's not a migration.

And as far as the rules go, I think I've pushed every button in the
properties of the controls looking for clues. There is nothing defined in
the Rules. There are restrictions in Data Validations, mostly to make sure
time is entered in 15 minute intervals and that there's no overlaps, but
there is no event code.
 

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Top