Hi James,
if you decide to do automation from Access to Word, I have a sample you can download here:
http://tech.groups.yahoo.com/group/MS_Access_Professionals/files/Crystal/
WriteToWord_MDB_DOT_TXT__Crystal.zip
Example to create a Word document and populate it with information from Access. Contains a DOT file (Word Document Template, WriteToWord.DOT), an MDB file (Access Database, WriteToWord.mdb), and a TXT file with code and comments.
~~~
it is good to know how to do this
~~~
I also have utilities that create Word tables and do formatting from Access such as this download:
bas_crystal_Document_SQL_FormRpt_RecordSource_090703.zip
Document Form and Report RecordSources, and Query SQL. Look at first 3 procedures in modules for quick launch. Import Module into Database. File, Import from VBE -- navigate to BAS file.
Warm Regards,
Crystal
*
(: have an awesome day :)
*
--- On Fri, 7/8/11, Bill Mosca wrote:
> James
>
> As you now know, Access reports to Word docs leaves a lot
> to be desired. Graphics and layout get trashed. The best
> thing is to save the report as a PDF file. 2007 and 2010
> have that capability built in. If you have an earlier
> version go to Lebans.com and search for PDF. He has built a
> couple DLLs and the code to do it for you. The great thing
> is you don't have to register the DLLs. Just stick
> them in the folder where the database lives.
>
> Another way is to create a Word template and then do a
> merge to fill the fields, but this is really time consuming
> for most reports.
>
> Regards,
> Bill Mosca, Founder - MS_Access_Professionals
> http://www.thatlldoit.com
> Microsoft Office Access MVP
> https://mvp.support.microsoft.com/profile/Bill.Mosca
>
>
>
> --- j1eggert wrote:
> >
> > When trying to convert an Access report to a word
> document it cuts off part of the text and changes fonts etc.
> What can I do to maintain the exact same layout in Word as
> it is layed out in the report?
> >
> > Thanks,
> > James Eggert
> >
>
>
Tidak ada komentar:
Posting Komentar