Save an access form as a Word doc (Word2003)

  • Thread starter Thread starter Guest
  • Start date Start date
G

Guest

I have a form in my database where I need to save the individual record as a
word document. I know I can analyze the form record in Word but I lose all
the formatting from the form. Any way around this? Is there an easy way to
"Save As" into word?

Thank You!
 
Tina,

A couple of points to ponder...

1) Forms are designed for entering data, not outputting data
for print format.
2) Reports are for printing formatted data and format
wonderfully.
3) You can save a formatted Access report as an RTF Word
compatible document but not all of the formatting will
survive the transition.
4) While you can export data, you can't really export a form
with it's data.
5) You can 'pull' Access data into a formatted Word document
with Word's merge capability.
6) You can 'push' data to Word from a form or without a form
with VBA and automation.
See
(http://support.microsoft.com/Default.aspx?kbid=210271) for
doing it with a form.

HTH
 
Gary,

Thanks for the quick reply. I followed the steps and made the necessary
changes in my code. It was a little difficult because the article refers to
Word 2000 and I'm working in Word 2003. When I click on the merge command
button, nothing happens. Would the coding change if I'm working in another
version of word?

thanks!
 
BTW...I was unable to load the MS Word 9.0 Object Library. Is this because
I'm already in Word 2003? I do however, have the MS Word 11.0 Object Library
loaded. Would this be enough?
 
Tina,

Yes, you would need to have the appropriate Library for the
version of Word that you have. As I haven't used that code
myself and 2002 is the latest I have at the moment, I can't
tell you for sure if there are any issues that could be
cropping up between the versions.

Are you getting any error messages? Have you tried putting a
Break Point in your code behind the button to step through
the code to see if you can spot where the problems are?

If you can't seem to spot the problem post your code to the
group and maybe somebody can spot something for you.
 
Back
Top