Rocky Smolin
rockysmolin at bchacc.com
Tue Nov 9 16:36:37 CST 2010
That would be waaay too easy. I don't have a machine with just 2007 though - my 2007 test bed has 2003 and 2007. Guess I'll have to configure another machine. But I'll ask the client what happens there. Rocky -----Original Message----- From: accessd-bounces at databaseadvisors.com [mailto:accessd-bounces at databaseadvisors.com] On Behalf Of Doug Steele Sent: Tuesday, November 09, 2010 12:06 PM To: Access Developers discussion and problem solving Subject: Re: [AccessD] FW: Issues with Report Download Hi Rocky: Have you tried your db on a system with Office 2007? I have Access 2003 database with Excel exports which work just fine when run on Office 2007 without any changes. The db is an .mdb file, not .mde. Access 2003 seems to automatically update the internal references from Excel 11 to Excel 12 (or is it 13?) as needed. Doug On Tue, Nov 9, 2010 at 8:19 AM, Rocky Smolin <rockysmolin at bchacc.com> wrote: > 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