PLEASE HELP! Regarding You cancelled previous Operation

J

JJames

Am getting this error (you cancelled previous operation), when I try to go
into code from a form by selecting the appropriate event and selecting the
'...' button. (the code is already present for the event). This error is
also appearing once I am in a module and the icon changes to an arrow while
in debug mode. I can do nothing to get the app. running. I am also getting
'module not found' at times. Why would a form open & start running open form
code, then stop and say module not found?
 
A

Allen Browne

Is there any other code running at the time?
For example, if another form is open and has code in its Timer event?

Do you get this error even if you open the form in *design* view?
If so, it sounds like a corruption, and these steps might help:

1. Uncheck the boxes under:
Tools | Options | General | Name AutoCorrect
Explanation of why:
http://allenbrowne.com/bug-03.html

2. Compact the database to get rid of this junk:
Tools | Database Utilities | Compact

3. Close Access. Make a backup copy of the file. Decompile the database by
entering something like this at the command prompt while Access is not
running. It is all one line, and include the quotes:
"c:\Program Files\Microsoft office\office\msaccess.exe" /decompile
"c:\MyPath\MyDatabase.mdb"

4. Open Access, and compact again.

5. Open a code window.
Choose References from the Tools menu.
Uncheck any references you do not need.
For a list of the ones you typically need in your version of Access, see:
http://allenbrowne.com/ser-38.html

6. Still in the code window, choose Compile from the Debug menu.
Fix any errors, and repeat until it compiles okay.

At this point, you should have a database where the name-autocorrect errors
are gone, the indexes are repaired, inconsistencies between the text- and
compiled-versions of the code are fixed, and reference ambiguities are
resolved.

If it is still a problem, the next step would be to get Access to rebuild
the database for you. Follow the steps for the first symptom in this
article:
Recovering from Corruption
at:
http://allenbrowne.com/ser-47.html
 
J

JJames

Thanks for your help Allen. While I ended up having to re-build, your
suggestions were very helpful & I am sure I will be able to use in the future.
 
Top