Reply
 
Thread Tools Display Modes
  #1   Report Post  
Posted to microsoft.public.word.docmanagement
piersonal piersonal is offline
external usenet poster
 
Posts: 9
Default Trying to automate data entry in word

I am trying to assemble a template doc so that when a new document is created
the user types in just the once the customer name and for the document to
then populate the various places that this information is needed. So
bookmarks seemed to be the answer, but once entered, I don't want the user to
be prompted for it again as it does with ask and fillin fields. Hope I am
missing something here!!!

One idea I had was to have a non printing page at the beginning containing a
list of variables such as name, customer, version number, date etc so that
these could be referenced to around the document. Is this possible??? Not a
big VB man, so hoping it doesn't come to that!!!
  #2   Report Post  
Posted to microsoft.public.word.docmanagement
Matt L in Raleigh Matt L in Raleigh is offline
external usenet poster
 
Posts: 1
Default Trying to automate data entry in word

I do it with bookmarks. Also enable ToolsOptionsViewBookmarks

"piersonal" wrote:

I am trying to assemble a template doc so that when a new document is created
the user types in just the once the customer name and for the document to
then populate the various places that this information is needed. So
bookmarks seemed to be the answer, but once entered, I don't want the user to
be prompted for it again as it does with ask and fillin fields. Hope I am
missing something here!!!

One idea I had was to have a non printing page at the beginning containing a
list of variables such as name, customer, version number, date etc so that
these could be referenced to around the document. Is this possible??? Not a
big VB man, so hoping it doesn't come to that!!!

  #3   Report Post  
Posted to microsoft.public.word.docmanagement
piersonal piersonal is offline
external usenet poster
 
Posts: 9
Default Trying to automate data entry in word

Thanks for your reply Matt - I have got as far as using bookmarks and indeed
found that the ask and fillin fields work well in general, but they kick off
everytime the fields are refreshed and I wanted a way of only doing it the
first time / when its manually activated - does this make sense??

"Matt L in Raleigh" wrote:

I do it with bookmarks. Also enable ToolsOptionsViewBookmarks

"piersonal" wrote:

I am trying to assemble a template doc so that when a new document is created
the user types in just the once the customer name and for the document to
then populate the various places that this information is needed. So
bookmarks seemed to be the answer, but once entered, I don't want the user to
be prompted for it again as it does with ask and fillin fields. Hope I am
missing something here!!!

One idea I had was to have a non printing page at the beginning containing a
list of variables such as name, customer, version number, date etc so that
these could be referenced to around the document. Is this possible??? Not a
big VB man, so hoping it doesn't come to that!!!

  #4   Report Post  
Posted to microsoft.public.word.docmanagement
Ed Ed is offline
external usenet poster
 
Posts: 27
Default Trying to automate data entry in word

Depending on what you're thinking of with the first time field
activation, you might try something like using one ASK field and
several REF fields. For instance,
{ASK CustName "What name?"}
With that ASK field, you have now created and populated the variable
CustName.
{REF CustName}
will show that variable value.

The first ASK field will still pop up and ask for the value at every
refresh, but that will be the only box to pop up - for that variable,
that is - if you have several variables each having their own ASK
fields, they will all open up on refresh.

If that's too much, then maybe you do need an AutoNew or AutoOpen
macro that will create and populate Custom Document Variables, which
can be referred to in your document using DocVariable fields.

HTH
Ed


On Jun 21, 7:03 am, piersonal
wrote:
Thanks for your reply Matt - I have got as far as using bookmarks and indeed
found that the ask and fillin fields work well in general, but they kick off
everytime the fields are refreshed and I wanted a way of only doing it the
first time / when its manually activated - does this make sense??

"Matt L in Raleigh" wrote:



I do it with bookmarks. Also enable ToolsOptionsViewBookmarks


"piersonal" wrote:


I am trying to assemble a template doc so that when a new document is created
the user types in just the once the customer name and for the document to
then populate the various places that this information is needed. So
bookmarks seemed to be the answer, but once entered, I don't want the user to
be prompted for it again as it does with ask and fillin fields. Hope I am
missing something here!!!


One idea I had was to have a non printing page at the beginning containing a
list of variables such as name, customer, version number, date etc so that
these could be referenced to around the document. Is this possible??? Not a
big VB man, so hoping it doesn't come to that!!!- Hide quoted text -


- Show quoted text -



  #5   Report Post  
Posted to microsoft.public.word.docmanagement
Peter Jamieson Peter Jamieson is offline
external usenet poster
 
Posts: 4,582
Default Trying to automate data entry in word

One thing you can consider is to use ASK fields only and put them all at the
beginning, nested inside an IF field:

{ IF firsttime = 1 "{ ASK bookmarka "prompt..." }{ ASK bookmarkb
"prompt..." }etc." }{ SET firsttime 0 }

But before you save the doc, change that final 0 to 1, execute the SET
field, then change the value back to 0

When the user opens the document, they have to know to do ctrl-A then F9.
The ASK fields should execute and all REFs (In the main body of the
document) that refer to their bookmarks should then be updated. firsttime is
set to 0 so the nect time the user does ctrl-A, F9, no ASK fields are
executed.

To re-execute the ASKs the user would either have to know how to modify that
firsttime value again, then do ctrl-A, F9

I've never actually done it that way (I think it's better to use a userform
to set either bookmarks, document variables, or document properties) and it
requires more user knowledge than I'd prefer to rely on, but it doesn't need
any macros and is perhaps worth a try.

Peter Jamieson
"piersonal" wrote in message
...
I am trying to assemble a template doc so that when a new document is
created
the user types in just the once the customer name and for the document to
then populate the various places that this information is needed. So
bookmarks seemed to be the answer, but once entered, I don't want the user
to
be prompted for it again as it does with ask and fillin fields. Hope I am
missing something here!!!

One idea I had was to have a non printing page at the beginning containing
a
list of variables such as name, customer, version number, date etc so that
these could be referenced to around the document. Is this possible??? Not
a
big VB man, so hoping it doesn't come to that!!!




  #6   Report Post  
Posted to microsoft.public.word.docmanagement
piersonal piersonal is offline
external usenet poster
 
Posts: 9
Default Trying to automate data entry in word

excellent Ed thank you - yes I didn't think to use AutoNew - this way I can
run the ask process once at the start for all the different variables needed
and the relevant fields will get populated as a result, without the user
being asked this every time they refresh the fields.

Thanks very much

What do you think though of the idea of a kind of variable table at the
start of the document? Might be good for the user to see a summary of what
the document is about, but not sure how to link this info to the ref fields
in the document ... maybe use the AutoNew trick and do a summary of the
answers at the beginning with a button to rerun the AutoNew process if
required?

"Ed" wrote:

Depending on what you're thinking of with the first time field
activation, you might try something like using one ASK field and
several REF fields. For instance,
{ASK CustName "What name?"}
With that ASK field, you have now created and populated the variable
CustName.
{REF CustName}
will show that variable value.

The first ASK field will still pop up and ask for the value at every
refresh, but that will be the only box to pop up - for that variable,
that is - if you have several variables each having their own ASK
fields, they will all open up on refresh.

If that's too much, then maybe you do need an AutoNew or AutoOpen
macro that will create and populate Custom Document Variables, which
can be referred to in your document using DocVariable fields.

HTH
Ed


On Jun 21, 7:03 am, piersonal
wrote:
Thanks for your reply Matt - I have got as far as using bookmarks and indeed
found that the ask and fillin fields work well in general, but they kick off
everytime the fields are refreshed and I wanted a way of only doing it the
first time / when its manually activated - does this make sense??

"Matt L in Raleigh" wrote:



I do it with bookmarks. Also enable ToolsOptionsViewBookmarks


"piersonal" wrote:


I am trying to assemble a template doc so that when a new document is created
the user types in just the once the customer name and for the document to
then populate the various places that this information is needed. So
bookmarks seemed to be the answer, but once entered, I don't want the user to
be prompted for it again as it does with ask and fillin fields. Hope I am
missing something here!!!


One idea I had was to have a non printing page at the beginning containing a
list of variables such as name, customer, version number, date etc so that
these could be referenced to around the document. Is this possible??? Not a
big VB man, so hoping it doesn't come to that!!!- Hide quoted text -


- Show quoted text -




  #7   Report Post  
Posted to microsoft.public.word.docmanagement
piersonal piersonal is offline
external usenet poster
 
Posts: 9
Default Trying to automate data entry in word

Very good idea this, thank you very much Peter. I also like the sound of the
userform you mentioned; is this a VB thing as I have not heard of this ...
but it sounds like it might be exactly what I was after ...

"Peter Jamieson" wrote:

One thing you can consider is to use ASK fields only and put them all at the
beginning, nested inside an IF field:

{ IF firsttime = 1 "{ ASK bookmarka "prompt..." }{ ASK bookmarkb
"prompt..." }etc." }{ SET firsttime 0 }

But before you save the doc, change that final 0 to 1, execute the SET
field, then change the value back to 0

When the user opens the document, they have to know to do ctrl-A then F9.
The ASK fields should execute and all REFs (In the main body of the
document) that refer to their bookmarks should then be updated. firsttime is
set to 0 so the nect time the user does ctrl-A, F9, no ASK fields are
executed.

To re-execute the ASKs the user would either have to know how to modify that
firsttime value again, then do ctrl-A, F9

I've never actually done it that way (I think it's better to use a userform
to set either bookmarks, document variables, or document properties) and it
requires more user knowledge than I'd prefer to rely on, but it doesn't need
any macros and is perhaps worth a try.

Peter Jamieson
"piersonal" wrote in message
...
I am trying to assemble a template doc so that when a new document is
created
the user types in just the once the customer name and for the document to
then populate the various places that this information is needed. So
bookmarks seemed to be the answer, but once entered, I don't want the user
to
be prompted for it again as it does with ask and fillin fields. Hope I am
missing something here!!!

One idea I had was to have a non printing page at the beginning containing
a
list of variables such as name, customer, version number, date etc so that
these could be referenced to around the document. Is this possible??? Not
a
big VB man, so hoping it doesn't come to that!!!



  #8   Report Post  
Posted to microsoft.public.word.docmanagement
Peter Jamieson Peter Jamieson is offline
external usenet poster
 
Posts: 4,582
Default Trying to automate data entry in word

Yes, it's VBA, userforms look like regular Windows dialog boxes, and you
will find there's quite a bit of effort involved. But if you don't have any
difficulty using macros in your organisation, it's probably the approach
that will give you most control.

Peter Jamieson
"piersonal" wrote in message
...
Very good idea this, thank you very much Peter. I also like the sound of
the
userform you mentioned; is this a VB thing as I have not heard of this ...
but it sounds like it might be exactly what I was after ...

"Peter Jamieson" wrote:

One thing you can consider is to use ASK fields only and put them all at
the
beginning, nested inside an IF field:

{ IF firsttime = 1 "{ ASK bookmarka "prompt..." }{ ASK bookmarkb
"prompt..." }etc." }{ SET firsttime 0 }

But before you save the doc, change that final 0 to 1, execute the SET
field, then change the value back to 0

When the user opens the document, they have to know to do ctrl-A then F9.
The ASK fields should execute and all REFs (In the main body of the
document) that refer to their bookmarks should then be updated. firsttime
is
set to 0 so the nect time the user does ctrl-A, F9, no ASK fields are
executed.

To re-execute the ASKs the user would either have to know how to modify
that
firsttime value again, then do ctrl-A, F9

I've never actually done it that way (I think it's better to use a
userform
to set either bookmarks, document variables, or document properties) and
it
requires more user knowledge than I'd prefer to rely on, but it doesn't
need
any macros and is perhaps worth a try.

Peter Jamieson
"piersonal" wrote in message
...
I am trying to assemble a template doc so that when a new document is
created
the user types in just the once the customer name and for the document
to
then populate the various places that this information is needed. So
bookmarks seemed to be the answer, but once entered, I don't want the
user
to
be prompted for it again as it does with ask and fillin fields. Hope I
am
missing something here!!!

One idea I had was to have a non printing page at the beginning
containing
a
list of variables such as name, customer, version number, date etc so
that
these could be referenced to around the document. Is this possible???
Not
a
big VB man, so hoping it doesn't come to that!!!




  #9   Report Post  
Posted to microsoft.public.word.docmanagement
Suzanne S. Barnhill Suzanne S. Barnhill is offline
external usenet poster
 
Posts: 33,624
Default Trying to automate data entry in word

A UserForm is perhaps the best approach (see
http://word.mvps.org/FAQs/Userforms/CreateAUserForm.htm for a start), but
see also http://gregmaxey.mvps.org/Repeating_Data.htm.

--
Suzanne S. Barnhill
Microsoft MVP (Word)
Words into Type
Fairhope, Alabama USA
Word MVP FAQ site: http://word.mvps.org
Email cannot be acknowledged; please post all follow-ups to the newsgroup so
all may benefit.

"piersonal" wrote in message
...
I am trying to assemble a template doc so that when a new document is

created
the user types in just the once the customer name and for the document to
then populate the various places that this information is needed. So
bookmarks seemed to be the answer, but once entered, I don't want the user

to
be prompted for it again as it does with ask and fillin fields. Hope I am
missing something here!!!

One idea I had was to have a non printing page at the beginning containing

a
list of variables such as name, customer, version number, date etc so that
these could be referenced to around the document. Is this possible??? Not

a
big VB man, so hoping it doesn't come to that!!!


  #10   Report Post  
Posted to microsoft.public.word.docmanagement
piersonal piersonal is offline
external usenet poster
 
Posts: 9
Default Trying to automate data entry in word

Many thanks Peter

"Peter Jamieson" wrote:

Yes, it's VBA, userforms look like regular Windows dialog boxes, and you
will find there's quite a bit of effort involved. But if you don't have any
difficulty using macros in your organisation, it's probably the approach
that will give you most control.

Peter Jamieson
"piersonal" wrote in message
...
Very good idea this, thank you very much Peter. I also like the sound of
the
userform you mentioned; is this a VB thing as I have not heard of this ...
but it sounds like it might be exactly what I was after ...

"Peter Jamieson" wrote:

One thing you can consider is to use ASK fields only and put them all at
the
beginning, nested inside an IF field:

{ IF firsttime = 1 "{ ASK bookmarka "prompt..." }{ ASK bookmarkb
"prompt..." }etc." }{ SET firsttime 0 }

But before you save the doc, change that final 0 to 1, execute the SET
field, then change the value back to 0

When the user opens the document, they have to know to do ctrl-A then F9.
The ASK fields should execute and all REFs (In the main body of the
document) that refer to their bookmarks should then be updated. firsttime
is
set to 0 so the nect time the user does ctrl-A, F9, no ASK fields are
executed.

To re-execute the ASKs the user would either have to know how to modify
that
firsttime value again, then do ctrl-A, F9

I've never actually done it that way (I think it's better to use a
userform
to set either bookmarks, document variables, or document properties) and
it
requires more user knowledge than I'd prefer to rely on, but it doesn't
need
any macros and is perhaps worth a try.

Peter Jamieson
"piersonal" wrote in message
...
I am trying to assemble a template doc so that when a new document is
created
the user types in just the once the customer name and for the document
to
then populate the various places that this information is needed. So
bookmarks seemed to be the answer, but once entered, I don't want the
user
to
be prompted for it again as it does with ask and fillin fields. Hope I
am
missing something here!!!

One idea I had was to have a non printing page at the beginning
containing
a
list of variables such as name, customer, version number, date etc so
that
these could be referenced to around the document. Is this possible???
Not
a
big VB man, so hoping it doesn't come to that!!!




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
Word as Data Entry Form for Access? MarieJ Microsoft Word Help 1 December 1st 06 03:17 PM
Automate data entry in Word document Ocean Microsoft Word Help 2 May 19th 06 08:58 PM
How can I setup a data entry form in Word? JAY@OPG Microsoft Word Help 2 January 12th 06 02:56 PM
Using MS-Word for data entry on pre-printed forms Suresh Menon Microsoft Word Help 2 April 15th 05 03:30 PM
Data entry environment using Word 2003 Gautam K Banik Microsoft Word Help 2 February 19th 05 11:59 AM


All times are GMT +1. The time now is 12:30 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"