Reply
 
Thread Tools Display Modes
  #1   Report Post  
Posted to microsoft.public.word.docmanagement
dewaaz dewaaz is offline
external usenet poster
 
Posts: 1
Default Forms - Controls to Calculate Totals WITHOUT Using Legacy Controls

Hi

I'd like to use forms in Word 2007 to create some fields where numbers are
typed in, and then another field gets updated at the bottom of the page with
the sum of all the previous numbers.

This can be done in Word 2003, and even in Word 2007 through legacy controls
- fine - but to use legacy controls in 2007, the document must be protected.


In Word 2007, dropdown lists don't require the document to be protected -
great! But Word 2007 doesn't seem to allow fields where numbers are inputted
and a total given elsewhere - it seems like legacy controls must be used. But
then because they are legacy controls, the document needs to be protected.

Is there a way to get numbers in some fields and totals outputted somewhere
using native Word 2007 functionality, and not legacy controls? I ask this
because then I would not need to protect my document. I can do this with
dropdown lists currently, but there doesn't seem to be a way to have the sums
and totals using numbers, unless legacy controls are used.

I amaware of being able to protect portions of a document using section
breaks, but I want to allow editing of a table in which contains controls -
in short, I just want to be able to create a form with no protection - which
can be done with dropdown lists - but I want to have controls for
manipulating numbers WITHOUT having to resort to legacy controls (which
require protection).


Thanks to whoever can help

  #2   Report Post  
Posted to microsoft.public.word.docmanagement
Graham Mayor Graham Mayor is offline
external usenet poster
 
Posts: 19,312
Default Forms - Controls to Calculate Totals WITHOUT Using Legacy Controls

As you have discovered the new Word 2007 controls are somewhat limited. If
you want a more complex form you are going to have to use a protected form -
or you could create as userform to gather your data, perform your
calculations and populate the form For the basics, see Word MVP FAQ -
Userforms
http://word.mvps.org/FAQs/Userforms.htm

for a more in depth explanation, see
http://gregmaxey.mvps.org/Create_and...a_UserForm.htm

--

Graham Mayor - Word MVP

My web site www.gmayor.com
Word MVP web site http://word.mvps.org



dewaaz wrote:
Hi

I'd like to use forms in Word 2007 to create some fields where
numbers are typed in, and then another field gets updated at the
bottom of the page with the sum of all the previous numbers.

This can be done in Word 2003, and even in Word 2007 through legacy
controls - fine - but to use legacy controls in 2007, the document
must be protected.


In Word 2007, dropdown lists don't require the document to be
protected - great! But Word 2007 doesn't seem to allow fields where
numbers are inputted and a total given elsewhere - it seems like
legacy controls must be used. But then because they are legacy
controls, the document needs to be protected.

Is there a way to get numbers in some fields and totals outputted
somewhere using native Word 2007 functionality, and not legacy
controls? I ask this because then I would not need to protect my
document. I can do this with dropdown lists currently, but there
doesn't seem to be a way to have the sums and totals using numbers,
unless legacy controls are used.

I amaware of being able to protect portions of a document using
section breaks, but I want to allow editing of a table in which
contains controls - in short, I just want to be able to create a form
with no protection - which can be done with dropdown lists - but I
want to have controls for manipulating numbers WITHOUT having to
resort to legacy controls (which require protection).


Thanks to whoever can help



  #3   Report Post  
Posted to microsoft.public.word.docmanagement
Michelle Michelle is offline
external usenet poster
 
Posts: 151
Default Forms - Controls to Calculate Totals WITHOUT Using Legacy Cont

Graham - do you know how to do the calculation when you protect your
document? I put in a legacy form field and selected calculation in the
properties section and then wrote =texta-textb what am i doing wrong?

thanks

"Graham Mayor" wrote:

As you have discovered the new Word 2007 controls are somewhat limited. If
you want a more complex form you are going to have to use a protected form -
or you could create as userform to gather your data, perform your
calculations and populate the form For the basics, see Word MVP FAQ -
Userforms
http://word.mvps.org/FAQs/Userforms.htm

for a more in depth explanation, see
http://gregmaxey.mvps.org/Create_and...a_UserForm.htm

--

Graham Mayor - Word MVP

My web site www.gmayor.com
Word MVP web site http://word.mvps.org



dewaaz wrote:
Hi

I'd like to use forms in Word 2007 to create some fields where
numbers are typed in, and then another field gets updated at the
bottom of the page with the sum of all the previous numbers.

This can be done in Word 2003, and even in Word 2007 through legacy
controls - fine - but to use legacy controls in 2007, the document
must be protected.


In Word 2007, dropdown lists don't require the document to be
protected - great! But Word 2007 doesn't seem to allow fields where
numbers are inputted and a total given elsewhere - it seems like
legacy controls must be used. But then because they are legacy
controls, the document needs to be protected.

Is there a way to get numbers in some fields and totals outputted
somewhere using native Word 2007 functionality, and not legacy
controls? I ask this because then I would not need to protect my
document. I can do this with dropdown lists currently, but there
doesn't seem to be a way to have the sums and totals using numbers,
unless legacy controls are used.

I amaware of being able to protect portions of a document using
section breaks, but I want to allow editing of a table in which
contains controls - in short, I just want to be able to create a form
with no protection - which can be done with dropdown lists - but I
want to have controls for manipulating numbers WITHOUT having to
resort to legacy controls (which require protection).


Thanks to whoever can help




  #4   Report Post  
Posted to microsoft.public.word.docmanagement
Graham Mayor Graham Mayor is offline
external usenet poster
 
Posts: 19,312
Default Forms - Controls to Calculate Totals WITHOUT Using Legacy Cont

If you are using legacy form fields then the default field bookmarks names
would be Text1 and Text2 not texta and textb, so the Text3 type would be set
as a calculated field with the calculation =Text1- Text2 and the calculate
on exit check box of Text2 should be checked.

--

Graham Mayor - Word MVP

My web site www.gmayor.com
Word MVP web site http://word.mvps.org




michelle wrote:
Graham - do you know how to do the calculation when you protect your
document? I put in a legacy form field and selected calculation in
the properties section and then wrote =texta-textb what am i doing
wrong?

thanks

"Graham Mayor" wrote:

As you have discovered the new Word 2007 controls are somewhat
limited. If you want a more complex form you are going to have to
use a protected form - or you could create as userform to gather
your data, perform your calculations and populate the form For the
basics, see Word MVP FAQ - Userforms
http://word.mvps.org/FAQs/Userforms.htm

for a more in depth explanation, see
http://gregmaxey.mvps.org/Create_and...a_UserForm.htm

--

Graham Mayor - Word MVP

My web site www.gmayor.com
Word MVP web site http://word.mvps.org



dewaaz wrote:
Hi

I'd like to use forms in Word 2007 to create some fields where
numbers are typed in, and then another field gets updated at the
bottom of the page with the sum of all the previous numbers.

This can be done in Word 2003, and even in Word 2007 through legacy
controls - fine - but to use legacy controls in 2007, the document
must be protected.


In Word 2007, dropdown lists don't require the document to be
protected - great! But Word 2007 doesn't seem to allow fields where
numbers are inputted and a total given elsewhere - it seems like
legacy controls must be used. But then because they are legacy
controls, the document needs to be protected.

Is there a way to get numbers in some fields and totals outputted
somewhere using native Word 2007 functionality, and not legacy
controls? I ask this because then I would not need to protect my
document. I can do this with dropdown lists currently, but there
doesn't seem to be a way to have the sums and totals using numbers,
unless legacy controls are used.

I amaware of being able to protect portions of a document using
section breaks, but I want to allow editing of a table in which
contains controls - in short, I just want to be able to create a
form with no protection - which can be done with dropdown lists -
but I want to have controls for manipulating numbers WITHOUT having
to resort to legacy controls (which require protection).


Thanks to whoever can help



  #5   Report Post  
Posted to microsoft.public.word.docmanagement
Michelle Michelle is offline
external usenet poster
 
Posts: 151
Default Forms - Controls to Calculate Totals WITHOUT Using Legacy Cont

Thanks that 's what i thought, but it doesn't seem to be updating. (sorry i
used a and b as examples, but i was actually using the bookmark names).
m

"Graham Mayor" wrote:

If you are using legacy form fields then the default field bookmarks names
would be Text1 and Text2 not texta and textb, so the Text3 type would be set
as a calculated field with the calculation =Text1- Text2 and the calculate
on exit check box of Text2 should be checked.

--

Graham Mayor - Word MVP

My web site www.gmayor.com
Word MVP web site http://word.mvps.org




michelle wrote:
Graham - do you know how to do the calculation when you protect your
document? I put in a legacy form field and selected calculation in
the properties section and then wrote =texta-textb what am i doing
wrong?

thanks

"Graham Mayor" wrote:

As you have discovered the new Word 2007 controls are somewhat
limited. If you want a more complex form you are going to have to
use a protected form - or you could create as userform to gather
your data, perform your calculations and populate the form For the
basics, see Word MVP FAQ - Userforms
http://word.mvps.org/FAQs/Userforms.htm

for a more in depth explanation, see
http://gregmaxey.mvps.org/Create_and...a_UserForm.htm

--

Graham Mayor - Word MVP

My web site www.gmayor.com
Word MVP web site http://word.mvps.org



dewaaz wrote:
Hi

I'd like to use forms in Word 2007 to create some fields where
numbers are typed in, and then another field gets updated at the
bottom of the page with the sum of all the previous numbers.

This can be done in Word 2003, and even in Word 2007 through legacy
controls - fine - but to use legacy controls in 2007, the document
must be protected.


In Word 2007, dropdown lists don't require the document to be
protected - great! But Word 2007 doesn't seem to allow fields where
numbers are inputted and a total given elsewhere - it seems like
legacy controls must be used. But then because they are legacy
controls, the document needs to be protected.

Is there a way to get numbers in some fields and totals outputted
somewhere using native Word 2007 functionality, and not legacy
controls? I ask this because then I would not need to protect my
document. I can do this with dropdown lists currently, but there
doesn't seem to be a way to have the sums and totals using numbers,
unless legacy controls are used.

I amaware of being able to protect portions of a document using
section breaks, but I want to allow editing of a table in which
contains controls - in short, I just want to be able to create a
form with no protection - which can be done with dropdown lists -
but I want to have controls for manipulating numbers WITHOUT having
to resort to legacy controls (which require protection).


Thanks to whoever can help






  #6   Report Post  
Posted to microsoft.public.word.docmanagement
Michelle Michelle is offline
external usenet poster
 
Posts: 151
Default Forms - Controls to Calculate Totals WITHOUT Using Legacy Cont

do i need to select something on the "run macro on"?

"Graham Mayor" wrote:

If you are using legacy form fields then the default field bookmarks names
would be Text1 and Text2 not texta and textb, so the Text3 type would be set
as a calculated field with the calculation =Text1- Text2 and the calculate
on exit check box of Text2 should be checked.

--

Graham Mayor - Word MVP

My web site www.gmayor.com
Word MVP web site http://word.mvps.org




michelle wrote:
Graham - do you know how to do the calculation when you protect your
document? I put in a legacy form field and selected calculation in
the properties section and then wrote =texta-textb what am i doing
wrong?

thanks

"Graham Mayor" wrote:

As you have discovered the new Word 2007 controls are somewhat
limited. If you want a more complex form you are going to have to
use a protected form - or you could create as userform to gather
your data, perform your calculations and populate the form For the
basics, see Word MVP FAQ - Userforms
http://word.mvps.org/FAQs/Userforms.htm

for a more in depth explanation, see
http://gregmaxey.mvps.org/Create_and...a_UserForm.htm

--

Graham Mayor - Word MVP

My web site www.gmayor.com
Word MVP web site http://word.mvps.org



dewaaz wrote:
Hi

I'd like to use forms in Word 2007 to create some fields where
numbers are typed in, and then another field gets updated at the
bottom of the page with the sum of all the previous numbers.

This can be done in Word 2003, and even in Word 2007 through legacy
controls - fine - but to use legacy controls in 2007, the document
must be protected.


In Word 2007, dropdown lists don't require the document to be
protected - great! But Word 2007 doesn't seem to allow fields where
numbers are inputted and a total given elsewhere - it seems like
legacy controls must be used. But then because they are legacy
controls, the document needs to be protected.

Is there a way to get numbers in some fields and totals outputted
somewhere using native Word 2007 functionality, and not legacy
controls? I ask this because then I would not need to protect my
document. I can do this with dropdown lists currently, but there
doesn't seem to be a way to have the sums and totals using numbers,
unless legacy controls are used.

I amaware of being able to protect portions of a document using
section breaks, but I want to allow editing of a table in which
contains controls - in short, I just want to be able to create a
form with no protection - which can be done with dropdown lists -
but I want to have controls for manipulating numbers WITHOUT having
to resort to legacy controls (which require protection).


Thanks to whoever can help




  #7   Report Post  
Posted to microsoft.public.word.docmanagement
Graham Mayor Graham Mayor is offline
external usenet poster
 
Posts: 19,312
Default Forms - Controls to Calculate Totals WITHOUT Using Legacy Cont

You only need to run an update macro on exit if you are using REF fields on
the header footer.
Instead of the calculated form field, unlock the form. Press CTRL+F9 to give
you {}
Between the brackets type = then CTRL+F9 then - (space minus space) then
CTRL+F9
In between the two other pairs of brackets type the bookmark names of the
two fields you wish to subtract thus

{={Text1} - {Text2}}

Relock the form. The field will probably show an error until you enter
something in Text1 and Text2, which is why a calculated form field would be
better here.


--

Graham Mayor - Word MVP

My web site www.gmayor.com
Word MVP web site http://word.mvps.org



michelle wrote:
do i need to select something on the "run macro on"?

"Graham Mayor" wrote:

If you are using legacy form fields then the default field bookmarks
names would be Text1 and Text2 not texta and textb, so the Text3
type would be set as a calculated field with the calculation =Text1-
Text2 and the calculate on exit check box of Text2 should be checked.

--

Graham Mayor - Word MVP

My web site www.gmayor.com
Word MVP web site http://word.mvps.org




michelle wrote:
Graham - do you know how to do the calculation when you protect your
document? I put in a legacy form field and selected calculation in
the properties section and then wrote =texta-textb what am i doing
wrong?

thanks

"Graham Mayor" wrote:

As you have discovered the new Word 2007 controls are somewhat
limited. If you want a more complex form you are going to have to
use a protected form - or you could create as userform to gather
your data, perform your calculations and populate the form For the
basics, see Word MVP FAQ - Userforms
http://word.mvps.org/FAQs/Userforms.htm

for a more in depth explanation, see
http://gregmaxey.mvps.org/Create_and...a_UserForm.htm

--

Graham Mayor - Word MVP

My web site www.gmayor.com
Word MVP web site http://word.mvps.org



dewaaz wrote:
Hi

I'd like to use forms in Word 2007 to create some fields where
numbers are typed in, and then another field gets updated at the
bottom of the page with the sum of all the previous numbers.

This can be done in Word 2003, and even in Word 2007 through
legacy controls - fine - but to use legacy controls in 2007, the
document must be protected.


In Word 2007, dropdown lists don't require the document to be
protected - great! But Word 2007 doesn't seem to allow fields
where numbers are inputted and a total given elsewhere - it seems
like legacy controls must be used. But then because they are
legacy controls, the document needs to be protected.

Is there a way to get numbers in some fields and totals outputted
somewhere using native Word 2007 functionality, and not legacy
controls? I ask this because then I would not need to protect my
document. I can do this with dropdown lists currently, but there
doesn't seem to be a way to have the sums and totals using
numbers, unless legacy controls are used.

I amaware of being able to protect portions of a document using
section breaks, but I want to allow editing of a table in which
contains controls - in short, I just want to be able to create a
form with no protection - which can be done with dropdown lists -
but I want to have controls for manipulating numbers WITHOUT
having to resort to legacy controls (which require protection).


Thanks to whoever can help



Reply
Thread Tools
Display Modes

Posting Rules

Smilies are On
[IMG] code is On
HTML code is Off

Forum Jump

Similar Threads
Thread Thread Starter Forum Replies Last Post
Formatting Legacy Controls P. Zicari Microsoft Word Help 1 September 15th 08 09:54 AM
legacy tools or content controls? tom forel Microsoft Word Help 4 January 10th 08 05:00 PM
legacy controls in word 2007 tom Microsoft Word Help 1 April 7th 07 02:02 PM
Content and legacy controls Linda Microsoft Word Help 4 March 29th 07 04:28 PM
forms with active controls ABK Microsoft Word Help 1 July 14th 06 04:51 AM


All times are GMT +1. The time now is 02:56 PM.

Copyright ©2000 - 2024, Jelsoft Enterprises Ltd.
Copyright ©2004-2024 Microsoft Office Word Forum - WordBanter.
The comments are property of their posters.
 

About Us

"It's about Microsoft Word"