[AccessD] FW: Transportable Document Approach needed

A real PITA.

I've had a similar requirment on several occasions.  You can try outputting the report to 
RTF, but this only works with VERY plainly formatted reports (no lines/boxes,sub reports 
etc)  

In the majority of cases, I build a template in word with bookmarks in the appropriate places, 
open the report's recordset in code and use Office Automation to push the data in.

I can send you a couple of examples if you want.

-- 
Stuart


On 3 Mar 2009 at 13:20, Rocky Smolin at Beach Access  wrote:

> Dear List:
>  
> I have a colleague who has a need to import an Access report into a Word doc
> and have it be editable.  Any ideas?
>  
> MTI
>  
> 
> Rocky Smolin
> 
> Beach Access Software
> 
> 858-259-4334
> 
> www.e-z-mrp.com <http://www.e-z-mrp.com/> 
> 
> www.bchacc.com <http://www.bchacc.com/> 
> 
>  
> 
>  
> 
>  
> 
>   _____  
> 
> From: Mike Dwyer [mailto:mike at aesadvantage.net] 
> Sent: Tuesday, March 03, 2009 12:55 PM
> To: Rocky Smolin at Beach Access Software
> Cc: Doug Murphy
> Subject: RE: Transportable Document Approach needed
> 
> 
> 
> It has to be editable.  They will be adding paragraphs, photos, etc.
> 
> In word 2007 you can embed a PDF and it displays the image.  However, it
> won't do multi-page pdfs.
> 
>  
> 
> From: Rocky Smolin at Beach Access Software [mailto:rockysmolin at bchacc.com] 
> Sent: Tuesday, March 03, 2009 12:53 PM
> To: Mike Dwyer; bheygood at abestsystems.com; 'Dixon'; wayne.warren at gmail.com;
> 'Carla Bohnet'; 'barbcarleton at jewelrydesignermana'; Dw-murphy at cox.net;
> bhynum at cox.net; elance at san.rr.com
> Subject: RE: Transportable Document Approach needed
> 
>  
> 
> PDF would be so much simpler.  Is that an option?
> 
>  
> 
> Else automating the insertion of a snapview into the word doc might be an
> approach.
> 
>  
> 
> But simply exporting a report to a word doc - you lose the formatting IIRC.
> 
>  
> 
> Rocky Smolin
> 
> Beach Access Software
> 
> 858-259-4334
> 
> www.e-z-mrp.com <http://www.e-z-mrp.com/> 
> 
> www.bchacc.com <http://www.bchacc.com/> 
> 
>  
> 
>  
> 
>  
> 
>  
> 
>   _____  
> 
> From: Mike Dwyer [mailto:mike at aesadvantage.net] 
> Sent: Tuesday, March 03, 2009 12:29 PM
> To: bheygood at abestsystems.com; Rocky Smolin at Beach Access Software; Dixon;
> wayne.warren at gmail.com; Carla Bohnet; barbcarleton at jewelrydesignermana;
> Dw-murphy at cox.net; bhynum at cox.net; elance at san.rr.com
> Subject: Transportable Document Approach needed
> 
> Ok, I've got an interesting request and I'm not sure how best to approach
> this.  Perhaps you folks have done this before.
> 
>  
> 
> The customer needs a word document put together that is comprised of Access
> Reports for the most part.  They will then add new pages with narratives and
> pictures, and what-not.  They will then print this document or just keep it
> on their laptop.
> 
>  
> 
> I need to generate this document through an automated fashion.  The reports
> are quite different and won't likely "chain" together via some master report
> container.  Given what's available, any ideas on the mechanism to get the
> report into a word document?  
> 
> -- 
> AccessD mailing list
> AccessD at databaseadvisors.com
> http://databaseadvisors.com/mailman/listinfo/accessd
> Website: http://www.databaseadvisors.com