I have a custom meeting form that has a custom field called "score" in it
which accepts a number. I would like to be able to click a button on my
custom form which will cycle through all of my custom forms in the calendar
folder and display a sum of field called "score"
Generally speaking, if you are talking about your problem wrong, you are
perceiving the problem wrong.
First, though you may have several custom forms, you are really just talking
about one custom form, and many data items which use that form to display
their data on the monitor. So, you are not summing a field in a bunch of
forms, but summing a data field in the data items in a specific folder. And
not all data items in that folder, but only those items in the folder that
have a the MessageID field set to the string value of the name of the
specific form that defines the desired collection. Once you have identified
the item as being in the filter, then you find the field object whose name
value is "score", and take the objects number value and add it to a tally
field you have defined in your code. Then you delete your field object, and
your item object and go on to the next item object.
Do you know enough about Outlook's VBScript coding to do a flow diagram of
all this? If yes, they you should be able to find a code example on
www.slipstick.com or
www.outlookcode.com.
Hollis D. Paul [MVP - Outlook]
(e-mail address removed)
Using Virtual Access 4.52 build 277 (32-bit), Windows 2000 build 2600
http://search.support.microsoft.com/kb/c.asp?FR=0&SD=TECH&LN=EN-US
Mukilteo, WA USA
