Re: Non-descriptive error message

Hi Dave. This sounds like something went wrong in the copying process, or
possibly that the copying disclosed a corruption that was previously
present.

1. You say you can see the module that Access can't find? Copy all the text
from the module, paste into Notepad, and save it as a text file for later.
(I assume this is the module of the report you were copying.)

2. Cose Access, and make a backup copy of the database so you get multiple
attempts at recovering this.

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

4. Compact the database to get rid of this junk:
Tools | Database Utilities | Compact/Repair

5. Close Access. 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"

6 Open Access (holding down the Shift key if you have any startup code).
Open the report in design view, set its HasModule propety to No. Save. Close
the report.

7. Compact again.

If the problem still exists, I would be interested to know if this
particular report name shows up in this query:
SELECT MSysObjects.Name
FROM MSysObjects
WHERE (((MSysObjects.Type)=-32764))
ORDER BY MSysObjects.Name;

If it doesn't you have struck a reasonably rare corruption where the 2
different lists of objects stored in Access 2000 and later don't match, i.e.
the list shown in this hidden system table, and the list exposed by
CurrentProject.AllForms. The solution will now be to create a new (blank)
database, turn off Name AutoCorrect, and import all the *other* objects.
Steps outlined in the first symptom in this article:
Recovering from corruption
at:
http://allenbrowne.com/ser-47.html

--
Allen Browne - Microsoft MVP. Perth, Western Australia.
Tips for Access users - http://allenbrowne.com/tips.html
Reply to group, rather than allenbrowne at mvps dot org.

"Dave" <Dave@xxxxxxxxxxxxxxxxxxxxxxxxx> wrote in message
news:79D283A8-2B08-4C38-9C85-04B324564AD8@xxxxxxxxxxxxxxxx
I am using Access 2000 on a XP Pro machine at work. I created a report
this
morning and had another open to copy some elements from and paste in the
new
one. General stuff: company logo and such. Was testing it out and
started
receiving the first of 2 messages.

1. "You cancel the previous operation" which may be the root cuase of
all
this. I did want to save the new form, but not the one I copied from.
After
all, I didn't make any intentional changes to the existing form.

2. Later on I started receiving the following error message "Module not
found" which is bogus since it is there and can get to it from the form's
property ***.

So I am totally confused and lost on this one. Probably didn't explain
everything you need to know, but that is the situation. Thanx for the
help.


.