 |
 | Home | Contact Us | FAQ | Search & Site Map | Link to Us |
 | Sign In | Join | Other 45 Sites in Network |
| HomeDiscussionsAccessExcelInfoPathOutlookPowerPointPublisherWordDirectoryUser Groups Related Topics Outlook ExpressInternet ExplorerWindowsMS Server ProductsMore Topics ... |
MS Office Forum / Outlook / Programming Forms / March 2008Doing math in contact forms
I have a contact form that contains various financial data about my customers. Is there a way to set up a field to contain the total of, say, the husband's income and the wife's income? Both incomes are separately entered as currency and I would like to see a total calculated automatically. Thanks, Walter Use a field with a formula like: [His Income] + [Her Income]  SignatureSue Mosher, Outlook MVP Author of Microsoft Outlook 2007 Programming: Jumpstart for Power Users and Administrators http://www.outlookcode.com/article.aspx?id=54 >I have a contact form that contains various financial data about my > customers. Is there a way to set up a field to contain the total of, say, the [quoted text clipped - 4 lines] > > Walter Thanks, Sue ... worked like a charm. A follow up please: I am trying to calculate the monthly principal and interest payment given inputs of the loan amount, the loan term and the interest rate. The financial functions include one as follows: pmt(rate, nper, pv, fv, due) Since only the first three variables are needed to calculate the amortizing monthly payment, what do I do with the last 2 variables? I have tried setting them to zero in the formula and this did not work. Thanks, Walter > Use a field with a formula like: > [quoted text clipped - 8 lines] > > > > Walter Have you tried just omitting them? Values of 0 should also work. If they don't, maybe the problem is with one of the other terms. SignatureSue Mosher, Outlook MVP Author of Microsoft Outlook 2007 Programming: Jumpstart for Power Users and Administrators http://www.outlookcode.com/article.aspx?id=54 > Thanks, Sue ... worked like a charm. > [quoted text clipped - 18 lines] >> >> [His Income] + [Her Income] >> >I have a contact form that contains various financial data about my >> > customers. Is there a way to set up a field to contain the total of, say, the [quoted text clipped - 4 lines] >> > >> > Walter Thanks Sue ... got it working. I followed the instructions and published the form (after first creating an additional contacts folder in which this form will be applicable). How can I use this form in the main Contacts folder? Walter > Have you tried just omitting them? Values of 0 should also work. If they don't, maybe the problem is with one of the other terms. > [quoted text clipped - 29 lines] > >> > > >> > Walter EIther publish it to the main Contacts folder or to your Personal Forms library. SignatureSue Mosher, Outlook MVP Author of Microsoft Outlook 2007 Programming: Jumpstart for Power Users and Administrators http://www.outlookcode.com/article.aspx?id=54 > Thanks Sue ... got it working. > [quoted text clipped - 38 lines] >> >> > >> >> > Walter yes, I did that and when I open a new contact form the new tab is there, as expected. However, when I open an existing contact the new tab is still missing. Walter > EIther publish it to the main Contacts folder or to your Personal Forms library. > [quoted text clipped - 40 lines] > >> >> > > >> >> > Walter To change existing items so that they display using a published custom message form, you need to change the value of the MessageClass property on each item so that it points to the published form's class, e.g. IPM.Contact.MyForm. The page at http://www.outlookcode.com/article.aspx?id=39 has links to scripts and tools to do this. SignatureSue Mosher, Outlook MVP Author of Microsoft Outlook 2007 Programming: Jumpstart for Power Users and Administrators http://www.outlookcode.com/article.aspx?id=54 > yes, I did that and when I open a new contact form the new tab is there, as > expected. However, when I open an existing contact the new tab is still [quoted text clipped - 46 lines] >> >> >> > >> >> >> > Walter
|
Reply to this Message |
 Sign In
 Join
 My Latest Posts My Monitored Threads My Blog My Photo Gallery My Profile My Homepage Start New Thread Enable EMail Alerts Rate this Thread
|
©2008 Advenet LLC Privacy Policy - Terms of Use
This website includes both content owned or controlled by Advenet as well as content owned or controlled by third parties.