Solved

data form and document printing in ms word or office

Posted on 2013-06-20
3
244 Views
Last Modified: 2013-06-25
Greetings,

I want to produce a contract using MS Word.  Currently we use Filemaker.

Users enter data in fields and then it can be printed in a "Layout" which looks like a contract and in which the user entered data is displayed in the proper locations.

I can add content control fields in a word document.  Is there a way to make the data entry form different from the printed document.  In the current system there is a data entry layout and then that data is displayed in a contract layout which is formatted to be printed.

Can this be done in word or is it better just to make the contract with the content control fields in place and then the user just tabs through the document fields and enters their data?

Thanks very much.

Sky
0
Comment
Question by:skykuhl
  • 2
3 Comments
 
LVL 76

Accepted Solution

by:
GrahamSkan earned 500 total points
Comment Utility
You would almost certainly need to use VBA coding.

You could create a Userform for Data entry and, when complete, copy the text on to the print document.

It could also be done between two different documents.

A no-code way would be to have the document in two parts, with Ref Fields in the print section pointing to bookmarked locations in the entry section. It is possible to print only certain pages, or the layout section could be discarded from the printout,
0
 
LVL 76

Expert Comment

by:GrahamSkan
Comment Utility
If you go for a single layout, you can protect the document, so that the user can't click into the fixed text and accidentally modify it.
0
 

Author Closing Comment

by:skykuhl
Comment Utility
thank you.
0

Featured Post

How to run any project with ease

Manage projects of all sizes how you want. Great for personal to-do lists, project milestones, team priorities and launch plans.
- Combine task lists, docs, spreadsheets, and chat in one
- View and edit from mobile/offline
- Cut down on emails

Join & Write a Comment

This is written from a 'VBA for MS Word' perspective, but I am sure it applies to most other MS Office components where VBA is used.  One thing that really bugs me is slow code, ESPECIALLY when it's mine!  In programming there are so many ways to…
No matter the version of Windows you are using, you may have some problems with Windows Search running too slow or possibly not running at all. Before jumping into how you can solve this issue, just know there are many other viable alternative deskt…
The viewer will learn how to create two correlated normally distributed random variables in Excel, use a normal distribution to simulate the return on different levels of investment in each of the two funds over a period of ten years, and, create a …
Excel styles will make formatting consistent and let you apply and change formatting faster. In this tutorial, you'll learn how to use Excel's built-in styles, how to modify styles, and how to create your own. You'll also learn how to use your custo…

772 members asked questions and received personalized solutions in the past 7 days.

Join the community of 500,000 technology professionals and ask your questions.

Join & Ask a Question

Need Help in Real-Time?

Connect with top rated Experts

10 Experts available now in Live!

Get 1:1 Help Now