[AccessD] FW: Transportable Document Approach needed

Thanks.  And thanks for the offer of examples.  It may come to that. 


Rocky Smolin
Beach Access Software
858-259-4334
www.e-z-mrp.com
www.bchacc.com
 
 

-----Original Message-----
From: accessd-bounces at databaseadvisors.com
[mailto:accessd-bounces at databaseadvisors.com] On Behalf Of Stuart McLachlan
Sent: Tuesday, March 03, 2009 2:01 PM
To: Access Developers discussion and problem solving
Subject: Re: [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


-- 
AccessD mailing list
AccessD at databaseadvisors.com
http://databaseadvisors.com/mailman/listinfo/accessd
Website: http://www.databaseadvisors.com