link fields between access and word

[sinca]

I am trying to automate my employee database. I have formas that were
originally in Word. Is there a way to be able to export a single record from
access into the word form? Such as importing the name, location, phone etc..
Any help would be greatly appreciated.

 

[Philip Herlihy]

I am trying to automate my employee database. I have formas that were
originally in Word. Is there a way to be able to export a single record from
access into the word form? Such as importing the name, location, phone etc..
Any help would be greatly appreciated.

Three ways (that I can think of) of approaching this.

One is to arrange it so that Access is displaying only one record in a
form (possibly a form you've designed specifically for this role). One
way to get Access to display only one record is to highlight anything
unique on the form (Primary Key?) and click the "Filter by Selection"
button (built-in). Then click Tools, Office Links, Publish with Word.
If my quick experiment is anything to go by, you'll need to fool around
with your Access form to get it to work usefully!

If your VBA isn't too bad, you could, of course, add a reference to the
Word library, and create and populate a Word document straight from
within Access. You'll need to get your head around the Word Object
model but it's certainly possible. A table in the Word document gives a
good structure to work with, and if you set up a template in Word that
should give you a good start.

However, perhaps a mail-merge would do the trick?

Alternatively, you might like to look at InfoPath (part of Office 2003+)
which exists to provide forms to be shared between Office applications.

Phil, London

 

[Philip Herlihy]

Three ways (that I can think of) of approaching this.

One is to arrange it so that Access is displaying only one record in a
form (possibly a form you've designed specifically for this role). One
way to get Access to display only one record is to highlight anything
unique on the form (Primary Key?) and click the "Filter by Selection"
button (built-in). Then click Tools, Office Links, Publish with Word.
If my quick experiment is anything to go by, you'll need to fool around
with your Access form to get it to work usefully!

If your VBA isn't too bad, you could, of course, add a reference to the
Word library, and create and populate a Word document straight from
within Access. You'll need to get your head around the Word Object
model but it's certainly possible. A table in the Word document gives a
good structure to work with, and if you set up a template in Word that
should give you a good start.

However, perhaps a mail-merge would do the trick?

Alternatively, you might like to look at InfoPath (part of Office 2003+)
which exists to provide forms to be shared between Office applications.

Phil, London

Re first suggestion: probably makes more sense to use a Report than a
form, as these are designed for printing. If you publish it to Word
(you'll get an RTF Rich Text Format file) it'll open in Word automatically.

Phil

 

[Ken Sheridan]

You might like to take a look at the demo of various Access to Word
automation operations available at the following link. It includes the
insertion of data from a current record in an Access form into a Word form.


http://community.netscape.com/n/pfx/forum.aspx?msg=23781.1&nav=messages&webtag=ws-msdevapps


Ken Sheridan
Stafford, England