Word and Access

D

Doug Bell

Hi,

I want to use a 17 page word document as a template for a report in access
but I can't seem to be able to do it.

Is it possible?

Many Thanks.
 
A

Arvin Meyer

You can use Access and Word together with automation (formerly called OLE
Automation) or just copy Word text and paste it in Access labels to build
the document within Access itself. Perhaps if you gave us more detail, we
could expand our ability to help.
--
Arvin Meyer, MCP, MVP
Microsoft Access
Free Access downloads:
http://www.datastrat.com
http://www.mvps.org/access
 
D

Doug Bell

Hi Arvin,

I have tried to copy and paste but it only pastes the first page. basically
the word document will be the template for the report then once into access I
would open in design mode to add the fields required. Since the Database is
already up and running, I didn't want to create a document in Word that does
the same thing.

I am by no means an advanced user of Access, so I am struggling to
understand how I can accomplish this or how to create a multiple (all
different) page report for one database file entry of which I would need to
use the data from approximately 13 fields.

I hope this is a little clearer, I don't quite know what else to say! lol

Cheers.
 
L

Larry Daugherty

Hi Doug,

I'm as mystified as the others who are trying to help. Since you already
have the source document in Word, why have you chosen not to use Word's
mail-merge? That's just what it's designed to do. Word knows about Access
tables and queries and you can insert the field names in your Word document.
I've used Automation to write Word documents from Access in order to take
advantage of the word processing features. It's orders of magnitude more
difficult than using Mail Merge.

HTH
 
D

Doug Bell

Hi Larry,

The database is already in operation so to have the mail merge and the
database means I am having to duplicate or use two programmes. But if I
could import the word document into Access as a report template it would
negate the use of word completely.

I have tried to build the report from scratch copying the word document, but
unfortunately Access only allows upto a 4 page template so thats not worked
either.

I give up! lol
 
Top