Solved

data form and document printing in ms word or office

Posted on 2013-06-20
3
252 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:Schuyler Kuhl
[X]
Welcome to Experts Exchange

Add your voice to the tech community where 5M+ people just like you are talking about what matters.

  • Help others & share knowledge
  • Earn cash & points
  • Learn & ask questions
  • 2
3 Comments
 
LVL 76

Accepted Solution

by:
GrahamSkan earned 500 total points
ID: 39262141
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
ID: 39262151
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:Schuyler Kuhl
ID: 39276170
thank you.
0

Featured Post

Technology Partners: We Want Your Opinion!

We value your feedback.

Take our survey and automatically be enter to win anyone of the following:
Yeti Cooler, Amazon eGift Card, and Movie eGift Card!

Question has a verified solution.

If you are experiencing a similar issue, please ask a related question

Microsoft Office Picture Manager is not included in Office 2013. This comes as a shock to users upgrading from earlier versions of Office, such as 2007 and 2010, where Picture Manager was included as a standard application. This article explains how…
You need to know the location of the Office templates folder, so that when you create new templates, they are saved to that location, and thus are available for selection when creating new documents.  The steps to find the Templates folder path are …
The viewer will learn how to use a discrete random variable to simulate the return on an investment over a period of years, create a Monte Carlo simulation using the discrete random variable, and create a graph to represent the possible returns over…
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 …

733 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