D
datamgrbert
I have a function that is programmatically exporting reports to excel
spreadsheets and formatting them and so on... It has worked great until I
reached a little bit larger number of records (only a little over 1000) for
one of the reports. It started giving me an error while exporting. I
checked with fewer records and it still works...I found this error in Access
2002 and it showed "The file '|' already exists", but in Access 2003 it
showed a diff message with an error 5901, I think (for some reason it is not
giving those error, just an application error now).
I tried exporting it or analyzing it from Access and it shows to work, but
then the file doesn't exist when I go to where I saved it. It doesn't give
any errors...I can export the query just fine, but not the report and I need
the formatting and grouping. Please help!!!!
spreadsheets and formatting them and so on... It has worked great until I
reached a little bit larger number of records (only a little over 1000) for
one of the reports. It started giving me an error while exporting. I
checked with fewer records and it still works...I found this error in Access
2002 and it showed "The file '|' already exists", but in Access 2003 it
showed a diff message with an error 5901, I think (for some reason it is not
giving those error, just an application error now).
I tried exporting it or analyzing it from Access and it shows to work, but
then the file doesn't exist when I go to where I saved it. It doesn't give
any errors...I can export the query just fine, but not the report and I need
the formatting and grouping. Please help!!!!