Automated MS Access 2000 tables/queries to MS Word 2000 Template

[dleonard]

Hi,

Thanks in advance for your help.

I am trying to extract table and query data from my MS Access 2000 DB
and insert it into my already defined MS Word 2000 template.

I have a form with a button setup in my database.
I have a word template with bookmarks all ready to have the data
inserted into it.
I have VB code that (automates) opens the word document, inserts text
or tables, then saves and closes it.
What I am after is the VB code behind the button on the form which
selects a query or table of my currently open database and gives me a
Recordset. The Recordset will be parsed and inserted into Word tables
at specific bookmarks.

Can anyone direct me to a good reference site which explains with
examples, what the syntax is to manipulate tables/queries?

Cheers,

Damian.

 

[Cindy M -WordMVP-]

Hi Dleonard,

What I am after is the VB code behind the button on the form which
selects a query or table of my currently open database and gives me a
Recordset. The Recordset will be parsed and inserted into Word tables
at specific bookmarks.

Look at the DAO object in Access's Help files. DAO lets you access
tables and queries over a programmed interface.

You'll find an example of this in WdAcc97.zip in the Special merges
section of my website's MailMerge FAQ. It's a bit old, but it should
give you the basic background.

Cindy Meister
INTER-Solutions, Switzerland
http://homepage.swissonline.ch/cindymeister (last update Jun 8 2004)
http://www.word.mvps.org

This reply is posted in the Newsgroup; please post any follow question
or reply in the newsgroup and not by e-mail