Rocky Smolin
rockysmolin at bchacc.com
Tue Nov 9 11:39:53 CST 2010
I can ask. :) Means a few more hours of development time, of course. Thanks Rocky -----Original Message----- From: accessd-bounces at databaseadvisors.com [mailto:accessd-bounces at databaseadvisors.com] On Behalf Of Dan Waters Sent: Tuesday, November 09, 2010 8:56 AM To: 'Access Developers discussion and problem solving' Subject: Re: [AccessD] FW: Issues with Report Download Workaround for now? Have the export routine create and export to a 2nd spreadsheet for columns 257+ in Excel 2003. Then your client could open spreadsheet 1 in Excel 2007, and copy the remaining columns into it from spreadsheet 2. Dan -----Original Message----- From: accessd-bounces at databaseadvisors.com [mailto:accessd-bounces at databaseadvisors.com] On Behalf Of Rocky Smolin Sent: Tuesday, November 09, 2010 10:19 AM To: 'Access Developers discussion and problem solving' Subject: [AccessD] FW: Issues with Report Download Dear List: The client below is using my E-Z-MRP system, but had me develop a fairly elaborate export of some of the data into a spreadsheet in a format that they were used to using. While he agrees that using this spreadsheet is not the best solution, at the moment it was easier than trying to effect change among the users. However, he has now run into a problem: the 256 column limitation of Excel 2003, a limitation which apparently is greater in 2007. The app is in 2003 and, because it's a standard distributed product it is impractical to upgrade to 2007 (also, I'll be dipped if I'm going to be forced to develop and support a product in 2007 which runs like a spotted dog in 2003). So the question is how to reference the Excel 2007 library in the app instead of the 2003 Excel library? MTIA Rocky Smolin Beach Access Software 858-259-4334 Skype: rocky.smolin www.e-z-mrp.com <http://www.e-z-mrp.com/> www.bchacc.com <http://www.bchacc.com/> _____ From: Sent: Tuesday, November 09, 2010 1:24 AM To: 'Rocky Smolin' Subject: Issues with Report Download Rocky, Sorry for not being in contact regarding the download of the product structure that I mentioned before, I have been hard at it correction and inputting data into the system, for now I think we should not spend any more time on this download as I seem to be managing okay using the Database itself. I do however have a minor problem with the MRP download report. We have now inputted all of our products into the system, there are now 221 assemblies being used. On the MRP Shortage sheet in Excel there are a number of columns giving Part details, Stock, Shortages etc. Then the BOM's for all parts is cross tabbed to the right of the sheet and the where used qty updated against each item. Problem is we now have so many assemblies we have run out of columns in Excel, as we are using Excel 2003 version for the download and the column numbers go from A to IV this is 256 columns out of this 66 columns are taken up with data before you get to the assemblies then 221 assemblies that's 287 columns required with only 256 available in excel, the download creating an error at this point. We could of course economise in the first 66 columns as some of the old date columns could be taken out (Jan 2010 to Sept 2010 for example) but it would be better if we could run this download into Excel 2007 file rather than 2003 version as Excel 2007 has thousands of columns available. Currently we can not select an Excel 2007 version file from the front end. Can this be amended? Regards Howard -- 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