Rocky Smolin
rockysmolin at bchacc.com
Wed Sep 15 17:29:22 CDT 2010
Well, then the screenshot thing might work except it has to be done without user intervention and the whole report isn't on the screen at one time so it would be tricky. Sounds like a fun problem to solve - if someone else is paying. :) R -----Original Message----- From: accessd-bounces at databaseadvisors.com [mailto:accessd-bounces at databaseadvisors.com] On Behalf Of Dan Waters Sent: Wednesday, September 15, 2010 3:13 PM To: 'Access Developers discussion and problem solving' Subject: Re: [AccessD] Creating a Spreadsheet from a Report If you take a screenshot of anything, then paste that into a spreadsheet, the image will lay over all the cells, not get put into Cell A1. I have code to copy text from a field onto the clipboard, but that wouldn't help here. Good Luck! 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:56 PM To: 'Access Developers discussion and problem solving' Subject: Re: [AccessD] Creating a Spreadsheet from a Report Not sure how that would work - and get all the data into cells as opposed to everything in column A or worse, Cell A!. 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:25 PM To: 'Access Developers discussion and problem solving' Subject: Re: [AccessD] Creating a Spreadsheet from a Report Maybe there is a way that you could capture a screenshot of the report (or an approximation), and simply paste that picture onto the spreadsheet? That would of course avoid all the cell by cell programming. 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: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 -- 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