Multiple access records to a single word document

G

Guest

I have an access query that, depending on what week we are in, will contain
different number of records. I have built a form that displays the data in
the format i require.

I wish to merge all these records to a single word document.

What i am getting at the moment is single records only

Any Ideas?

PMK
 
G

Guest

Hi, PMK.

Duplicate the format in a report, and publish the report to Word. Access
doesn't provide a lot of flexibility with printing forms.

Sprinks
 
A

Arvin Meyer

You'll need to build a recordset to pass to a table in the Word doc There is
some code from Ken Getz, written in the Access 2002 Developer's Handbook to
build the table from a recordset. Owning the Developer's Handbook is worth
every penny of it's price even for this snippet of code.
--
Arvin Meyer, MCP, MVP
Microsoft Access
Free Access Downloads
http://www.datastrat.com
http://www.mvps.org/access
 

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Similar Threads

Exporting single record from a query to a word document 2
Merging to Word 8
how to merge mult records into a single record 2
Access 2003 with over 1 million records on a single file 7
Can Access act as a 'multiple data source' for mail merge to Word? 3
MapPoint-mapping multiple catagories from a single Access Dbase 3
Mail Merge Formatted Table from Access to Word 2
Merge multiple records to single Word doc (office 2003 pro) 2

Top