PC Review


Reply
Thread Tools Rate Thread

Can I export data from Access to a created form in MS Word

 
 
=?Utf-8?B?cXVlc3Rpb25z?=
Guest
Posts: n/a
 
      15th Feb 2006
I want to setup a form in MS Word with certain fields that can have data from
a MS Access database imported into. For example, the MS Word document would
have a name field, can I type in the particular person's name and then
through some process (macro/embedded or linked object?) have all the other
fields in the MS Word document updated with this person's data?
 
Reply With Quote
 
 
 
 
Joseph Meehan
Guest
Posts: n/a
 
      16th Feb 2006
questions wrote:
>I want to setup a form in MS Word with certain fields that can have
> data from a MS Access database imported into. For example, the MS
> Word document would have a name field, can I type in the particular
> person's name and then through some process (macro/embedded or linked
> object?) have all the other fields in the MS Word document updated
> with this person's data?


In Word with a blank document or the one you want to use as a base open,
select View-tool bars-Mail Merge if that toolbar is not open. Then select
the Icon to select a data source and use that to find your Access Database,
select it and then you will be able to add field from your table or query to
your Word document.

--
Joseph Meehan

Dia duit


 
Reply With Quote
 
=?Utf-8?B?TmV0d29ya1RyYWRl?=
Guest
Posts: n/a
 
      16th Feb 2006
Not exactly working in Word directly but one straight forward approach would
be to creat a Report that has the Word doc layout that you want......

One would then select the Person from the combo box - or start typing in and
it will auto-complete......once the person is selected you would generate the
report based on that record data...

not sure exactly where you are going with this but the Report can be
printed, viewed or sent out as a Word doc from there....
--
NTC


"questions" wrote:

> I want to setup a form in MS Word with certain fields that can have data from
> a MS Access database imported into. For example, the MS Word document would
> have a name field, can I type in the particular person's name and then
> through some process (macro/embedded or linked object?) have all the other
> fields in the MS Word document updated with this person's data?

 
Reply With Quote
 
 
 
Reply

Thread Tools
Rate This Thread
Rate This Thread:

Posting Rules
You may not post new threads
You may not post replies
You may not post attachments
You may not edit your posts

BB code is On
Smilies are On
[IMG] code is On
HTML code is Off
Trackbacks are On
Pingbacks are On
Refbacks are Off


Similar Threads
Thread Thread Starter Forum Replies Last Post
my form doesn't let me access already created data? mrbeepa Microsoft Access Getting Started 3 4th Aug 2008 06:45 PM
How do i input data once i've created a form in Access? new2access Microsoft Access Forms 3 14th Feb 2008 03:17 AM
How do I Export Access Form text to word form type document? =?Utf-8?B?RGF2aWRXNTc=?= Microsoft Access Forms 1 22nd Feb 2006 10:58 PM
Export Access form field info. to Word form fields? =?Utf-8?B?RG91Z19D?= Microsoft Access Forms 0 5th Apr 2005 11:53 PM
I am losing data in a form created in word when the form is email. =?Utf-8?B?TWlrZSBG?= Microsoft Word Document Management 4 12th Nov 2004 04:14 PM


Features
 

Advertising
 

Newsgroups
 


All times are GMT +1. The time now is 08:12 PM.