Home | Contact Us | FAQ | Search & Site Map | Link to Us
Sign In | Join | Other 45 Sites in Network
Home
DiscussionsAccessExcelInfoPathOutlookPowerPointPublisherWord
DirectoryUser Groups
Related Topics
Outlook ExpressInternet ExplorerWindowsMS Server ProductsMore Topics ...

MS Office Forum / Word / Programming / January 2006

Tip: Looking for answers? Try searching our database.

Creating a Word Template

Thread view: 
Enable EMail Alerts  Start New Thread
Thread rating: 
Sarrina - 31 Jan 2006 15:25 GMT
Good Morning.

This is probably a stupid question - but for some reason, I can't seem to
troubleshoot my way out of it (and it's probably an easy fix that I'm
overlooking...)

I had created a report/book for a few users.  Not quite template material,
but I am now finding time to revisit it to make things easier for the user.  
So...I'm revamping the template to add new features, explanations/comments,
drop down lists, references, and last but not least - the area of my trouble:
a data form.

Since several fields repeats itself throughout the entire report (e.g.
SiteName is entered @ 30 times throughout), I figure a data form would be the
easiest to draw out a few things from the user...right?

Well...here's my downfall:

Everytime I link the document for the data form to the main document - it
doesn't seem to recognize the fields and picks up the full document and I get
the "field and record deliminator" box.  Seems that no matter what I do - I
can't get past this bump.

Help!

TIA,
Sarr
Charles Kenyon - 31 Jan 2006 16:12 GMT
Using a data form is a mailmerge function not a vba (visual basic for
applications) problem.

http://word.mvps.org/FAQs/MailMerge/CreateAMailMerge.htm and
http://word.mvps.org/FAQs/MailMerge/CreateADataSource.htm may help. Note
that the data form must be located where everyone using your template can
find it.

On the other hand, if you simply want to repeat what is entered once
elsewhere in a document, you don't want a mailmerge or a data form, you want
to repeat data.

From the FAQ

19. How can I enter something once in a document and have it repeat
elsewhere?
   http://gregmaxey.mvps.org/Repeating_Data.htm

Signature

Charles Kenyon

Word New User FAQ & Web Directory: http://addbalance.com/word

Intermediate User's Guide to Microsoft Word (supplemented version of
Microsoft's Legal Users' Guide) http://addbalance.com/usersguide

See also the MVP FAQ: http://word.mvps.org/FAQs/ which is awesome!
--------- --------- --------- --------- --------- ---------
This message is posted to a newsgroup. Please post replies
and questions to the newsgroup so that others can learn
from my ignorance and your wisdom.

> Good Morning.
>
[quoted text clipped - 29 lines]
> TIA,
> Sarr
Sarrina - 31 Jan 2006 16:53 GMT
First: Apologies for the misdirected post.  I haven't been on here for awhile
and everything got changed around a lot.  :p

Second:  Thanks for the info.  

[reference of "report" means the template; reference of "book" means end
product]

Though I am very familiar with merge documents and referencing fields...my
goal is to still have the initial information drawn from the user prior to
the user going through the report.  The report is pretty complex as it is and
there is no completing it with a click of a button.  Each report has to be
customized for each site once they order the book.  But each report has the
basic information (e.g. Site name, address, phone #'s, owner names, etc.
etc.).  However, the first time each field appears varies on different pages
(template is 52 pages - book can be anywhere from 52-60 pages).

I'm still new to VBA (I learned on the fly for a complex Excel workbook, but
haven't used it yet with Word), so I am open to incorporating VBA if
necessary.  I'm trying to avoid that only because the users have different
OSs (newer) than mine.

What would be the best way to accomplish my goal?

TIA,
~Sarr

> Using a data form is a mailmerge function not a vba (visual basic for
> applications) problem.
[quoted text clipped - 47 lines]
> > TIA,
> > Sarr
Doug Robbins - Word MVP - 31 Jan 2006 19:05 GMT
I think that you should be using a userform to get the data from the user

See the article "How to create a Userform" at:

http://word.mvps.org/FAQs/Userforms/CreateAUserForm.htm

Signature

Hope this helps.

Please reply to the newsgroup unless you wish to avail yourself of my
services on a paid consulting basis.

Doug Robbins - Word MVP

> First: Apologies for the misdirected post.  I haven't been on here for
> awhile
[quoted text clipped - 86 lines]
>> > TIA,
>> > Sarr

Rate this thread:






 
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.