Reply
 
Thread Tools Display Modes
  #1   Report Post  
GenesisBlade
 
Posts: n/a
Default refreshing / updating fields

I have created a form, with numerous fields that are set to autopopulate a
grid at the end. The functionality works, but I need the form to update as it
goes, rather than only be triggered when i print it.

Any trick will do.

I've got as far as adding the 'update fields' icon to the menu bars at the
top (customise menu) and then can select all (ctrl-A) and press the button
and hey presto... but that will be too technical for my users... can i set a
macro to a key, to activate the 'update fields' option? If so, how?!

Many thanks, in advance
  #2   Report Post  
GenesisBlade
 
Posts: n/a
Default

further to my question, i have found a temporary messy solution... i could do
with a better one, if someone knows, however.

having already added the 'update field' icon to my menu, i select 'record a
macro', select all (ctrl-A), and press the 'update field' icon. End macro.

so i have a new maco... but is there a better, prettier way?

"GenesisBlade" wrote:

I have created a form, with numerous fields that are set to autopopulate a
grid at the end. The functionality works, but I need the form to update as it
goes, rather than only be triggered when i print it.

Any trick will do.

I've got as far as adding the 'update fields' icon to the menu bars at the
top (customise menu) and then can select all (ctrl-A) and press the button
and hey presto... but that will be too technical for my users... can i set a
macro to a key, to activate the 'update fields' option? If so, how?!

Many thanks, in advance

  #3   Report Post  
GenesisBlade
 
Posts: n/a
Default

nothing like posting to one's self is there... a tidier way might be like the
following:

since the F9 key is does the 'update field' task, you can simply go ctrl-A,
followed by F9.

No need for a macro... anything better?

"GenesisBlade" wrote:

further to my question, i have found a temporary messy solution... i could do
with a better one, if someone knows, however.

having already added the 'update field' icon to my menu, i select 'record a
macro', select all (ctrl-A), and press the 'update field' icon. End macro.

so i have a new maco... but is there a better, prettier way?

"GenesisBlade" wrote:

I have created a form, with numerous fields that are set to autopopulate a
grid at the end. The functionality works, but I need the form to update as it
goes, rather than only be triggered when i print it.

Any trick will do.

I've got as far as adding the 'update fields' icon to the menu bars at the
top (customise menu) and then can select all (ctrl-A) and press the button
and hey presto... but that will be too technical for my users... can i set a
macro to a key, to activate the 'update fields' option? If so, how?!

Many thanks, in advance

  #4   Report Post  
Graham Mayor
 
Posts: n/a
Default

If this is a locked form and the contents of the field are inserted using a
REF field and that REF field is not in a header/footer then simply check the
field property 'calculate on exit' and the REF fields will be automatically
update.

If you need to force and update eg because the REF field is in a header,
then run an update macro on exit from the relevant field - you'll find
suitable code at http://www.gmayor.com/installing_macro.htm

--

Graham Mayor - Word MVP

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



GenesisBlade wrote:
nothing like posting to one's self is there... a tidier way might be
like the following:

since the F9 key is does the 'update field' task, you can simply go
ctrl-A, followed by F9.

No need for a macro... anything better?

"GenesisBlade" wrote:

further to my question, i have found a temporary messy solution... i
could do with a better one, if someone knows, however.

having already added the 'update field' icon to my menu, i select
'record a macro', select all (ctrl-A), and press the 'update field'
icon. End macro.

so i have a new maco... but is there a better, prettier way?

"GenesisBlade" wrote:

I have created a form, with numerous fields that are set to
autopopulate a grid at the end. The functionality works, but I need
the form to update as it goes, rather than only be triggered when i
print it.

Any trick will do.

I've got as far as adding the 'update fields' icon to the menu bars
at the top (customise menu) and then can select all (ctrl-A) and
press the button and hey presto... but that will be too technical
for my users... can i set a macro to a key, to activate the 'update
fields' option? If so, how?!

Many thanks, in advance



  #5   Report Post  
Flip
 
Posts: n/a
Default

Hi,
I have added the CDEV toolbar
http://www.cdev.co.uk/utils.htm
It has an icon to update all fields (in headers and footers also). I copied
it from the CDEV toolbar to the Format bar so no need to always keep the
CDEV on screen.
Flip




I have created a form, with numerous fields that are set to autopopulate a
grid at the end. The functionality works, but I need the form to update as

it
goes, rather than only be triggered when i print it.

Any trick will do.

I've got as far as adding the 'update fields' icon to the menu bars at the
top (customise menu) and then can select all (ctrl-A) and press the button
and hey presto... but that will be too technical for my users... can i set

a
macro to a key, to activate the 'update fields' option? If so, how?!

Many thanks, in advance



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
On a form in Word, the text in the fields comes out red, and a bo. MissMaia Microsoft Word Help 1 November 26th 04 10:54 AM
Why do my pageref fields get all messed up? TrueBlue Microsoft Word Help 1 November 26th 04 09:56 AM
posting data from text input fields to fields later in document BOB Microsoft Word Help 1 November 23rd 04 06:19 PM


All times are GMT +1. The time now is 11:09 PM.

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

About Us

"It's about Microsoft Word"