[AccessD] Creating a Spreadsheet from a Report

As I understand it, they want the vendor to add data and send it back to
them - pricing, delivery dates - stuff like that. Here's what the report
looks like

http://www.e-z-mrp.com/r_buy.htm

Except there are two more sub-reports which don't show on this shot - the
manufacturer's cross reference an the current shortages.   

And they want the spreadsheet to look like the report.

Rocky


-----Original Message-----
From: accessd-bounces at databaseadvisors.com
[mailto:accessd-bounces at databaseadvisors.com] On Behalf Of David McAfee
Sent: Wednesday, September 15, 2010 2:29 PM
To: Access Developers discussion and problem solving
Subject: Re: [AccessD] Creating a Spreadsheet from a Report

Why not have a form where they can add that stuff then add it to the report?

A report can then be printed, faxed, emailed, PDFd...

On Wed, Sep 15, 2010 at 2:18 PM, Rocky Smolin <rockysmolin at bchacc.com>
wrote:
> I asked as well. :)  They want to be able to add some stuff to it and 
> send it to vendors (it's a buy report that comes out of my MRP system) 
> and the vendor will then note on the report actual ship and dues dates 
> - stuff like that.  I think.
>
> Rocky
>
>
> -----Original Message-----
> From: accessd-bounces at databaseadvisors.com
> [mailto:accessd-bounces at databaseadvisors.com] On Behalf Of Dan Waters
> Sent: Wednesday, September 15, 2010 2:14 PM
> To: 'Access Developers discussion and problem solving'
> Subject: Re: [AccessD] Creating a Spreadsheet from a Report
>
> Rocky - I have to ask:
>
> Why does she want a spreadsheet to look like a report?  What's she 
> going to do with it?
>
> Dan
>
> -----Original Message-----
> From: accessd-bounces at databaseadvisors.com
> [mailto:accessd-bounces at databaseadvisors.com] On Behalf Of Rocky 
> Smolin
> Sent: Wednesday, September 15, 2010 4:10 PM
> To: 'Access Developers discussion and problem solving'
> Subject: [AccessD] Creating a Spreadsheet from a Report
>
> Dear List:
>
> I have a client who wants one of the reports in my app to be exported 
> as a spreadsheet.  But nota flat file.  She wants the spreadsheet to 
> look like the report - header line, details with their own fields 
> headings, plus two other sub reports.
>
> I've done this with other reports on a cell by cell basis where the 
> Transfer method won't work.  Big PITA.  Is there an easier way to do this?
>
>
>
> MTIA
>
> Rocky
>
>
>
>
> --
> 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
>

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