Publishing Forms to Word

[KurtL]

Maybe this shouldnt even be done in a form as simple of a task i need. I have a query of multiple tables andi want to be able to export it to word with only a few of the columns from the query as well as displayings yes/no instead of -1/0. Basically im just trying to make a table in word so i can have all the correct pages headers and such to make our document control people happy.

Is there a way to publish a form to a word document and get the header of each column to appear at the top of each page? I noticed that if i export the form to HTML then copy and paste the table in the html file to word its works but thats a huge pain in the you know what, and the table ends up looking a bit odd in word and no amount of table formatting seems to fix that but thats a different issue.

Thanks

 

[Pat Hartman]

Rather than exporting a form, create a report and export that.

 

[ansentry]

Here is a sample written by Helen Feddema.

It works fine,however it takes a bit of work to create a new one, even with this excellent example.

To test the sample you to:
1) Put the Northwind Invoice.dot into your templates file.
2) Open the form in the database, open the code behind the cmdCreateInvoice, find "C:\Documents and Settings\johna\Application Data\Microsoft\Templates\" and change it to suit you situation, normally you would only have to change johna to your username.

 

[KurtL]

Ive tried the report but i noticed something i didnt like. In some cases some components that i have in my database list 4 different manufactureres while others only 1. However in my reports every component had verticle spacing for for 4 rows. Does that make any sense? While i liked using the reports and it was MUCH easier to maintain, the spacing issue made the document excessivly large.

By the way i have no idea what im doing. Never had any classes or training or anything in Access.