473,320 Members | 1,854 Online
Bytes | Software Development & Data Engineering Community
Post Job

Home Posts Topics Members FAQ

Join Bytes to post your question to a community of 473,320 software developers and data experts.

Generating Word documents populated by Access 2003

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
2 2132

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
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 thread has been closed and replies have been disabled. Please start a new discussion.

Similar topics

3
by: Phil Rutter | last post by:
Hello All, I have about 700 word documents that have 2 tables one is static 4 colums x 5 rows the other is 5 colums x rows ranging from 2 to 100 what i wolud like to do is open the word doc....
12
by: Cheval | last post by:
Has anyone had any problems with inter-office automation between MS Word and MS Access in Office 2003? I have recently installed office 2003 in a new folder and have left the older office 2000...
4
by: Otis Hunter | last post by:
I have been given an Access Database which contains a table that has an OLE object field that contains a Word document. That table contains hundreds of records. I would like to find out how I can...
4
by: Dadio | last post by:
Hello On my Access database form I have a command button which opens a Word mail merge document in which I have created a number of fields (Title, FirstName, LastName, Address1 etc.) I would...
10
by: Neil | last post by:
An article at http://news.com.com/2100-1012-991694.html?tag=fd_top states: "XML would allow easier interchange of data generated in Office documents with back-end systems or existing Web...
3
by: Yohancef Chin | last post by:
Hi, Being fairly new to .NET I am looking for a way to call MS Word from an event on a webform, and after the user is finished save that created document to an SQL Server database. Has anyone...
7
by: Dave | last post by:
Apologies for the newbie question. I have created a vb.net program for my company that is designed to work with Word Templates (about forty of them that we commonly use) that are selected by the...
4
by: etuncer | last post by:
Hello All, I have Access 2003, and am trying to build a database for my small company. I want to be able to create a word document based on the data entered through a form. the real question is...
20
MMcCarthy
by: MMcCarthy | last post by:
This problem was proposed to me but not really my area of expertise so I thought I would open it up to the forum to see if anyone had any bright ideas. The problem is generating Microsoft Word...
0
by: DolphinDB | last post by:
Tired of spending countless mintues downsampling your data? Look no further! In this article, you’ll learn how to efficiently downsample 6.48 billion high-frequency records to 61 million...
0
by: ryjfgjl | last post by:
ExcelToDatabase: batch import excel into database automatically...
0
isladogs
by: isladogs | last post by:
The next Access Europe meeting will be on Wednesday 6 Mar 2024 starting at 18:00 UK time (6PM UTC) and finishing at about 19:15 (7.15PM). In this month's session, we are pleased to welcome back...
1
isladogs
by: isladogs | last post by:
The next Access Europe meeting will be on Wednesday 6 Mar 2024 starting at 18:00 UK time (6PM UTC) and finishing at about 19:15 (7.15PM). In this month's session, we are pleased to welcome back...
0
by: jfyes | last post by:
As a hardware engineer, after seeing that CEIWEI recently released a new tool for Modbus RTU Over TCP/UDP filtering and monitoring, I actively went to its official website to take a look. It turned...
0
by: ArrayDB | last post by:
The error message I've encountered is; ERROR:root:Error generating model response: exception: access violation writing 0x0000000000005140, which seems to be indicative of an access violation...
0
by: CloudSolutions | last post by:
Introduction: For many beginners and individual users, requiring a credit card and email registration may pose a barrier when starting to use cloud servers. However, some cloud server providers now...
1
by: Shællîpôpï 09 | last post by:
If u are using a keypad phone, how do u turn on JavaScript, to access features like WhatsApp, Facebook, Instagram....
0
by: Faith0G | last post by:
I am starting a new it consulting business and it's been a while since I setup a new website. Is wordpress still the best web based software for hosting a 5 page website? The webpages will be...

By using Bytes.com and it's services, you agree to our Privacy Policy and Terms of Use.

To disable or enable advertisements and analytics tracking please visit the manage ads & tracking page.