If this is your first visit, be sure to check out the FAQ by clicking the link above. You may have to register before you can post: click the register link above to proceed. To start viewing messages, select the forum that you want to visit from the selection below. |
|
|
Thread Tools | Display Modes |
#1
|
|||
|
|||
link fields between access and word
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. |
#2
|
|||
|
|||
link fields between access and word
sinca wrote:
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 |
#3
|
|||
|
|||
link fields between access and word
Philip Herlihy wrote:
sinca wrote: 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 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 |
#4
|
|||
|
|||
link fields between access and word
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/...g=ws-msdevapps Ken Sheridan Stafford, England "sinca" wrote: 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. |
Thread Tools | |
Display Modes | |
|
|