Calculations problem
in [Word VBA]
|
From: mariel9898 on 23 Feb 2010 12:45 Thanks but I got this error: Error! Too many picture switches defined "Peter Jamieson" wrote: > The nearest you'll get is probably to nest both codes inside a { QUOTE } > field, e.g. > > { QUOTE {=INT(PRODUCT(LEFT)) \# $,0}{=MOD(PRODUCT(LEFT),1) \# .00;;} } > > > Something super easy for the real basic user? > > Of course that's what we'd all like but "Word fields" and "super easy" > is a rare mix IME. > > Peter Jamieson > > http://tips.pjmsn.me.uk > > On 22/02/2010 23:09, mariel9898 wrote: > > Thank you, that worked but it won't be much use to me. That involves two > > field codes, one of which is "invisble" (for lack of a better term). My end > > users can barely deal with one field code. > > > > Is there anything that can do this with one code that can be right clicked > > and updated. Something super easy for the real basic user? > > > > > > "macropod" wrote: > > > >> Oops! The formulae should be: > >> {=INT(PRODUCT(LEFT)) \# $,0}{=MOD(PRODUCT(LEFT),1) \# .00;;} > >> (note the change to the second formula). > >> > >> -- > >> Cheers > >> macropod > >> [Microsoft MVP - Word] > . >
From: mariel9898 on 23 Feb 2010 12:47 Can you tell me where this 'calculate on exit' formfield property is found? Also, I'm not sure that would work because the users need to see the actual calculation and make sure it's correct. They can't just exit and assume everything is right. "macropod" wrote: > Hi Marie, > > If the values in columns A & B are being input into text formfields, there's no need for anyone to concern themselves with selecting > the fields to update - checking the 'calculate on exit' formfield property will be enough. > > -- > Cheers > macropod > [Microsoft MVP - Word] > > > "mariel9898" <mariel9898(a)discussions.microsoft.com> wrote in message news:2683D431-5D9D-4C1A-8E22-E030001722D7(a)microsoft.com... > > Thank you, that worked but it won't be much use to me. That involves two > > field codes, one of which is "invisble" (for lack of a better term). My end > > users can barely deal with one field code. > > > > Is there anything that can do this with one code that can be right clicked > > and updated. Something super easy for the real basic user? > > > > > > "macropod" wrote: > > > >> Oops! The formulae should be: > >> {=INT(PRODUCT(LEFT)) \# $,0}{=MOD(PRODUCT(LEFT),1) \# .00;;} > >> (note the change to the second formula). > >> > >> -- > >> Cheers > >> macropod > >> [Microsoft MVP - Word] > > . >
From: macropod on 23 Feb 2010 16:01 Hi Marie, Assuming you're using formfields, simply select one of them, right-click on it with the mouse, choose 'Properties' and a pop-up will display showing various options, one of which is 'calculate on exit'. As for your users being able to "see the actual calculation and make sure it's correct", I take it you're referring to being able to see the result. They'll be able to see that as soon as they tab out of the formfield. If you mean you want them to be able to check the underlying calculation, that won't be possible; in any event, your earlier statement that "My end users can barely deal with one field code" suggests they really wouldn't be able to understand what they were looking at anyway if the field code was visible. -- Cheers macropod [Microsoft MVP - Word] "mariel9898" <mariel9898(a)discussions.microsoft.com> wrote in message news:DEEB0510-F186-4A90-9904-9F6C0D7124F8(a)microsoft.com... > Can you tell me where this 'calculate on exit' formfield property is found? > > Also, I'm not sure that would work because the users need to see the actual > calculation and make sure it's correct. They can't just exit and assume > everything is right. > > "macropod" wrote: > >> Hi Marie, >> >> If the values in columns A & B are being input into text formfields, there's no need for anyone to concern themselves with >> selecting >> the fields to update - checking the 'calculate on exit' formfield property will be enough. >> >> -- >> Cheers >> macropod >> [Microsoft MVP - Word] >> >> >> "mariel9898" <mariel9898(a)discussions.microsoft.com> wrote in message news:2683D431-5D9D-4C1A-8E22-E030001722D7(a)microsoft.com... >> > Thank you, that worked but it won't be much use to me. That involves two >> > field codes, one of which is "invisble" (for lack of a better term). My end >> > users can barely deal with one field code. >> > >> > Is there anything that can do this with one code that can be right clicked >> > and updated. Something super easy for the real basic user? >> > >> > >> > "macropod" wrote: >> > >> >> Oops! The formulae should be: >> >> {=INT(PRODUCT(LEFT)) \# $,0}{=MOD(PRODUCT(LEFT),1) \# .00;;} >> >> (note the change to the second formula). >> >> >> >> -- >> >> Cheers >> >> macropod >> >> [Microsoft MVP - Word] >> >> . >>
From: mariel9898 on 23 Feb 2010 17:07 I guess I'm not using a formfield because when I right click there is no Properties option. The template is not a form. I just have calculated fields in a table. The field code does not need to be visible - just the end calculation. What I mean is that the end user should just be able to change the numbers as necessary then right click on the field to update it. "macropod" wrote: > Hi Marie, > > Assuming you're using formfields, simply select one of them, right-click on it with the mouse, choose 'Properties' and a pop-up will > display showing various options, one of which is 'calculate on exit'. > > As for your users being able to "see the actual calculation and make sure it's correct", I take it you're referring to being able to > see the result. They'll be able to see that as soon as they tab out of the formfield. If you mean you want them to be able to check > the underlying calculation, that won't be possible; in any event, your earlier statement that "My end users can barely deal with one > field code" suggests they really wouldn't be able to understand what they were looking at anyway if the field code was visible. > > > -- > Cheers > macropod > [Microsoft MVP - Word]
From: Peter Jamieson on 23 Feb 2010 17:51 It works fine here. Are all the {} the field brace pairs that you can insert using ctrl-F9? I am assuming that your default thousands separator is "," and your decimal separator is "." FWIW if you need to deal with negative numbers you need the format switch I originally suggested, i.e. { QUOTE {=INT(PRODUCT(LEFT)) \# $,0}{=MOD(PRODUCT(LEFT),1) \# .00;.00;} } to cope with the Peter Jamieson http://tips.pjmsn.me.uk On 23/02/2010 17:45, mariel9898 wrote: >{ QUOTE {=INT(PRODUCT(LEFT)) \# $,0}{=MOD(PRODUCT(LEFT),1) \# .00;;} }
First
|
Prev
|
Next
|
Last
Pages: 1 2 3 4 Prev: problem in changing part of a sentence Next: Word Templates of the Same Name Problem |