Home | Contact Us | FAQ | Search & Site Map | Link to Us
Sign In | Join | Other 45 Sites in Network
Home
Discussion GroupsFormsForms ProgrammingQueriesModules / DAO / VBAReports / PrintingMacrosDatabase DesignSecurityConversionImporting / LinkingSQL Server / ADPMultiuser / NetworkingReplicationSetup / ConfigurationDeveloper ToolkitsActiveX ControlsNew UsersGeneral 1General 2
Access DirectoryToolsTutorialsUser Groups
Related Topics
SQL ServerOther DB ProductsMS OfficeMore Topics ...

MS Access Forum / General 2 / July 2007

Tip: Looking for answers? Try searching our database.

Word Automation Data Sources

Thread view: 
Enable EMail Alerts  Start New Thread
Thread rating: 
Joe - 30 Jul 2007 22:20 GMT
Hi,

       My customer wants me to generate an invoice from data
contained in MS Access.  He has a Microsoft Word - based invoice that
he currently uses and wants the new system to use the same document.
So I intend to use Word Automation and MailMerge to meet the
requirement.

       Some of the information on the invoice is name, address, city,
state, zip - one record per invoice, no problem.   But he also has a
detailed section of the invoice that will contain multiple line
items.   So there will be multiple records per invoice for that part.

       Question:  Can one Word document have more than one MS Access-
based data source?  I am thinking that it will require two separate
queries to populate one invoice.  All of the documentation that I have
found on this topic seems to suggest that only one data source is
allowed.

        Also - anyone know a good book on MS Access - MS Word
automation?

Any help appreciated,
Joe
pietlinden@hotmail.com - 30 Jul 2007 23:38 GMT
> Hi,
>
[quoted text clipped - 20 lines]
> Any help appreciated,
> Joe

There's an example of how to do this in Access Developer's Handbook,
Desktop Edition.  Kinda pricey, but well worth the money. (Read
reviews at Amazon.com... don't take my word for it.)

Pieter
 
Sign In
Join
My Latest Posts
My Monitored Threads
My Blog
My Photo Gallery
My Profile
My Homepage

Start New Thread
Enable EMail Alerts
Rate this Thread



©2008 Advenet LLC   Privacy Policy - Terms of Use
This website includes both content owned or controlled by Advenet as well as content owned or controlled by third parties.