PC Review


Reply
Thread Tools Rate Thread

Access and Word

 
 
Joe Delphi
Guest
Posts: n/a
 
      17th Oct 2006
Hi,

I need to generate a printed document that will contain data from
Microsoft Access. My customer already generates this document manually
using Microsoft Word and he really likes the format, so it seems like the
way to go is to populate his word document with Access data rather than to
attempt to mimic his document using MS Access reports.

I want my user to press a button in the MS Access program and have
it automatically generate an MS Word .doc file or possibly open an MS Word
template file (.dot file) and populate it with data from the database and
save it as a doc file.

Does anyone know any good resources that explain how to do this?


Thanks,
JD


 
Reply With Quote
 
 
 
 
dbahooker@hotmail.com
Guest
Posts: n/a
 
      17th Oct 2006
yeah... export an access report as WORD.



Joe Delphi wrote:
> Hi,
>
> I need to generate a printed document that will contain data from
> Microsoft Access. My customer already generates this document manually
> using Microsoft Word and he really likes the format, so it seems like the
> way to go is to populate his word document with Access data rather than to
> attempt to mimic his document using MS Access reports.
>
> I want my user to press a button in the MS Access program and have
> it automatically generate an MS Word .doc file or possibly open an MS Word
> template file (.dot file) and populate it with data from the database and
> save it as a doc file.
>
> Does anyone know any good resources that explain how to do this?
>
>
> Thanks,
> JD


 
Reply With Quote
 
Albert D. Kallal
Guest
Posts: n/a
 
      17th Oct 2006
If the data you need to place into the word docuemnt is one reocrd, then I
have a nice working soliner her




 
Reply With Quote
 
Albert D. Kallal
Guest
Posts: n/a
 
      17th Oct 2006
opps..bumped the send key....


If the data you need to place into the word document is one record, then I
have a nice working solution here

http://www.members.shaw.ca/AlbertKal.../msaccess.html

Try the super easy word merge, it might just be what you are looking for...


--
Albert D. Kallal (Access MVP)
Edmonton, Alberta Canada
(E-Mail Removed)


 
Reply With Quote
 
Arvin Meyer [MVP]
Guest
Posts: n/a
 
      17th Oct 2006
You might like to set up Word Bookmarks and populate them from an Access
form. Here's how:

http://www.datastrat.com/Code/WordMerge.txt
--
Arvin Meyer, MCP, MVP
http://www.datastrat.com
http://www.mvps.org/access
http://www.accessmvp.com

"Joe Delphi" <(E-Mail Removed)> wrote in message
news:l5WYg.3188$xI4.2820@fed1read11...
> Hi,
>
> I need to generate a printed document that will contain data from
> Microsoft Access. My customer already generates this document manually
> using Microsoft Word and he really likes the format, so it seems like the
> way to go is to populate his word document with Access data rather than to
> attempt to mimic his document using MS Access reports.
>
> I want my user to press a button in the MS Access program and have
> it automatically generate an MS Word .doc file or possibly open an MS Word
> template file (.dot file) and populate it with data from the database and
> save it as a doc file.
>
> Does anyone know any good resources that explain how to do this?
>
>
> Thanks,
> JD
>



 
Reply With Quote
 
 
 
Reply

Thread Tools
Rate This Thread
Rate This Thread:

Posting Rules
You may not post new threads
You may not post replies
You may not post attachments
You may not edit your posts

BB code is On
Smilies are On
[IMG] code is On
HTML code is Off
Trackbacks are On
Pingbacks are On
Refbacks are Off


Similar Threads
Thread Thread Starter Forum Replies Last Post
run mail merge to word from ms access using and save every record as separate word document Rasta Microsoft Access 0 12th Dec 2007 11:22 PM
Mail merge: Word/Access ok but Access/Word is problem =?Utf-8?B?S2V2cnls?= Microsoft Access 4 11th Jul 2006 02:38 AM
How do I output Access Report via Word Macro to Word/Excel instead of Printer? chris@hemingwayc.freeserve.co.uk Microsoft Access Getting Started 13 22nd May 2006 10:06 PM
Word Document pieces in Access Reports print Larger than they are in word Howard Ducat Microsoft Access Reports 5 25th Mar 2004 01:27 AM
How to Access Word active object on other application and Get the word's Document FilePath? Lex Yacc Microsoft C# .NET 0 20th Aug 2003 04:05 AM


Features
 

Advertising
 

Newsgroups
 


All times are GMT +1. The time now is 07:06 PM.