Word and Access

[Guest]

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.

 

[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

 

[Guest]

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.

 

[Joseph Meehan]

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.

It does not do the same thing. The results using Word will be a lot
more professional looking under most conditions than pasting the text into
an Access report.

Use the Wizard and the Access help. It may take a little time the first
time you do it, but it is not all that difficult and I believe the results
are worth it and in the long run it is also easier.

If you want to go ahead and try the paste method into Access, just past
one page at a time. I suspect that will work, although I have never tried
it.

Good luck.

 

[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

 

[Arvin Meyer]

I strongly suggest you use automation. It's pretty easy and there's a sample
of the code on my website:

http://www.datastrat.com/Code/WordMerge.txt

Albert D. Kallal has also developed a very simple system which you can find
at his website:

http://www.members.shaw.ca/AlbertKallal/msaccess/WordMerge20.zip
--
Arvin Meyer, MCP, MVP
Microsoft Access
Free Access Downloads
http://www.datastrat.com
http://www.mvps.org/access

 

[Guest]

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

 

[Guest]

Hi Alvin,

I am not an expert when it comes to using code so I am going to investigate
to possiblity of using a diferent database application that will let me do
what I need it to do.

Thanks for you help.