I am embarassed to say that I've been searching for the wrong file name. When I searched for the correct file name, I found that, in fact, it DID exist on the user's machine. Renaming it fixed the problem.
Thanks for your help and your excellent perception.
Unfortunately,no. My user with the problem definitely does not have the Excel file anywhere on his machine. Of the other two machines I tested (succesfully) one did and one did not have the Excel file in question.
I have one user who has spontaneously begun getting the error "Cannot delete spreadsheet cells" in Access 2002. (The error is an Access error and not an Excel error.) I cannot re-create this error on any other machine. Of course, the user can't remember anything unusual occurring on his machine...
For anyone who's interested, I solved my problem eventually by using code in place of the macro as follows:
Dim reportName As String
reportName = Application.CurrentObjectName
On Error Resume Next
DoCmd.OutputTo acOutputReport, reportName, acFormatSNP, , True
It seems...
I am working with an Access 2003 database. Since adding a timer event to check for idle time to a form, a custom toolbar button that creates a snapshot has stopped working properly. Until the first time the timer event procedure is run, the button works fine, but after that, it produces an error...
This site uses cookies to help personalise content, tailor your experience and to keep you logged in if you register.
By continuing to use this site, you are consenting to our use of cookies.