473,320 Members | 1,950 Online
Bytes | Software Development & Data Engineering Community
Post Job

Home Posts Topics Members FAQ

Join Bytes to post your question to a community of 473,320 software developers and data experts.

TransferSpreadsheet Delete Cells Error

I have one user who has spontaneously begun getting the run-time error 3435, "Cannot delete spreadsheet cells" in Access 2002. (The is an Access error and not an Excel error, as evidenced by the title of the error window, "Microsoft Access".) I cannot re-create this error on any other machine. Of course, the user can't remember anything unusual occurring on his machine prior to this error showing up.

The debugger shows that the error is occurring at the following line of code
Expand|Select|Wrap|Line Numbers
  1. DoCmd.TransferSpreadsheet acExport, acSpreadsheetTypeExcel9, "tblTempPolyBillingCust", "MonthEndBillingFromSAPA"
  2.  
I can't understand why this line of code would attempt to delete anything. When I do the same exact thing on my machine, not only is it successful, but it does not delete anything from tblTempPolyBillingCust. I've found occasional mentions of this problem online, but no solutions. Does anyone know what is happening here? Any help is greatly appreciated.
Sep 6 '07 #1
3 4536
Scott Price
1,384 Expert 1GB
This sounds like a corruption problem.

Try doing a decompile of the database (have a look here: http://allenbrowne.com/ser-47.html)

I'm assuming this is a multi-user frontend/backend setup?

If the code resides in this user's frontend copy, decompile then recompile his frontend, compact/repair and retry. (Make copies before trying this, and try it on the copy!)

Regards,
Scott
Sep 6 '07 #2
I'm ashamed to say the problem was that the Excel spreadsheet I was attempting to create already existed.

Thank you very much for your help. (If I hadn't gone back to his computer to try this, I wouldn't have found the doc.) I'll save your info for future reference, so thanks, again.
Sep 6 '07 #3
Scott Price
1,384 Expert 1GB
I'm ashamed to say the problem was that the Excel spreadsheet I was attempting to create already existed.

Thank you very much for your help. (If I hadn't gone back to his computer to try this, I wouldn't have found the doc.) I'll save your info for future reference, so thanks, again.

LOL... as I've said before: programming gives us many opportunities to get humbled :) Thanks for posting back with the solution.

Regards,
Scott
Sep 6 '07 #4

Sign in to post your reply or Sign up for a free account.

Similar topics

1
by: Nathan Bloom | last post by:
Hi, I have a procedure that transfer data from an Excel spreadsheet to an Access 2000 table. There is a start date and an end date in the range specified. One of the date fields transfers...
1
by: barma16 | last post by:
I've hit a bit of a brick wall here, and could use some advice. I have an Access application whose output is a four-tab Excel spreadsheet where three of the four tabs are the result of database...
3
by: user_5701 | last post by:
Hello, I'm getting an error with a Docmd.Transferspreadsheet line of code: DoCmd.TransferSpreadsheet acExport, acSpreadsheetTypeExcel2000, "tblTest", pathAndFilename, True The above line...
13
by: aleksandra_83 | last post by:
Hello, I have searched all over google groups and internet, but I have not found a solution to this problem that has worked. The solutions I found helped me single out the line that is causing...
0
by: robert.waters | last post by:
Hello, When executing DoCmd.TransferSpreadsheet to an .xls file that's being used as a datasource for a Word mail merge document, if that Word document is currently open, the TransferSpreadsheet...
13
by: Shelley | last post by:
Compare Current Year Worksheet with Previous Year Worksheet and if SSN exists in Current Year Worksheet & Not in Previous Year - Copy this Row from Current Year Worksheet & Paste into Previous Year...
0
by: David C | last post by:
I have a GridView with a Delete link and wondered where the best place was to check and cancel delete of a row/record that is bound to an SqlDatasource. I can use datasource Deleting event or...
2
by: RZ15 | last post by:
Hi, I am trying to use the transferspreadsheet command to transfer a table into an excel file i have. I'm using the following code: Private Sub cmdOK_Click() 'Run Make-Table query...
3
by: Icarus | last post by:
I'm using TransferSpreadsheet to import an Excel file in to MS Access 2003. DoCmd.TransferSpreadsheet acImport, 8, strTable, strFileName, True, "" One of the columns in the Excel file is a...
0
by: DolphinDB | last post by:
Tired of spending countless mintues downsampling your data? Look no further! In this article, you’ll learn how to efficiently downsample 6.48 billion high-frequency records to 61 million...
0
isladogs
by: isladogs | last post by:
The next Access Europe meeting will be on Wednesday 6 Mar 2024 starting at 18:00 UK time (6PM UTC) and finishing at about 19:15 (7.15PM). In this month's session, we are pleased to welcome back...
1
isladogs
by: isladogs | last post by:
The next Access Europe meeting will be on Wednesday 6 Mar 2024 starting at 18:00 UK time (6PM UTC) and finishing at about 19:15 (7.15PM). In this month's session, we are pleased to welcome back...
0
by: Vimpel783 | last post by:
Hello! Guys, I found this code on the Internet, but I need to modify it a little. It works well, the problem is this: Data is sent from only one cell, in this case B5, but it is necessary that data...
0
by: jfyes | last post by:
As a hardware engineer, after seeing that CEIWEI recently released a new tool for Modbus RTU Over TCP/UDP filtering and monitoring, I actively went to its official website to take a look. It turned...
0
by: ArrayDB | last post by:
The error message I've encountered is; ERROR:root:Error generating model response: exception: access violation writing 0x0000000000005140, which seems to be indicative of an access violation...
1
by: Defcon1945 | last post by:
I'm trying to learn Python using Pycharm but import shutil doesn't work
1
by: Shællîpôpï 09 | last post by:
If u are using a keypad phone, how do u turn on JavaScript, to access features like WhatsApp, Facebook, Instagram....
0
by: Faith0G | last post by:
I am starting a new it consulting business and it's been a while since I setup a new website. Is wordpress still the best web based software for hosting a 5 page website? The webpages will be...

By using Bytes.com and it's services, you agree to our Privacy Policy and Terms of Use.

To disable or enable advertisements and analytics tracking please visit the manage ads & tracking page.