link fields between access and word

  • Thread starter Thread starter sinca
  • Start date Start date
S

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.
 
sinca said:
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.
Click to expand...

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 said:
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
Click to expand...

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
 
Back
Top