Rocky Smolin
rockysmolin at bchacc.com
Wed Sep 15 17:04:37 CDT 2010
That's actually what I'd have to do - use the same record sources as the main and sub reports and use automation to load the cells - .Cells(intRow, IntCol) = rs!fldSomeField I've done quite a bit of that so I've got snippets of code already - but it's a big PITA. After you load the cells, then you have to do the formatting, autofit, all that stuff. Runs into a bit of time and money, so I was looking for a more streamlined way to do it. I quoted them four hours and they don't seem to have a problem with that. So, in the absence of a better solution, off we go! Rocky -----Original Message----- From: accessd-bounces at databaseadvisors.com [mailto:accessd-bounces at databaseadvisors.com] On Behalf Of Rusty Hammond Sent: Wednesday, September 15, 2010 2:31 PM To: Access Developers discussion and problem solving Subject: Re: [AccessD] Creating a Spreadsheet from a Report I've not tried it (yet), but what about looking at it from a different direction. Instead of exporting to excel, setup a template spreadsheet in excel with the proper headers, then import the data into excel via linking to the same recordsource the report uses. I don't know if it would be easier or not but might be worth a look. Rusty -----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:18 PM To: 'Access Developers discussion and problem solving' Subject: Re: [AccessD] Creating a Spreadsheet from a Report 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 ********************************************************************** WARNING: All e-mail sent to and from this address will be received, scanned or otherwise recorded by the CPI Qualified Plan Consultants, Inc. corporate e-mail system and is subject to archival, monitoring or review by, and/or disclosure to, someone other than the recipient. ********************************************************************** -- AccessD mailing list AccessD at databaseadvisors.com http://databaseadvisors.com/mailman/listinfo/accessd Website: http://www.databaseadvisors.com