By using this site, you agree to our updated Privacy Policy and our Terms of Use. Manage your Cookies Settings.
424,652 Members | 1,409 Online
Bytes IT Community
+ Ask a Question
Need help? Post your question and get tips & solutions from a community of 424,652 IT Pros & Developers. It's quick & easy.

Generating Word documents populated by Access 2003

P: n/a
Hi,

I am working on a database used to store information, and then generate
customized letters. I have most of it working, (Thanks to the posts in
this group =)) I have a button which can be clicked and it opens word
and fills in the blanks of my template appropriately, with the
exception of 2 areas. These areas of the letter need to be pulled from
subforms of the existing form, and in the word document they need to be
a list or possibly a table, and dynamic in nature. Does anyone have
any idea how I can accomplish this? I am a novice at best, so please
speak as plainly as possible =)

Jun 5 '06 #1
Share this Question
Share on Google+
2 Replies


P: n/a

da**********@gmail.com wrote:
Hi,

I am working on a database used to store information, and then generate
customized letters. I have most of it working, (Thanks to the posts in
this group =)) I have a button which can be clicked and it opens word
and fills in the blanks of my template appropriately, with the
exception of 2 areas. These areas of the letter need to be pulled from
subforms of the existing form, and in the word document they need to be
a list or possibly a table, and dynamic in nature. Does anyone have
any idea how I can accomplish this? I am a novice at best, so please
speak as plainly as possible =)


Not sure you're going to like this response, but hard questions have
hard answers. This is covered in Access Developer's Handbook. IIRC,
they pass a recordset to Word and convert it to a table (could be an
ADO recordset converted to a string... can't remember!)

To make a long story short, their code does it for ya. And it's not a
trivial bit of code, either. The book has a working example that
creates an invoice in Word.

Jun 6 '06 #2

P: n/a
Thank you! I really appreiciate your giving me a place to look...
pi********@hotmail.com wrote:
da**********@gmail.com wrote:
Hi,

I am working on a database used to store information, and then generate
customized letters. I have most of it working, (Thanks to the posts in
this group =)) I have a button which can be clicked and it opens word
and fills in the blanks of my template appropriately, with the
exception of 2 areas. These areas of the letter need to be pulled from
subforms of the existing form, and in the word document they need to be
a list or possibly a table, and dynamic in nature. Does anyone have
any idea how I can accomplish this? I am a novice at best, so please
speak as plainly as possible =)


Not sure you're going to like this response, but hard questions have
hard answers. This is covered in Access Developer's Handbook. IIRC,
they pass a recordset to Word and convert it to a table (could be an
ADO recordset converted to a string... can't remember!)

To make a long story short, their code does it for ya. And it's not a
trivial bit of code, either. The book has a working example that
creates an invoice in Word.


Jun 7 '06 #3

This discussion thread is closed

Replies have been disabled for this discussion.