S
SlydeRule
I developed an application in Access 2002 (SP1), and one of the forms allows
users to export data to Excel. This worked fine until we upgraded to Office
2003 (SP1). Now, any time we try to export data that contains Access 'memo',
or SQL Server 'text' fields I get this errror:
"The expression On Click you entered as the event property setting produced
the following error: Overflow"
None of the records have data that exceeds Excel's cell limit (4k, I think).
Most of the memo fields are empty, or contain a few characters, so there is
no reason I should be getting an 'Overflow' error.
Has anyone else experienced this problem ? Is there a solution ? As I said,
it works fine in Office 2002, but not in 2003.
Problem #2: In another part of this same Access 2002 application we export
numeric data to a formatted Excel spreadsheet, where the cells are formatted
as numeric. The data is exported to this 'template' file, then the user saves
a copy to their C: drive for further manipulation, then re-uses the same
template the following week. Normally, only one person uses this template
file, so sharing is not an issue.
If I export the data from my PC (Office 2002) the cells remain formatted as
numeric. This also works on some PC's with Office 2003. However, on some
other Office 2003 PCs, the data exports as text, and I have to click the
little green arrow (upper left corner) of each cell to 'convert to number'.
The only thing I haven't tried yet (for problem #2) is to compile the progam
in Access 2003 (I did try this for the first problem - no luck).
I can't figure out why this is happening. Any suggestions ?
Thanks...
users to export data to Excel. This worked fine until we upgraded to Office
2003 (SP1). Now, any time we try to export data that contains Access 'memo',
or SQL Server 'text' fields I get this errror:
"The expression On Click you entered as the event property setting produced
the following error: Overflow"
None of the records have data that exceeds Excel's cell limit (4k, I think).
Most of the memo fields are empty, or contain a few characters, so there is
no reason I should be getting an 'Overflow' error.
Has anyone else experienced this problem ? Is there a solution ? As I said,
it works fine in Office 2002, but not in 2003.
Problem #2: In another part of this same Access 2002 application we export
numeric data to a formatted Excel spreadsheet, where the cells are formatted
as numeric. The data is exported to this 'template' file, then the user saves
a copy to their C: drive for further manipulation, then re-uses the same
template the following week. Normally, only one person uses this template
file, so sharing is not an issue.
If I export the data from my PC (Office 2002) the cells remain formatted as
numeric. This also works on some PC's with Office 2003. However, on some
other Office 2003 PCs, the data exports as text, and I have to click the
little green arrow (upper left corner) of each cell to 'convert to number'.
The only thing I haven't tried yet (for problem #2) is to compile the progam
in Access 2003 (I did try this for the first problem - no luck).
I can't figure out why this is happening. Any suggestions ?
Thanks...